I would like to implement Fuzzy grouping in TSQL . I have a classID and corresponding class sub groups and need to find any potential duplicates in sub groups and if possible find the %age difference between duplicate values. Can this be achieved in T-SQL.
For example : Class1 has multiple materials and I need to find potential duplicates in it.
![]()