cws
Reputation: 158
Fuzzy match on names
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.
Upvotes: 1
Views: 966
Answers (1)
David Underwood
Reputation: 4966
I'm not sure whether this counts as 'all in the database', but SSIS has a fuzzy matching block which provides this functionality.
Upvotes: 2
Related Questions
- Partial/Abbreviated Name Matching
- Fuzzy substring matching in a string Lucene.NET
- Doing partial match on name fields in SQL Server
- Searching names with Apache Solr
- SQL Fuzzy Matching
- Fuzzy logic search for full names
- fuzzy search with lucene
- Lucene Fuzzy Match on Phrase instead of Single Word
- Sql Server Full Text: Human names which sound alike
- Lucene.NET (strings fuzzy matching)