PolarDB-for-PostgreSQL
21 строка · 589.0 Байт
1CREATE EXTENSION fuzzystrmatch;
2
3
4SELECT soundex('hello world!');
5
6SELECT soundex('Anne'), soundex('Ann'), difference('Anne', 'Ann');
7SELECT soundex('Anne'), soundex('Andrew'), difference('Anne', 'Andrew');
8SELECT soundex('Anne'), soundex('Margaret'), difference('Anne', 'Margaret');
9
10
11SELECT levenshtein('GUMBO', 'GAMBOL');
12SELECT levenshtein('GUMBO', 'GAMBOL', 2, 1, 1);
13SELECT levenshtein_less_equal('extensive', 'exhaustive', 2);
14SELECT levenshtein_less_equal('extensive', 'exhaustive', 4);
15
16
17SELECT metaphone('GUMBO', 4);
18
19
20SELECT dmetaphone('gumbo');
21SELECT dmetaphone_alt('gumbo');
22