Pull similars from two lists of different LENGTHS

I have list of words on A , 7 letters long
I have list of words on B , 8 letters long

Look at D and E where i have manually placed BALADIN and BALLADIN

I need this manually placed to be done by a macro
that will run through 35,254 rows from ROW A and 42,089 rows from row B

It should place such similars on D and E

Find attached

try

Please Login or Register  to view this content.

Jindon , fingers crossed it will pour results , it has taken 3o minutes still processing , for thus number of rows i hope it will take time but will do the task

Originally Posted by makinmomb

through 35,254 rows from ROW A and 42,089 rows from row B

Would take time.
Got different result (a few more) and see if this runs faster.

Please Login or Register  to view this content.

Gives Run Time Error "13"

Type Mismatch

It took one hour on that macro and did not pour results

When I debug it Highlights in Yellow the following

txt = Chr(2) & Join(Filter([transpose(if(b1:b100000<>"",b1:b10000))], False, 0), Chr(2)) & Chr(2)

Do you have error value somewhere?

Anyway, found a bug in my first code.
It should be

Please Login or Register  to view this content.

Then you will get 4 results as my second one.

Looks working

It has poured 7 results and still searching

It started with

CABALAS CABBALAS
BARACAN BARRACAN and other 5 results

Thank you Jindon , awesome stuff

You are welcome and thanks for the rep.

This one uses array for output to dump data at a time.
Don't think much difference in speed though.

Please Login or Register  to view this content.

It is not able to process , maybe those number of rows is too big , can i send the file to you to see if it does the magic your end ?

I have used SAVE AS to save the file at 1o,ooo rows , still not achievable

Will try the version of Karedog too and report as to working or not

Karedog , damn cool , it did everything in less than 5 seconds and i liked the row insert it does

Jindon did you see Karedog macro ?

Modification 2

On g it should do NUMBERING see sample of results

1 NOTAIRE (1) NOTAIRES (10)

2 ETAERIO (3) ETAERIOS (17)

3 ANEROID (4) ANEROIDS (21)

4 AILERON (5) TAILERON (7)
AILERONS (28)

Thank you Karedog , beyong exact , the word beautiful fails too