Hello,
I have a table with tens of thousands of Items. Each Item has 12 attributes (separate field for each attribute).
I would like to have the user select one item and get a resulting list of the most similar items based on matching attributes.
I am thinking I need to use a full outer join and LevenshteinDist on a concatenated field of the 12 attributes. I am hoping there is a better way since that will be a massive table.
Another way might be to compare each of the 12 attribute fields separately in a full outer join and then total up the # of matching attributes (certainly this would be more helpful in the real world scenario).
Hoping someone has a more elegant (efficient) solution?
