Develop Macro to Find Duplicates Which May or May Not Be Exact Matches

Requirement: Develop a macro or recommend a solution to find duplicates which may or may not be exact matches (here after referred to as "duplicates") and display duplicates in groups. Characteristics of duplicates 1) Duplicates can appear in any column from column G to J on worksheet "Data" of the attached file. 2) Duplicates contain the same alpha numeric characters and at least one (1) common word in column G or column H 3) Duplicates contain the same alpha numeric characters but may be separated by space, dash, full stop, comma, brackets etc as shown in "Duplicate Group 1", "Duplicate Group 3" and "Duplicate Group 4" in the "Answer" worksheet of the attached file. 4) Duplicates contain the same alpha numeric characters but may begin or end with different alpha numeric characters as shown in "Duplicate Group 2" and "Duplicate Group 4". 5) Duplicates shall contain a minimum of four (4) same characters Characteristics of non duplicates 1) Non duplicates have the same characteristics as a duplicate but do not have common word(s) in column G or column H on worksheet "Data" of the attached file. Output 1) Duplicates are displayed in groups as shown on "Answer" worksheet of the attached file. 2) Duplicate alpha numeric characters are in bold and red. 3) Duplicates may have the same alpha numeric characters but are grouped based on common word(s) in column G or H. In worksheet "Answer", "Duplicate Group 3" and "Duplicate Group 6" have the same alpha numeric characters "4K55" as shown in bold and red but are grouped differently whereby "Duplicate Group 3" is for "Basket Strainer" and "Duplicate Group 6" for "Snubber" 4) Non duplicates are grouped in sequence of alpha numeric characters as shown in "Non duplicates" of worksheet "Answer"