1

Anybody have experience with fuzzy matching with sql server fulltext indexes on names like searching for Bob Thornton would return results like Bobby Thornton?

I guess Lucene.Net and Solr could be used for this as well but nice to do it all in the database.

Thank you in advance.

cws
  • 158
  • 3
  • similar question: [http://stackoverflow.com/questions/921978/fuzzy-matching-using-t-sql](http://stackoverflow.com/questions/921978/fuzzy-matching-using-t-sql) – Prescott Mar 24 '11 at 17:19

1 Answers1

2

I'm not sure whether this counts as 'all in the database', but SSIS has a fuzzy matching block which provides this functionality.

David Underwood
  • 4,908
  • 1
  • 19
  • 25