I just did something similar with openstreetmaps last week. In my case I tried the other way around (finding similar addresses) I benchmarked fts(sqllite) Vs t

I just did something similar with openstreetmaps last week. In my case I tried the other way around (finding similar addresses) I benchmarked fts(sqllite) Vs typesense. Which I can only recommend for such tasks. repo: https://github.com/K0IN/open_streetmaps_typesense https://github.com/K0IN/open_streetmaps_typesense btw I also tried the python import but it was unusable (for Germany) slow so I switched to osmtools and exported it to Jason first which is way faster.