Kashif Masood Hashmi Blog

UTL_MATCH : String Matching by Testing Levels of Similarity/Difference

The UTL_MATCH package was introduced in Oracle 10g Release 2, but first documented (and therefore supported) in Oracle 11g Release 2.

To See The Details Follow the following Link

https://oracle-base.com/articles/11g/utl_match-string-matching-in-oracle

My Query Example

SELECT 'MUHAMMAD' COL1,

       'MOHAMMAD' COL2,

       UTL_MATCH.JARO_WINKLER_SIMILARITY('MUHAMMAD', 'MOHAMMAD') AS JWS

  FROM DUAL

UNION

SELECT 'MOHAMMAD',

       'MEHMOOD',

       UTL_MATCH.JARO_WINKLER_SIMILARITY('MEHMOOD', 'MOHAMMAD') AS JWS

  FROM DUAL

UNION

SELECT 'MARRY',

       'MARRIE',

       UTL_MATCH.JARO_WINKLER_SIMILARITY('MARRY', 'MARRIE') AS JWS

  FROM DUAL;

OUTPUT

	COL1	COL2	JWS
1	MARRY	MARRIE	89
2	MOHAMMAD	MEHMOOD	74
3	MUHAMMAD	MOHAMMAD	92