Remove duplicate images

So since they are scans of slide film the ones with Edit in the name are ones you have sent to PS from LR and then saved. They are not really Duplicates.

With the absence of raw images, I suspect your TIF files (like  image043.tif) may have come from a scanner. Yes/no?

As stated above, the files with "-edit" in the filename (like image043-edit.tif) would have come from an edit in Photoshop (or external editor).

You could do a Filter search for files that contain the word "edit" in the filename. Check visually to see if any have important editing done, (any [+/-] badges?) and if not, simply select all these '-edit' files and [Delete].

The one with the -edit included in the file name is one that you send to PS from LR and then did a normal Save, Ctrl + s or File menu item and Save option. The -edit is the LR default for doing that.

the one with just the .tif extension is one that you might of opened in PS, without using LR to Send it to PS or even if you used LR to send it ot PS, Edit In PS, you use the Save As command in PS, and then saved it in tif format and to the same folder as the original. Although they may appear to be the same file they were created differently and may have different edits in both LR and PS. Only you can tell whetehr it is or sin't really different.

AFAIK there is no Feature in LR to remove duplicates. There may be an add-on, plugin, that might do that.

I suggest you change you View Options settings to show the file name in the header of the grid cell that way you can see how many copies there are of each image.