Page tree
Skip to end of metadata
Go to start of metadata

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