Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
To use these functions, the Text Feature is required
Soundex(String s)
Computes the Soundex value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT soundex("Hello") FROM Stream => "H400" |
ColognePhonetic(String s)
Computes the Cologne Phonetic value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT colognePhonetic("Hello") FROM Stream => "05" |
Metaphone(String s)
Computes the Metaphone value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT metaphone("Hello") FROM Stream => "HL" |
Levenstein(String s1, String s2)
Computes the Levenstein Distance of two strings.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT levenstein("Hello", "Hallo") FROM Stream => 1 |
Table of Contents |
---|