Nearest match searching?

Nearest match searching?

Post by Ben Fidg » Wed, 04 May 2005 02:26:52


I need to allow users to search records for Hotel names and can't rely on
them spelling names properly. For example, Park Lane could be mispelled Pak
Lane, Park Lne, Pakr Ln etc.

Does full-text indexing allow me to return the closest approimations to a
given search query with misspelled search terms?

Kind regards


Nearest match searching?

Post by Hilary Cot » Wed, 04 May 2005 03:19:16

no, but have a look at Levenstein Edit Distance. In SQL 2005 Integration
Services - does fuzzy matching which is ideal for what you are looking for.
Hilary Cotter
Looking for a SQL Server replication book?

Looking for a FAQ on Indexing Services/SQL FTS