I know of 2 ways to delete duplicates from a Notion database.
This option is very flexible. You can set granular rules for how to identify duplicates. However it requires editing your database and manually setting up the duplicate detection.
Here is a tutorial of this approach, by @NotionWorkflow:
This uses the official Notion API. You don’t need to modify your database to use this, or setup a second database with formulas. It requires far fewer steps.
The disadvantages are that: 1. It take some time, because it must do the deletions one at a time (Notion’s API doesn’t support bulk actions yet), 2. It currently only matches on title.
Try it out: Delete Duplicates