Toad World® Forums

Using Toad for De-duping Party type data

I have a bunch of "Party" name and address data where I am trying to find a remove duplicates - like Michael and Micheal being the same. Smithtown Ave and Smithtown Avenue being the same. Does Toad for Oracle have this capability. There are other products like WinPure that do this but I cannot install a new product in the client that already has Toad so wondering if this functionality exists.

Toad doesn't have anything like that, sorry.

There is a Toad product that may be of some assistance here... it's called Toad Data Point, and the Professional Edition of that product contains a Data Profiling engine that can use fuzzy phonetic logic to find such "duplicates"... at least by column values that have similar phonetic sound...hope this helps...