Page History

To use these functions, the Text Feature is required

Soundex(String)

Computes the Soundex value of the string. 

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

ColognePhonetic(String)

Computes the Cologne Phonetic value of the string. 

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

Metaphone(String)

Computes the Metaphone value of the string. 

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

Levenstein(String, String)

Computes the Levenstein Distance of two strings. 

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