| Parameter | Type |
|---|---|
x | string |
y | string |
Returns: decimal
Example
query:
SELECT SOUNDEX_DISTANCE("foo", "too")results:
| soundex_distance |
|---|
| 3 |
SOUNDEX_DISTANCE
A string comparison function to estimate the similarity of two strings, based on their pronunciation in English. The result of this function ranges from 0 (no similarity) and up, with larger results for longer strings. A full description of the soundex algorithm can be found here: https://en.wikipedia.org/wiki/Soundex.