I have been experimenting with SearchKit - it has proved really useful. Thanks to everyone contributing.
One of my fields on the form is a search on the Display Name of an orgnisational contact:
All other search fields work really well, but the school name search will take any instance of a string of chars and return records containing that string. We deal with schools, so if I search on Mary, this will also return records with Primary or Maryland. Users tend to know the school they are after, but church schools in particular have a lot of *St Mary'*s etc. This is of course just one example. Capitalisation is not an issue, but hundreds of records are!
So, is there a 'whole word only' setting anywhere one can turn on and off?