开发者

Fuzzy match on names

开发者 https://www.devze.com 2023-02-20 02:40 出处:网络
Anybody have experience with fuzzy matching with sql server fulltext indexes on names like searching for Bob Thornton would return results like Bobby Thornton?

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消