Detect duplicate reference numbers

Finding duplicates would also address these threads. Looking at them I wonder if having this as a search option in custom reports maybe the most efficient.