Optimize Table Matches Based on Count of Matches

How to Get Random Rows Without Duplicates in SQL Server Using Advanced Window Functions