Automatically Identifying Repeated Words

by Allen Wyatt
(last updated September 15, 2017)

6

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 wth 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:

http://wordribbon.tips.net/T010761_Generating_a_Count_of_Word_Occurrences.html

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

http://gregmaxey.mvps.org/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, and 2013.

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

Delivery Address Won't Print on Envelopes

Word includes a feature that allows you to easily create and print envelopes, based on the addresses you insert in your ...

Discover More

Can't Save Edited Document

Each day of using Word is filled with opening documents, editing them, and then saving those changes to disk. So it can be ...

Discover More

Keeping a Picture Title with the Picture

Pictures and their titles go together like peanut butter and jelly. (Wow, did I just say that?) Seriously, pictures and ...

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)

Sticking with the Dashes

By default, dashes don't "stick" to the text that follows them. Here's one way around this normal formatting convention.

Discover More

Creating Compound Characters

Word provides access to a wide variety of characters either from the keyboard or from the Symbol dialog box. Up and above ...

Discover More

Consistent Spacing

It is a good idea to make sure that the spacing following each sentence in your document is consistent. Here's a handy macro ...

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 0 + 6?

2017-11-13 09:01:08

Caio Martino

Dear Allen,
I need to identify retepetitions of word clusters in a text, without having to input what word combination(s) I am looking for. This function would automatically scan the text for any word sequence -- as short as two words and as big as can be found in the text -- and indicate their frequency. Do you know any program that can do that?


2017-09-25 06:07:15

Manoharan S

Today it happened to visit your site. Thanks. First of all I would like to say that I am a typist based in Chennai, Tamilnadu (South India). I am to some extent having knowledge in word. I am using word for the past 15 years for typing mathematics books without using equation editor directly. Applying certain commands I am typing equations easily like typing simple text.
Thanks for your excellent job Mr. Allen Wyatt


2013-10-23 08:45:50

Glenn Case

K:

While Find/Replace works fine for one word, it would be very cumbersome for all words in the document. Hence the macro solution.


2013-10-23 01:28:35

K.Vee.Shanker.

One easier way would be using 'Find & Replace'. One can copy the word and then click Contl+H. Paste the word to both find and replace fields, and then click 'Replace all'. Word will display a message on how many words have been replaced!


2013-09-09 09:04:35

Glenn Case

Kim:

The link in the section about "jumping under the hood" provides a macro which will do this, and it's free of charge. You don't have to download anything, just cut and paste the macro text into a Module using the VBA editor. If you are new to macros, then there are some good tutorials out there; there's a brief discussion on getting started at

http://www.excelforum.com/excel-formulas-and-functions/942183-how-to-extend-sequential-id-pattern.html?p=3352809

While it's aimed at Excel, the process is the same for Word. I urge you to take the plunge and learn a bit about this, as it will greatly enhance your capabilities...good luck!


2013-09-09 08:18:29

Kim Braswell

I work for the military; therefor, I'm not able to download add-ons, etc. I'm looking for tips to enhance my use of Word, not something outside of Word to use that costs.


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.