Is there somehow a way to find the questions which are the most referred to when closing duplicates?

Question

Duplicated questions are a thing we want to avoid on these sites. However, it will happen anyway, this is why we get the "exact duplicate" close reason.

There are some questions which are coming back frequently, and they are closed as duplicate of an initial one, usually. For questions which are coming back the most, it could be good to take over the original question to improve it (because often it was badly asked, compared to a duplicate, which is finally a bit silly, but it has the most answers). Eventually, it could be nice to even make some CW, so that they become references.

Besides the fact of "Is it a good idea to take over a question someone else asked, for the greater good?", there is the question of "how to find these?". I know that so far, the link to duplicate is only included in the question, which is potentially editable, so it's not a solid reference.

Besides this constraint, is there a way to find which are the questions which are the most referred to in a duplicate context?

I know it is not possible with the current search tools, but maybe it could be with a data dump? As a further idea, would this have an interest in being formalized (like for example including the main duplicate link to the close description), and eventually have a "top duplicates" accessible in moderation tools?

Answer 1

The improved close-as-dupe page shows the similar posts and count of posts linked to as the duplicate to the similar post.

Answer 2

These only count those dupes where the "possible duplicate" link(s) where inserted automatically; this feature hasn't always been in the site. I just used a very simple matching algorithm, too, so take the numbers with a pinch of salt. Only shows the top twenty (for Server Fault only those with more than one dupe). Based on the February data dump.

Meta:

• 19 dupes: What was Stack Overflow built with?
• 11 dupes: Find out which question/answer awarded you the badge
• 11 dupes: Encouraging people to explain down-votes
• 10 dupes: Make recent activity and responses show new comments on questions/answers I have commented on (even if I don't own them)
• 8 dupes: Where is the FAQ?
• 8 dupes: Trilogy Portal: Community Colloboration
• 7 dupes: Any way to send a personal message to another user?
• 7 dupes: Serverfault cut off/truncated on long post?
• 7 dupes: What are "Community Wiki" posts on Stack Overflow?
• 6 dupes: How does "Reputation" work on Stack Overflow?
• 6 dupes: Consecutive Day Count in profile
• 6 dupes: Preview should match the posted view
• 6 dupes: Add the ability to ignore users
• 6 dupes: Should downvoting be allowed on comments?
• 6 dupes: Has Stack Overflow been haiku-hacked?
• 5 dupes: Is there a page that displays questions with zero answers?
• 4 dupes: Stack Overflow Clones?
• 4 dupes: What are the architecture details of Stackoverflow?
• 4 dupes: Should we be allowed to edit comments?
• 4 dupes: Isn't the "vote too old to be changed" a little too eager?

Stack Overflow:

• 8 dupes: What's your take on the programming language Go?
• 7 dupes: How do the equality (==) and identity (===) comparison operators differ?
• 7 dupes: What IDE to use for Python
• 6 dupes: What is the single most influential book every programmer should read?
• 6 dupes: Javascript === vs == : Does it matter which "equal" operator I use?
• 5 dupes: What should a developer know before building a public web site?
• 5 dupes: Best Java book you have read so far
• 5 dupes: What PHP framework would you choose for a new application and why?
• 5 dupes: Best way to stop SQL Injection in PHP
• 5 dupes: What is the best regular expression for validating email addresses?
• 5 dupes: What is the easiest language to start with?
• 5 dupes: ASP.NET: Web Site or Web Application?
• 5 dupes: Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
• 4 dupes: Is there a performance difference between i++ and ++i in C++?
• 4 dupes: Why not use tables for layout in HTML?
• 4 dupes: Why does one often see "null != variable" instead of "variable != null" in C#?
• 4 dupes: What does the @ symbol before a variable name mean in C#?
• 4 dupes: Properties vs Methods
• 4 dupes: What bug tracking software do you use?
• 4 dupes: Can Go compiler be installed on Windows?

Super User:

• 11 dupes: Which is the best application to Sync two folders?
• 8 dupes: Installing Mac OS X on Non Apple Hardware
• 7 dupes: Free antivirus solutions for Windows
• 5 dupes: Best program to visualize file system usage on Windows?
• 5 dupes: How to install Ubuntu, Windows XP and Windows 7 from scratch as triple-boot system
• 4 dupes: Replacement for Windows Explorer?
• 4 dupes: What is your favourite service for bloggers?
• 4 dupes: Best opensource FTP software?
• 4 dupes: What is the best software for desktop recording?
• 4 dupes: Windows XP and RAM 3.5GB+
• 4 dupes: What are some "must have" Windows programs?
• 4 dupes: Where to purchase computer parts?
• 4 dupes: Is it possible with Google searches to ban any and all results from a domain?
• 4 dupes: Windows backup by Imaging
• 4 dupes: Daily-Reading for General Geekiness.
• 4 dupes: Compaq Presario 6608Au Blue Screen problem
• 4 dupes: Free Windows ISO Mounting Software
• 4 dupes: Which Windows tweaks do you use and they actually work?
• 3 dupes: Free DVD recorder
• 3 dupes: "Must Have" Windows Mobile Software

Server Fault:

• 3 dupes: "Extra Printers" in XP under Fusion 2.05
• 2 dupes: What a beginner should know/learn for sysadmin job?
• 2 dupes: SQL Compliance Manager
• 2 dupes: Best Windows remote support / screen sharing tools?
• 2 dupes: Who is a good registrar these days?
• 2 dupes: hosting your own DNS
• 2 dupes: what's the syntax for Accessing smb/windows shares via alternative ports?
• 2 dupes: Sharing Domain name between domain controller and webserver

Answer 3

This is a very good idea!

I can see a big potential for this. For instance on Super User, there are like a gazillion questions about "syncing 2 folders" and dupes come in almost every day. I still need to look for the original though. So having a list of all these kind op "mother-dupes" would be awesome.