- Regular Expressions where used to find patterns and remove and alter to enable a standardization of names and addresses
- Equi-joins and other join types to match
- Soundex or Metaphone function in combination with other matches to enable fuzzy matches
- Jaro-Winkler, Levenshtein and Distance functions for fuzzy matching
- ETL Tool Functionality which further extends the base database functionality
I will be presenting this solution at COLLABORATE13 in Denver in April, and this entry should help you as you consider an alternative approach to matching which will be critical to your MDM solution.