Very Computer

Hi.

Does anyone know if the sql-server 7.0 contains functions for phonetic
searches?

Example:
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?

Soundex searches will probably make it into a future release, but is not
part of the product now. You could just make some clever use of wildcard
pattern matching.

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com

Quote:> Hi.

> Does anyone know if the sql-server 7.0 contains functions for phonetic
> searches?

> Example:
> 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?