Automatically Identifying Repeated Words

by Allen Wyatt
(last updated January 18, 2020)

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 Office 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

Merging Formatted Data

Using the mail merge feature of Word, you can make data from Access databases accessible for your documents. How ...

Discover More

Editing a Comment Close to Its Cell

Have you ever chosen to edit a comment, only to find that the comment is quite a ways from the cell with which it is ...

Discover More

Symbols Convert to Numbers in Excel

Insert a symbol into a cell, and it should stay there, right? What if the symbol changes to another character, such as a ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Highlighting Duplicate Words

One way to help improve your writing is to minimize the number of duplicated words you use in your prose. Depending on ...

Discover More

Text Doesn't Wrap at Margin in Draft View

If you are using Word in Draft view, and the text on the screen doesn't wrap at the right margin like it should, the ...

Discover More

Breaking Into Sentences

Macros allow you to easily extend what you can do with Word. If you have a common editing task, that task can often be ...

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}] 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 4 + 0?

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.

Newest Tips
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.