I need to find duplicates in a table. But the Access' find-duplicates-wizard is not enough. If, for example, I have a patient name 'Smith', and it is duplicated in another record but with some kind of typing mistake - like 'Smigh', I need some kind of a mechanism that will consider 'Smigh' as a duplicate of 'Smith', that will warn me that 'Smigh' MIGHT be a duplicate of 'Smith'. Maybe it isn't - maybe there's a real patient whose name is Smigh, but I want to be warned that it could be a duplicate with typing mistake. Any suggestions? by SQL satement? or by VBA code?