In SQL 2014, I have product names in one of the columns of a large 30 GB product table. Based on a search term, I need to find all records for which one of the terms in the product name contains or is very similar with this query term. so I was thinking at adding full text on this column to tokenize each term of this table column. But not sure if I can search for term similarity using the full text.
Eg: looking for "Richmond", where row 3 is very similar (missing the last 'd') and row 4 is also similar (but missing the 'h' in the middle)
-123 Richmond street
-North Richmond Ln
-East Richmon Crescent
-South Ricmond Drive, 876
Can you recommend a solution/link for this.