Here is another solution to this issue. It requires one relationship that you might already have.
Let’s say you have two tables: Contacts and Companies and you want to detect duplicate Emails in the Contacts table. The initial structure should look s...