Ratcliffe

I have two table having account numbers in each. Some of the Account numbers in table B have a part of the account number from table A or have exta digits to accounts number from table A. I need to find such cases.

Here are few scenarios:
-If the lenght of Acct no in table B is 16 it can have 3 zeros in the end or begining of the account no
-If the length of acct no(12345678) in tableA is 8, it can be listed with additional 6 digits (12345678C12111) in tableB

There are some other different formats, which I dont know of at this stage and want to use some function that can address/find all possible account numbers from table B.

I think this can be done using Ratcliffe Obershelp function in excel. I m wondering if there is similar function in SQL or how does this function work in excel.