René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

utl_match

Procedures/Functions

edit_distance

function edit_distance returns binary_integer (
 s1                                 in                 varchar2        ,
 s2                                 in                 varchar2        
);

edit_distance_similarity

function edit_distance_similarity returns binary_integer (
 s1                                 in                 varchar2        ,
 s2                                 in                 varchar2        
);

jaro_winkler

function jaro_winkler returns binary_double (
 s1                                 in                 varchar2        ,
 s2                                 in                 varchar2        
);

jaro_winkler_similarity

function jaro_winkler_similarity returns binary_integer (
 s1                                 in                 varchar2        ,
 s2                                 in                 varchar2        
);

Links

See also soundex and fuzzy search with PL/SQL.