Jaro Winkler in sql server

2019-09-06 15:49发布

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条回答
孤傲高冷的网名
2楼-- · 2019-09-06 16:10

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!

查看更多
登录 后发表回答