So I have two point shapefiles - their attribute table consist of names, lat, lon, and others.
I would like to join the attributes of shapefile 1 to shapefile 2. A normal join between the names would to the job.
The problem is that the two datasets have slight differences in the 'name' field as well as in the lat/lon. For example, if I have one point in The Hague, Shapefile 1 will calle it 'Den Hague' whereas Shapefile 2 would calle it 'T. Hague'. Also spatially they are not identical (they do not overlap) so the location between both of them would differ by few kms in spite of being the same point. I have over 7000 points which make it tough for manual corrections. When some points are indeed correct.
Is there a way to do a matching which takes into account ~80% of similarity in the names?
I am using QGIS.