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.
I'm not sure whether this counts as 'all in the database', but SSIS has a fuzzy matching block which provides this functionality.
精彩评论