Functional extension with many extra options. It checks the container of each tab, so there's no risk of closing tabs with the same URL, but with different credentials (be careful, though, that if a site manages states using cookies, local storage or anything else that doesn't change the URL, the extension will consider the tabs as duplicates and close them.) It indicates how many duplicate tabs are there in a window. It has an option to keep the oldest tab, instead of the newest. If offers three optional hotkeys to remove duplicate tabs.

Useful as alternative to "Don't Open Duplicate tabs"

it shows the number of the duplicate tabs, and close all duplicate tabs when pressed.