Before you purchase software (such as "Fuzzy Duplicate Finder") to determine the duplicate part numbers in your storeroom, use the excel spreadsheet to break down the part numbers and descriptions into five categories---part number, noun, attribute, specifications, and further descriptions.
Once sorted it becomes very clear what part numbers are similar, but may be different. It enables you to physically check a few items to see if there is an actual match. Once found the duplicate part can be consolidated in one bin, and removing the duplicate part number from the system.
Tip Provided by: Dan Dewald - Reliability Professional