Does anyone know if the sql-server 7.0 contains functions for phonetic
I have a table with a field called 'BandName'. When a user wants to
search for 'Dire Straits' I run the following query: SELECT * FROM
<table> WHERE CONTAINS(BandName, ' "dire straits" ')
The query returns the expected results and everything is ok but what if
the user enters 'Dyre Straits'?
A query like the above one will not find a matching record but since the
user obviously just misspelled the search string it would be nice if the
sql-server could ignore at least slight misspellings.
Can anyone help me?