{"id":77,"date":"2020-03-11T15:46:04","date_gmt":"2020-03-11T22:46:04","guid":{"rendered":"https:\/\/spreadsheets.sirknightj.com\/?p=77"},"modified":"2023-07-01T07:01:38","modified_gmt":"2023-07-01T07:01:38","slug":"word-finder-template-google-sheets","status":"publish","type":"post","link":"https:\/\/spreadsheets.sirknightj.com\/index.php\/2020\/03\/11\/word-finder-template-google-sheets\/","title":{"rendered":"Word Finder Template &#8211; Google Sheets"},"content":{"rendered":"<p>Here&#8217;s another template that I created in Google Sheets. It&#8217;s a word finder template. Basically you can use this to find a word given a specific pattern that it has to follow.<\/p>\n<h3>The Template Spreadsheet<\/h3>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1VPsFtprK7KP5KmrwNDIFWTsYDPsEpro5xSJHexkx8nA\">https:\/\/docs.google.com\/spreadsheets\/d\/1VPsFtprK7KP5KmrwNDIFWTsYDPsEpro5xSJHexkx8nA<\/a><\/p>\n<p>To use it, all you have to do is go to\u00a0<em>File<\/em>\u00a0&gt;\u00a0<em>Make a Copy<\/em>. If that option is grayed out, that means you haven\u2019t logged into your Google Account. Log into that, then click\u00a0<em>Make a Copy<\/em>.<\/p>\n<h3>Instructions<\/h3>\n<p>To use this sheet, first you have to set it up by pasting in the words that you want the sheet to search through. You have to paste a comma-separated list into the cells T1 and\/or U1 of the <em>DATABASE<\/em> tab. In the template, I&#8217;ve pre-loaded in a bunch of Minecraft words, which you can either add to, or remove and replace with your own set of words.<\/p>\n<p>Google Sheets has a limitation of 50,000 characters in each cell.<\/p>\n<p>To actually use the word finder, head over to the <em>Search<\/em> tab.<\/p>\n<ul>\n<li>Enter the length of the word you want to be found under the box that says &#8220;Enter the length of the word (including spaces):&#8221;. Once you do that, the section below will update, and the display output will also update.<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-78 size-full\" src=\"https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-1.png\" alt=\"\" width=\"716\" height=\"141\" srcset=\"https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-1.png 716w, https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-1-300x59.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/p>\n<p><!--more--><\/p>\n<ul>\n<li>Then, enter the letters you know one at a time into the corresponding cells. For any letters you don&#8217;t know, just leave blank and Google Sheets will search through the words you put in the <em>DATABASE<\/em>.<\/li>\n<li>If you have a space in the word, it will automatically be highlighted blue, and it will be displayed in the output preview.<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-79 size-full\" src=\"https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-with-space-1.png\" alt=\"\" width=\"874\" height=\"177\" srcset=\"https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-with-space-1.png 874w, https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-with-space-1-300x61.png 300w, https:\/\/spreadsheets.sirknightj.com\/wp-content\/uploads\/2020\/03\/sirknightj-word-finder-with-space-1-768x156.png 768w\" sizes=\"(max-width: 874px) 100vw, 874px\" \/><\/p>\n<ul>\n<li>The words that Google Sheets finds will be displayed on the left side.<\/li>\n<\/ul>\n<h4>Notes:<\/h4>\n<ul>\n<li>You have to manually clear the &#8220;Enter the letters you know:&#8221; section each time you want to search for a new word.<\/li>\n<li>Due to Google Sheets limitations on having 50,000 characters in a single cell, there isn&#8217;t enough room to paste in the entire Scrabble dictionary in there. There are more than a million characters in the Scrabble Dictionary (after putting in the commas), so putting the whole thing in a spreadsheet is not very feasible.<\/li>\n<li>This is not case sensitive. The cases only matter for the display output for the\u00a0<em>Possible Words<\/em> on the left. When searching, this ignores casing.<\/li>\n<\/ul>\n<p>If you&#8217;re looking for the Scrabble word list, you can find it <a href=\"https:\/\/www.wordgamedictionary.com\/twl06\/download\/twl06.txt\">here<\/a>.<\/p>\n<p>I made this sheet so I could test my hangman game (with a small word pool), so I&#8217;d like to share my creation with you all to help you guys out too. Hope you all enjoy this word finder template!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s another template that I created in Google Sheets. It&#8217;s a word finder template. Basically you can use this to find a word given a specific pattern that it has to follow. The Template Spreadsheet https:\/\/docs.google.com\/spreadsheets\/d\/1VPsFtprK7KP5KmrwNDIFWTsYDPsEpro5xSJHexkx8nA To use it, all you have to do is go to\u00a0File\u00a0&gt;\u00a0Make a Copy. If that option is grayed out, &#8230; <a title=\"Word Finder Template &#8211; Google Sheets\" class=\"read-more\" href=\"https:\/\/spreadsheets.sirknightj.com\/index.php\/2020\/03\/11\/word-finder-template-google-sheets\/\" aria-label=\"More on Word Finder Template &#8211; Google Sheets\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,5],"tags":[],"_links":{"self":[{"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/posts\/77"}],"collection":[{"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/comments?post=77"}],"version-history":[{"count":2,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions"}],"predecessor-version":[{"id":135,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/posts\/77\/revisions\/135"}],"wp:attachment":[{"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/media?parent=77"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/categories?post=77"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheets.sirknightj.com\/index.php\/wp-json\/wp\/v2\/tags?post=77"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}