I tried to find the UDF dbo.fn_calculateJaroWinkler (for computing the Jaro Winkler distance) for sql server and couldn't find it. Does anyone wrote it and could share?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
http://www.sqlservercentral.com/articles/Fuzzy+Match/65702/
You may have to join sqlservercentral to view the page. There is a step by step explanation here on how to create the functions. I am actually using it myself now to do fuzzy logic. It works but it is a bit slow for large data sets. If you have any optimization tricks let me know!
