finding words in a list

davidleal 

Hi, Davidleal,

I've been fiddling with the file and have it working, but it needs a final step or two.

Here is the link to the new file. It's much smaller.https://www.dropbox.com/scl/fi/2tefjg4todnb26x6u4h7c/Scrabble-Dicitionary-for-Letter-Boxed-230701.xlsx?rlkey=l7dhbf5s4scaop3g0ovbfruyo&dl=0 

Here is a key to the structure of the file...

• Column A is a 214,066-word wordlist
• Column B indicates whether the word is a legal word for the puzzle (In)
• Column C counts the number of unique characters in the word in Column A
• Column D is a list of all the legal characters
• Column E is a list of the characters missing from the word in Column A
• Column F is a list of the unique characters in the word in Column A
• Column G tests only one word at a time to find another word that uses the missing characters and either starts with the last letter of the first word, or ends with the first letter of the first word

The problem: The formula in Column G must be rewritten for each possible first word in Column A until a complementary second word in Column A is found.

The proposed solution: Write a Macro that tests every legal word in Column A (that contains at least seven unique characters) to find every complementary second word in Column A and print a report of all the pairs found (see example from an online Letter Boxed Solver below).

Thanks,

Michael