Re: [sqlite] String compare scoring functions

2014-08-29 Thread Martin Engelschalk
Hello Maurizio, 1) Logical answer Comparing two addresses and getting a similarity score can be a VERY complicated task if your requirements are high enough, and you can buy some very expensive software to perform this. I know because I work with some. 2) Technical answer For such a

[sqlite] String compare scoring functions

2014-08-28 Thread Maurizio Trevisani
Hello, I need a function that gives a real result from 0 to 100 representing the similarity of two input strings. I need to compare a dataset of addresses with a dataset of addresses with house numbers, having coordinates, to get a geolocalization of the addresses. Since the addresses aren't