Has anyone tried to find inventory items that are duplicated but not exactly - i.e. “soft” matches?

We have many items and many of them are redundant. The records represent the same  item but the key is not exactly duplicated, of course. We need to set some parameters like similar  or identical descriptions, matching Item Type, Class, Price, etc. The idea  is to find near-duplicates and present them on a page to be reviewed and updated/inactivated

If someone has already built this or a similar query some help and ideas would be appreciated!