I was also fiddling around with agrep and adist until I realised that for this very issue matching of substrings is not as important as matching multiple words.. With this different approach I quite easily matched all but 3 countries.
See what I did:
## look up matches of one dataframe in another dataframe. ## the strings to be matched are comprised of 1 or more words ## and seperated by white space. ## method: match strings that have the highest fraction of words that match up d1
Now, expanding on this concept by introduction of partial matching would most propably result in a 100% match…