Macro/VBA - Partial Text Matching

Hi guys,

Within a workbook I've got a tab(Tab_A) with a list of "Book Tittles" sent it by an external source (20K rows approx). In another tab(Tab_B) I've got my reference list also with "Book Tittles" which I do own.

In theory a relevant % of tittles included in the list provided by the external source should match with the ones I keep in my own list.

The issue here is that not all the tittles are wrote in the same way. Depending of the data quality provided by the external source, the tittle could exclude or include articles, additional words etc...so is not that easy as to run a simple vlookup or index_match function. I need some kind of macro/formula that look into the first list and returns next to my list in tab_B, the potential match. Could be a model that returns the tittle from the source list when a few words in common are identified...or something similar.

At the moment I'm using the following formula:

=IFERROR(INDEX('Tab_A'!$A$2:$A$20000,MATCH('Tab_B'!$A2&"*",'Tab_A'!$A$2:$A$20000,0),1),"No Match found")

Is there any VBA alternative that could potentially give me a better/more accurate result? (I'm new to VBA/programming)

Many thanks,

In this case, providing the data and some solid examples of how the titles differ could be of great use in recommending a better solution. As it is right now, I'm not sure what the best approach would be, because I don't have the data to guide me. Please post the data and we will try to help you.