This is a great article, thank you so much for posting. I am trying to implement a similar solution in my organization, and was doing some testing on your function. I found some odd results when comparing strings that use the same letters. I am wondering if these results should be expected in these cases?

DECLARE @string1 VARCHAR(100), @string2 VARCHAR(100)

SET @string1 = 'sottosanti'

SET @string2 = 'ottositnas'

PRINT dbo.JaroWinkler(@string1, @string2)

GO

DECLARE @string1 VARCHAR(100), @string2 VARCHAR(100)

SET @string1 = 'margin'

SET @string2 = 'arming'

PRINT dbo.JaroWinkler(@string1, @string2)

Thanks,

Adam Sottosanti