Automatically Identifying Repeated Words

Written by Allen Wyatt (last updated July 1, 2024)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365


As a teacher, Wendy critiques her students on how often they repeat words in their writing. When she opens a document from her students, she wonders if Word can tell her the words they have repeated. She understands that she can use Find and Replace if she knows the word she is looking for; however, this means that she would have to identify a repeated word. She is looking for Word to do the work for her. Naturally, Wendy wouldn't want Word to let her know that the student has used common words like A, AN, THE, AND, etc.

When you want a count of the number of times each word in a document is used, what you are looking for is typically referred to (in Word circles) as a "word frequency count" or a "concordance with counts." Searching on the web for these terms can uncover a wide variety of tools you could use for this purpose.

Some WordTips subscribers made suggestions of tools that work well for them. One such tool is WordCounter, from our friends over at the Editorium (www.editorium.com). This Word add-in can be used free for 45 days. After that, you can register it for only $19.95.

A standalone program—one not run as a Word add-in—is TextSTAT. It can read several types of files, including Word documents. It produces a detailed listing with all sorts of statistical summaries. Best of all, TextSTAT is free at:

http://neon.niederlandistik.fu-berlin.de/en/textstat/

If you'd like to "jump under the hood" and create your own macro to get the desired results, consider the discussion at a previous WordTip, located here:

https://wordribbon.tips.net/T010761

You could also benefit by examining how MVP Greg Maxey tackles the issue:

https://gregmaxey.com/word_tip_pages/word_usage_and_frequency_report.html

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11362) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Saving a Workbook in a Macro

Does your macro need to make sure that the workbook being processed is saved to disk? You can add the saving capability ...

Discover More

Specifying an Order for Page Printing

If a printout of your worksheet requires multiple pages, you may want to specify the order in which Excel prints those ...

Discover More

Colors in an IF Function

You can use the IF worksheet function to test for a number of different conditions or values. You can't use it to check ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Typing Pronunciations of Words

Take a look in a dictionary at the way that words are phonetically spelled. Those special characters used to type those ...

Discover More

Adding an Optional Break

The no-width optional break is primarily used for Asian languages in Word. It can have value for English-speakers, as ...

Discover More

Transposing Letters

My fat fingers sometimes result in typing letters in the wrong order. Here's a quick tool that allows you to easily ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one more than 4?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.