Challenge #75: Scrabble Word Finder

[clmc9601]

Three macros, a hundred tools, and over 16 million rows later-- my solution!

Spoiler

top five words by "board" aka starting input

[robert-headington]

I created a macro that will give all the possible words in the database (sorted by score) that you can make with any scrabble hand (solving all three given and any others with the same format - i.e. characters separated by spaces, blanks written as blank)

[apathetichell]

So the non-blank version works for non-blanks and the blanks version works for two blanks - I have some silly error somewhere in it for one-blank which I'll try to go back and fix... I used a strategy of removing the characters which were in a players hand using find/replace's amazing ability to remove only one occurrence of an entry. And empty/null word meant that the scrabble letters could form it. For blanks - having 1 or 2 characters left meant the 1 or 2 blanks could be used to form the letters.

I was very pleased with that solution - even though it's obviously a bit messy. The screen grab of the blanks version includes flotsam from the earlier version. Scoring seemed much easier than matching letters and hypothetically the extra points for using all 7 letters should be added prior to finding the highest scores... Now - here are the 6 files (two macros each..) and screen grab

 

[mpennington]

This may be my favorite solution to date. It runs quick and it is relatively small. Works with and without blanks. I annotated the tools in the workflow for readability. 

Spoiler

[alexvornsand]

Spoiler

[Chantelb]

Spoiler

[BeginnerMindset]

What a challenge! Probably my favourite one yet.  Delighted to have solved it with one workflow to handle all three cases. Lots of crossing connections in the workflow, but I think that's inevitable and I've used container boxes to try to explain. 

Spoiler

[Maskell_Rascal]

This was a fun challenge! Here are my solutions. 

Spoiler

Workflow:
No Blank Tiles Solution:

One Blank Tile Solution:

Two Blank Tile Solution:

Cheers!

Phil

[phottovy]

Completed including the wildcard tiles.

[PangHC]

1. filter the length <= 7

2. join the hand word with point.

3. split both hand word and dictionary by single character.

4. join by character

5. Summary by count of character

6. filter out if character + blank is too less.

7. find top.