need to identify the same people based on their (misspelled) names
hello
we have a table with persons and their name (first name and last name in 1 field) ;
the names are often mispelled, so some string comparison is required;
can you advise what the best approach would be to uniquely identify the same people?
so far i have only found this functions :utl_match.jaro_winkler_similarity and SOUNDEX
is there anything else 'out of box' i could make use of to implement the above?
i appreciate any tips
thanks very much
rgds