Automatically Identifying Repeated Words

by Allen Wyatt
(last updated January 21, 2019)


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


Setting Line Spacing in the Equation Editor

The Equation Editor can be a great boon when you need to include complex mathematical equations in your document. The ...

Discover More

Using the CONCATENATE Worksheet Function

The process of combining string (text) values to make a new string is called concatenation. Excel provides the ...

Discover More

Comparing Strings

As your macro is processing information, there will doubtless be times that it will need to compare information in ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Using Overtype Mode

When you type information into a document, what you type normally is inserted just the left of the insertion point. Word ...

Discover More

Wrapping Spaces

Add more than one space after the end of a sentence, and you may find that the extra spaces wrap to the start of new ...

Discover More

How Word Handles Abbreviations

Abbreviations appear all over the place in our society. If you want to understand how Word recognizes them (which it has ...

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 three more than 3?

2018-08-06 16:53:30

Majeed Fazal

Automatically Identifying Repeated Words

Hi Allen.

Thanks for the support that you are giving to millions of people.

I just want to know that this tool will work for the other languages like Urdu and Arabic that I am working for the book that is typed 100s of pages and I need that when I am going for the other pages could this application or any other indicate me the already repeated text or phrases.


Majeed Fazal

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.