SQLite String Similarity Function?

Question

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)?

Answer 1

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.