User:Topbanana/Reports/This article contains a repeated word

Overview edit

The list below shows articles which contain repeated common words. It was generated on 8th June 2005 from the 16th May 2005 database dump.

Preamble edit

It is very easy to accidentally repeat certain words in English, particular prepositions like 'the' and 'of'. While there may be a good reason for for the articles below to contain such repeated words, it's likely that it's a mistake. Edit and correct the articles.

Regenerating this report edit

This report is generated from a Link Analysis Database using the SQL:

SELECT concat( '*[[', art_title, ']]' )
FROM art
where art_text REGEXP '[[:<:]]the the[[:>:]]'
order by art_title;

The above only searches for repeated the's - replace "the the" with "but but" or whatever else you want to check for.


Suggested improvements edit

  • Many more common word combinations to check - do these each need their own list? - TB 09:45, Jun 9, 2004 (UTC)
  • Repeated words usefully checked for previously have been:
    • the - last checked May 2005
    • and - last checked June 2004
    • but - last checked June 2004
    • for - last checked June 2004
    • he - last checked June 2004
    • in - last checked June 2004
    • is - last checked June 2004
    • it - last checked June 2004
    • of - last checked June 2004
    • to - last checked June 2004
    • a - last checked June 2004

List edit

List removed, hideously out of date. - TB 17:58, 31 December 2005 (UTC)