Unstructured Text
Count Duplicate Words
List every word that appears more than once, sorted from most to least frequent.
When to use it
Typical uses: Spotting overused words in essays, stories and marketing copy; Checking a page for keyword stuffing; Finding the main themes of a document.
In a pipeline
Text InputCount Duplicate WordsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| Ignore common words (the, and, of…) | checkbox | — | true |
Example
Count Duplicate Words: an example
| Text |
|---|
| The team made a great plan. The plan was great, and the team was happy with the plan. |
| Word | Count |
|---|---|
| plan | 3 |
| great | 2 |
| team | 2 |
Worth knowing
- Is the search case-sensitive? No. Words are compared in lowercase.
- What are stop words? Very common words such as “the”, “is” and “with” that carry little meaning by themselves. Ignoring them highlights the words that matter.
- How is this different from the Keyword Density Checker? This tool lists every repeated word with its count. The Keyword Density Checker shows the top words together with their percentage of the whole text.
- The result is a table, one row per word, keeping the row's other columns (such as the file it came from).