Use the Compare|Data Duplicates to find duplicates of data within one schemas. This makes it easy to clean up your schemas of erroneous entries.
Find Duplicates on all columns: Check the Find duplicates on all columns option button.
Find duplicates on just selected columns: Check the Find dupes of selected columns option button and then select one or more columns in the column list.