File Library

Fuzzy String Matching in Oracle
Topic: The Database
Owner: Dominic Delmolino
Date: 2013-05-27
Subtopic: Tips and Techniques

Many database developers are familiar with the basic SOUNDEX function used to provide basic similarity matching for names. In this presentation, we'll go beyond SOUNDEX to examine more advanced approaches for string and name matching, including details about the UTL_MATCH built-in package. We'll also explore implementations of the NYSIIS, MetaPhone and Caverphone phonetic matching algorithms in SQL and PL/SQL. Finally we'll explore how combinations of these techniques can be used for data cleansing in large scale environments.

Download File   Delmolino_fuzzymatching_presentation.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database