Comparing number string

Hi

I have tableA , which has two columns , codes and price, I have another tableB , which has codes and prices

TableA
Codes, Prices
92 , 10
923 , 12
92300, 11

TableB
Codes, Prices
92 , 10
923 , 12
92300, 10
92333, 10
92345, 11

I want to compare these two tables in a way that if a code exist in one table like 92333 and 92345 which is not present in other , It should return the best match . For example like table A does not have 92333 it should look for best possible match which would be 923 .
and same for 92345 , it should look for best match which again would be 923 .

I will appreciate if someone can help me and put me in right direction.

Thanks