I'm trying to find similar values for a single column. I have a column 'name' and I've used a query to find duplicates, however I'm fairly certain that there are similar...entries? Not duplicates per say, but rather typos?
I realise I myself am not exactly sure what I'm trying to do, an example would be: table.name - apple and I want to be able to sort all table.names that are similar to it, like 'applle'.
To note: I dont want to compare table.name with a certain word but rather sort all instances of table.name that are similar
Is it possible to search through 'name' and compare it with all other 'name' values?
Second thing, which is, how to phrase it - complementary values. (e.g. "3d audio" vs "3d audio, entertainment and music" So, if 'name' has '3d audio' in one instance and in another '3d audio, blah blah' to have them sorted in some way ?