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)
Computes the Soundex value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT soundex("Hello") FROM Stream
=> "H400" |
ColognePhonetic(String)
Computes the Cologne Phonetic value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT colognePhonetic("Hello") FROM Stream
=> "05" |
Metaphone(String)
Computes the Metaphone value of the string.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT metaphone("Hello") FROM Stream
=> "HL" |
Levenstein(String, String)
Computes the Levenstein Distance of two strings.
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT levenstein("Hello", "Hallo") FROM Stream
=> 1 |
Table of Contents |
---|