Partial Match Between two Lists with names

Will there only ever be ONE variation, or could there be multiple variations? Instead of trying to match things, consider having a drop-down selection box in the table on the left so that you don't get incorrect manual entries. Based on your small sample, what you are asking is going to get very complicated and would be best avoided.

I would suggest 4 levers of matching 80, 70, 60 , 50%, and check from the left and from the right, with helper columns.

It works for:
"Academia LTD B.V" vs "Academia LTD BV" : 80% from the left
"Åkes Værksted Hellerup" vs "Aakes Vaerksted Hellerup" : 70% from the right

But, it does not work for:
"Jakobs North West" vs "Jakob North W." : not match from left or right

In case you only want it up to 70%, just delete 60% and 50%

To get the expected results, I used Power Query Fuzzy Match but had to set the percentage at 60%

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Account name", type text}}),
    #"Merged Queries" = Table.FuzzyNestedJoin(#"Changed Type", {"Account name"}, Table2, {"Account name 2"}, "Table2", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=0.6]),
    #"Expanded Table2" = Table.ExpandTableColumn(#"Merged Queries", "Table2", {"Account name 2", "Account No."}, {"Account name 2", "Account No."})
in
    #"Expanded Table2"