Oracle Database - PL/SQL - Using utl_match functions to compare string similarity
Table of Contents
1 - About
The four functions included in the package use different methods to compare a source string and destination string, and return an assessment of what it would take to turn the source string into the destination string.
2 - Articles Related
3 - Functions
3.1 - EDIT DISTANCE
Returns the number of changes required to turn the source string into the destination string using the Levenshtein Distance algorithm.
3.2 - EDIT DISTANCE SIMILARITY
Returns an integer between 0 and 100, where 0 indicates no similarity at all and 100 indicates a perfect match.
3.3 - JARO WINKLER
Instead of simply calculating the number of steps required to change the source string to the destination string, determines how closely the two strings agree with each other and tries to take into account the possibility of a data entry error.
3.4 - JARO WINKLER SIMILARITY
Returns an integer between 0 and 100, where 0 indicates no similarity at all and 100 indicates a perfect match but tries to take into account possible data entry errors.
4 - Reference
- Source : $ORACLE_HOME/rdbms/admin/utlmatch.sql