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

query:

SELECT JARO_WINKLER_DISTANCE("foo", "too")

results:

jaro_winkler_distance
0.7778