User Similarity Search
User similarity search is a technique that can be used to identify other users who have similar characteristics
01.
Finding Similar Users
This example uses a xbox_players table to find the most similar users to a specified user.
- We
SELECTdata from thexbox_playerstable to create a CTE calledcharacteristics. - The
SIMILAR_TOfunction is used to create asimilaritycolumn for each row in thecharacteristicstable based on how similar they are to the usersPoNgEbOb. - To look at the most similar, the resulting rows are then ordered by the
similaritycolumn in descending order. We return all of the columns from thecharacteristicstable (* indicates to return all columns), as well as thesimilaritycolumn. - We
LIMITthe returned results to show the most similar user.
The final result shows the user most similar to sPoNgEbOb ... perhaps you'll find PaTrIck!