A long time ago, I have seen somewhere a sample on how to convert some text into soundex codes. Now that I need such a function (for Delphi) I can't seem to find that article anymore.
Does anybody know about such a function with which I could get eg surnames of persons which sound similag (eg Worthwald and Worthwood).
Also a long time ago, I had a tool which I used to scan my Database for duplicate or similar records. It was a commercial product, but I downloaded a demo of it, and I can't seem to find it anymore, nor the link to the website where it came from.
If anybody could help me find back that tool, I'm willing to award him 100 points for that. I need this tool because I have to convert a Access DB to SQL Server this week, but the old DB contains many duplicate records and records which are similar, and with that tool, I could scan my tables and it would give me the similar or matching records.
Please Help me