The word "duplicate" would make you think this was an easy task. But, as dfortney has described, what people really want is a way of sorting out their collection to find different bit rates, formats, and versions of songs.
Getting your library cleaned up is a really good first step in all of this. It can be very helpful to build some panes views that let you see different things. For example, showing songs by bit rate. Panes has a feature that will sort things into "buckets". So, as an example, you could have bit rate buckets that were 0-128kbps, 128-256 kpbs, etc. This way you can find the low resolution stuff in your collection and decide if it's worth keeping at all. My answer, for 128k and below is a resounding "no" in almost all cases.
As you explore your collection using filters, you are probably going to find directory trees that you remember creating, but had forgotten about. This can help you again decide to keep or delete whole chunks of your library.
At some point you can go through some duplicate finding. I've built several Panes views that are designed specifically for this task. See attached screen shot for an example. You could easily add more Panes to this for bit rate and others. I have had several versions of this, some of which had that feature.
The tasks I'm outlining here are really a library audit. Which is really what you are asking for. It's really what most people mean when they say "duplicate finder" or "duplicate management". I've performed this auditing process on at least one large collection. It was extremely time consuming. I think I spent 20 to 30 hours on that one.
When a collection is large and not consolidated, there is a LOT to sort out.
Starting with some good Panes views is very helpful. They can do a lot more than most people think.
Brian.