You want an app that will identify the potential duplicates, put them in an album or mark them with a keyword for easy retrieval and deletion by you. You don't want one that does the deletion itself for obvious reasons.
I've run tests on the following apps with these results:
PhotoSweeper - $9.99 - Demo version available.
PowerPhotos - $29.95
PowerPhotos is the iPhoto Library Manager version for Photos and is very powerful. Although more expensive I would recommend it as it has more capabilities than the others like the capability to merge Photos libraries or copy photos, both original and edited versions, along with their metadata between libraries.
PhotoSweeper compares bitmaps and/or histograms so it can detect duplicate images even if they have different file sizes, file names, image sizes and capture dates.
I've found both to be safe, leaving the final decision to delete or not up to the user.