JARO_WINKLER_DISTANCE

A string comparison function to estimate the similarity between two strings. The result of this function ranges between 0 (no similarity) and 1 (a perfect match). A full discription of the Jaro-Winkler distance function can be found here: https://en.wikipedia.org/wiki/Jaro%E2%80%93Winkler_distance.

Parameter	Type
`x`	string
`y`	string

Returns: decimal

Example

query:

SELECT JARO_WINKLER_DISTANCE("foo", "too")

siyeh/sql-crm-example-data Run query Copy code

results:

jaro_winkler_distance
0.7778