We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #75: Scrabble Word Finder

Tofel
9 - Comet
Spoiler
 

Challenge 75.jpg

hjyinmoiikj
5 - Atom

My website name is Scrabblewordfinder.uk,,, use this tool 

Erin
11 - Bolide
Spoiler
75.png
Carolyn
12 - Quasar
12 - Quasar

This was a challenge!

 

Spoiler
Full workflow: 

WF.png


For 0 blanks, I used a macro to generate all the possible letter combos. Then I compared it against the word list - not too bad

0Blanks.png
CreateWords.png


For 1 and 2 blanks, I ended up with 2 different variations on the same macro. I took the possible words from the first macro and Appended the letters A-Z once or twice. I know I could work that out to be iterative so I didn't need 2 macros, but at this point, I'm fried, so 2 versions. 

From there, I alphabetized the letters (e.g. aba became aab) and returned them to the main workflow.

AddLettersAndAlphabetize.png


Back on the main workflow, I alphabetized the letters from the word list. Then I compared them and did the math to subtract the letter values for the blanks and found the top point values.


1 blank:  
1Blanks.png


2 blank: 

2Blanks.png
JBevan89
8 - Asteroid

Great Challenge