| Parameter | Type |
|---|---|
x | string |
y | string |
Returns: integer
Example
query:
SELECT LEVENSHTEIN_DISTANCE("foo", "too")results:
| levenshtein_distance |
|---|
| 1 |
LEVENSHTEIN_DISTANCE
A string comparison function to estimate the similarity between two strings. The result of this function is the number of edit operations (insertions, deletions, or modifications) to convert one string into another. A full discription of the Levenshtein distance function can be found here: https://en.wikipedia.org/wiki/Levenshtein_distance.