SQLite String Similarity Function?

Is there anything in SQLite that will let you compare two strings and return a similarity value from 0 to 1 (0 to 100% similarity)?

8th Jul 2019, 6:43 AM
Nathan Stanley
Nathan Stanley - avatar
1 Answer
There is no such function in SQL nor in any other programming language really. The grade of similatity is very subjective, for example is 'a' more similar to 'A' or to 'á' or to 'b' or to 'aa'? That is something you need to define yourself if you want to make such comparisons.
8th Jul 2019, 9:33 AM
Tibor Santa
Tibor Santa - avatar