Woman Accountant
Home | Math | Genetics | Bridge | Spreadsheets | Workshops | HowTo | Feedback

Cryptogram Helper

Cryptograms are sentences in a simple substitution code, where one letter of the alphabet is substituted for the correct letter. No letter stands for itself. The Sunday paper often has a cryptogram on the games page. Also PennyPress publishes magazines of cryptograms.

The spreedsheet contains a list of common words identified by word length, word frequency, letter frequency, and repeated letter pattern. You may filter the list by all of the identifiers. For instance if you are looking for a four letter word with the first and last letters the same, this spreadsheet will return the filtered list: area, dead, died, edge, else, high, noun, says, test, that. If you had also specified that none of the letters were 'a' or 'e', then the returned list would be: high, noun.

Cryptogram Helper Demonstration

Detailed User Instructions

Load Cryptogram Helper

(file size: 465KB)

Download Blocked?