Similarity

Computes a similarity value of two strings in SQL Server

Syntax:

SELECT SQLHTTP.net.HashString ( @Algorithm, @String1, @String2 )

Arguments:

Name	Type	Description
@Algorithm	varchar(5)	One of the following Algorithm: JW and DL (for Jaro-Winkler and Damerau-Levenshtein, respectively)
@String1	nvarchar(MAX)	First string for which to compute similarity. These value are case sensitive even in case-insensitive SQL Server instances
@String2	nvarchar(MAX)	Second string for which to compute similarity. These value are case sensitive even in case-insensitive SQL Server instances

Return Type:

numeric(27,7)

Sample Usage:

Jaro-Winkler:


SELECT SQLHTTP.net.Similarity('JW', UPPER('kitten'), UPPER('sitting'))

SELECT SQLHTTP.net.Similarity('JW', UPPER('kitten'), UPPER('sitting'))

--------------

0.7460317

Damerau-Levenshtein:


SELECT SQLHTTP.net.Similarity('DL', UPPER('kitten'), UPPER('sitting'))

SELECT SQLHTTP.net.Similarity('DL', UPPER('kitten'), UPPER('sitting'))

--------------

3.0000000