SQL Server中的Jaro Winkler

本文介绍了SQL Server中的Jaro Winkler的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我试图为SQL Server找到UDF dbo.fn_calculateJaroWinkler(用于计算Jaro Winkler距离).有人写过并且可以分享吗?

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?

推荐答案

www.sqlservercentral/articles/Fuzzy+Match/65702/

您可能必须加入sqlservercentral才能查看该页面.这里有一个关于如何创建功能的分步说明.我实际上现在正在自己使用它来进行模糊逻辑.它可以工作，但是对于大型数据集来说有点慢.如果您有任何优化技巧，请告诉我！

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!