Scrabble Game macro collections

[makinmomb]

I have a list of 7 letter words on a and 8 letter words on b

I want macro to do the following

list all similar by one vowel position any position

See D and E as TRENAIL TREENAIL , if it finds next it should append at d2 and e2 and d3 and e3 and so on

To work on unlimited rows range since , I have deleted many word , this list contains 10000+20000 words

[makinmomb]

here is another example , STEARIN STEARINE , for expected results list

[makinmomb]

here is another example , ESTRIOL OESTRIOL , for expected results list

[makinmomb]

here is another example , ESTRONE OESTRONE , for expected results list

[makinmomb]

Thus for examples mentioned d and e would look as follows

ESTRIOL OESTRIOL
ESTRONE OESTRONE
STEARIN STEARINE
TRENAIL TREENAIL

[karedog]

Maybe :

Please Login or Register  to view this content.

[makinmomb]

Very Awesome , thank you , Karendog , please same logic for seven letter words , for words like ANIMATE ANIMATI ANIMATO

[makinmomb]

Even if the field go to 3 to 4 or 5 columns will do too

[makinmomb]

Are there is one like that may fit to 5 columns on results

HALLOED HELLOED HILLOED HOLLOED HULLOED

[makinmomb]

Also same third macro for similars in eight letter words , same logic , not starting several threads of multiple requirements

[makinmomb]

Keeping the thread open , sorted for the first macro

[JOHN H. DAVIS]

This one takes about 5 mins took run, if time is not an issue.

Please Login or Register  to view this content.

[makinmomb]

Incase someone gets the time for part two of the macro , list summary of such ones

ANIMATE ANIMATI ANIMATO
HALLOED HELLOED HILLOED HOLLOED HULLOED

[makinmomb]

John yours unfortunately picks plurals and too slow , I have 6o,ooo rows

That of Karendog skinned those rows at less than 1o seconds

[makinmomb]

Maybe I will just start a new thread