Automatically Identifying Repeated Words

by Allen Wyatt
(last updated September 15, 2017)


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

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:

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

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


Turning Track Changes Off for Selected Areas

Track Changes is a great tool to use so that you can, well, "track" what changes are made during the development of a ...

Discover More

Determining the Size of a File

When processing a document using a macro, you may need to know the precise size of a particular file. The way you figure ...

Discover More

Uncovering and Removing Links

Excel allows you to reference data in other workbooks by establishing links to that data. If you later want to get rid of ...

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)

Selecting a Text Block

Word has an interesting way of allowing you to select a rectangular block of text, without reference to what may be ...

Discover More

Transposing Two Characters

If you have two characters in the wrong order, you might be interested in a shortcut you can use to switch their order. ...

Discover More

Deleting Freezes Computer

Sometimes a strange object or text may appear in your document, as happened to Sharon. To complicate the situation, her ...

Discover More

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

View most recent newsletter.


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 six more than 8?

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


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


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


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

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

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.