"The challenge this week is to find the best word (from a provided text file) that can be assembled from 7 provided letters"
I went down a different path than what I have seen posted so far. No macros, finishes in under 2 sec on my laptop, Top 5 for the advanced version verified to @NicoleJohnson's list. I tried verifying to others but had issues downloading or running the workflows. For challenges that don't have answers posted, it would be helpful if others could post screenshots of thier results (like @LordNeilLord did), so we can compare our results without having to download and run everyone's workflows/macros. :>
Congrats to @SeanAdams and others on reaching 75!
Pretty sure @ned has a nicer solution but have a regex based one running in about 7 seconds (with no pre computes) will cope with blanks but not double letters...
Now to cope with repeated letters
I KNEW there was another way to do this. Average of 0.8 seconds for any number of blanks. Now I can sleep again at night!! :)
Ok, this challenge was a quite hard brain game, but I think I got it... I spent 15 minutes trying to figure out what was wrong in my workflow when I finally saw in a regex I forgot to put the + after \d so it was cutting 10 points value into 1, so I was getting wrong results at the end when it was calculating the points for each word.
Anyway, it was a great challenge, I did not think about generating words before with Alteryx, it is not very easy to do but it is possible and to be honest, I thought I would have spent more time on this, but it took me "only" 2 hours.. ahah