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 comparison, you will have to implement your own function in
sqlite using sqlite3_create_function, see
http://www.sqlite.org/capi3ref.html#sqlite3_create_function
You cann take the suggestions on stackoverflow and convert them to C or
at least wrap them in a C function.
Martin
Am 29.08.2014 00:07, schrieb 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 identical to the addresses of the street
map dataset, I wish to get a score to measure the "similarity" of the
two strings.
I've found
http://stackoverflow.com/questions/653157/a-better-similarity-ranking-algorithm-for-variable-length-strings
and I hope there is some implementation of a similar function to be
used in Sqlite queries.
Any suggestion, any help?
Thanks,
Maurizio
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
*Codeswift GmbH *
Kräutlerweg 20a
A-5020 Salzburg
Tel: +49 (0) 8662 / 494330
Mob: +49 (0) 171 / 4487687
Fax: +49 (0) 3212 / 1001404
engelsch...@codeswift.com
www.codeswift.com / www.swiftcash.at
Codeswift Professional IT Services GmbH
Firmenbuch-Nr. FN 202820s
UID-Nr. ATU 50576309
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users