Search notes:

Oracle: UTL_MATCH

Functions

`edit_distance`	Levenshtein distance (number of changes required to transform string-1 into string-2)
`edit_distance_similarity`	Similar to `edit_distance_similarity`, but returns a value between 0 (no match) and 100 (perfect match).
`jaro_winkler`	Measure of agreement between string-1 and string-2
`jaro_winkler_similarity`	Similar to `jaro_winkler`, but returns a value between 0 (no match) and 100 (perfect match)

Example

create table tq84_utl_match (
  s  varchar2(20)
);

insert into tq84_utl_match values ('Rene'    );
insert into tq84_utl_match values ('René'    );
insert into tq84_utl_match values ('Ren'     );
insert into tq84_utl_match values ('rene'    );
insert into tq84_utl_match values ('Rne'     );
insert into tq84_utl_match values ('found'   );
insert into tq84_utl_match values ('pound'   );



select
  a.s,
  b.s,
  utl_match.edit_distance           (a.s, b.s) ed,
  utl_match.edit_distance_similarity(a.s, b.s) eds,
  utl_match.jaro_winkler            (a.s, b.s) jw,
  utl_match.jaro_winkler_similarity (a.s, b.s) jws
from
  tq84_utl_match a cross join
  tq84_utl_match b;



drop table tq84_utl_match purge;

Github repository Oracle-Patterns, path: /Installed/utl/match/test.sql

Oracle: UTL_MATCH

Functions

Example

See also