Duplicate Checking

DOES ANYONE USE THIS FUNCTION?  

It slows my work to a halt its a hindrance.  Any way to speed it up as the idea is good just the execution on the software has never worked (experience of different companies on difference computers over the years)

Thanks