To use these functions, the Text Feature is required

Soundex(String s)

Computes the Soundex value of the string. 

Example
SELECT soundex("Hello") FROM Stream
=> "H400"

ColognePhonetic(String s)

Computes the Cologne Phonetic value of the string. 

Example
SELECT colognePhonetic("Hello") FROM Stream
=> "05"

Metaphone(String s)

Computes the Metaphone value of the string. 

Example
SELECT metaphone("Hello") FROM Stream
=> "HL"

Levenstein(String s1, String s2)

Computes the Levenstein Distance of two strings. 

Example
SELECT levenstein("Hello", "Hallo") FROM Stream
=> 1

  • No labels