30:T4dd,# Solver for AVCX's "Fill Your Plate" puzzle in Puzzmo's newsletter Last month, The daily game site [Puzzmo](https://www.puzzmo.com/) collaborated with the indie crossword crew at [AVCX](https://avxwords.com/) to launch two new little word games in Puzzmo's weekly newsletter. One of them is called "Fill Your Plate". Here's how they describe it in the > In this game, you spot a license plate with a string of three consonants. How many common English words (excluding proper nouns) can you make by adding vowels to this string? You can use as many vowels as you want, and in any combination of places, but you may not change the order of the consonants. > For example, if you see **BST**, you could create words including **BUST**, **BEST**, **BASTE**, and **OBOIST**. I'm enjoying the new puzzle so far. It's quite slight, but that's what I like about it. I was compelled to explore every possible "plate". Here's a "solver", that relies on a concise SQL query once the Wordnik word list is imported from [Github](https://github.com/wordnik/wordlist). Put in a sequence of consonants and see what words it makes. The Wordnik list has some junk in it (and also slurs), but it should also include most things you think of as English words. 31:[] 2e:{"title":"Solver for AVCX's \"Fill Your Plate\" puzzle in Puzzmo's newsletter","cells":[{"id":0,"value":"$30","pinned":false,"hidden":false,"mode":"md"},{"id":114,"value":"{\n const wordsJoin = words.join(\", \");\n const el = html`

${input_clean}

${wordsJoin}

`\n return el\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"viewof input = Inputs.text({label: html`Consonant Pattern:`, placeholder: \"Input a sequence of consonants\", value:\"xmpl\" })","pinned":false,"hidden":false,"mode":"ojs"},{"id":84,"value":"input_clean = input.split('').filter(x => /[bcdfghjklmnpqrstvwxyz]/i.test(x)).map(x=>x.toLowerCase()).join('')","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"wordnik = {\n const url = 'https://raw.githubusercontent.com/wordnik/wordlist/main/wordlist-20210729.txt';\n const response = await fetch(url)\n const text = await response.text()\n const rows = text.split('\\n')\n return rows.map(row => row.replace(/\"/g, '')).map(x=>({word: x}))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"const db = await DuckDBClient.of({wordnik});","pinned":true,"hidden":false,"mode":"js"},{"id":89,"value":"no_vowels_arr = {\n const vowels = ['a','e','i','o','u','y'];\n return wordnik.map(({word}) => {\n let nv = word.toLowerCase();\n for (const v of vowels) nv = nv.split(v).join('');\n return {word, no_vowels: nv};\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":94,"value":"words = no_vowels_arr\n .filter(x => x.no_vowels === input_clean)\n .map(x => x.word)","pinned":true,"hidden":false,"mode":"ojs"},{"id":103,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":132,"value":"### just hunting for insights","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"with\nno_vowels_ as (\n select word,\n replace(word, 'a', '') as no_as,\n replace(no_as, 'e', '') as no_es,\n replace(no_es, 'i', '') as no_is,\n replace(no_is, 'o', '') as no_os,\n replace(no_os, 'u', '') as no_us,\n replace(no_us, 'y', '') as no_vowels,\n from wordnik\n),\nno_vowels as (select word, no_vowels from no_vowels_)\n\n-- select * from no_vowels\n-- where no_vowels = 'ttt'\n-- order by length(word) desc\n\n-- select no_vowels,\n-- length(no_vowels) as n_consonants_in_pattern,\n-- count(*) as n_words,\n-- string_agg(word, ', ')\n-- from no_vowels\n-- where right(no_vowels,1) != 's' and right(no_vowels, 2) != 'ng'\n-- group by all\n-- having n_consonants_in_pattern >= 4\n-- order by n_words desc\n\nselect no_vowels,\n length(no_vowels) as n_consonants_in_pattern,\n count(*) as n_words,\n string_agg(word, ', ')\nfrom no_vowels\nwhere length(replace(no_vowels, substr(no_vowels, 1, 1), '')) = 0\n and n_consonants_in_pattern >= 2\ngroup by all\norder by n_consonants_in_pattern desc","pinned":true,"hidden":false,"mode":"sql","output":"","database":"var:wordnik"},{"id":134,"value":"const tbl = no_vowels.no_vowels; // the Arrow Table\ndisplay(tbl.constructor.name);\ndisplay(tbl.numRows);\ndisplay(tbl.schema.fields.map(f => f.name));\nconst row0 = tbl.get(0);\ndisplay(row0.toJSON());","pinned":true,"hidden":false,"mode":"js"}],"files":"$W31","stdlib":"1","titling":"auto"}