Rank the English Wiktionary words by the length of their articles

Results
Query

Viewing the first 20 of total 22,846 rows

word	article_word_count	url
А	12228	https://en.wiktionary.org/wiki/%D0%90
set	7745	https://en.wiktionary.org/wiki/set
sa	7425	https://en.wiktionary.org/wiki/sa
stand	6248	https://en.wiktionary.org/wiki/stand
sin	6040	https://en.wiktionary.org/wiki/sin
da	5753	https://en.wiktionary.org/wiki/da
sol	5578	https://en.wiktionary.org/wiki/sol
頭	5093	https://en.wiktionary.org/wiki/%E9%A0%AD
el	5005	https://en.wiktionary.org/wiki/el
post	4841	https://en.wiktionary.org/wiki/post
he	4753	https://en.wiktionary.org/wiki/he
office	4735	https://en.wiktionary.org/wiki/office
fan	4658	https://en.wiktionary.org/wiki/fan
dot	4620	https://en.wiktionary.org/wiki/dot
fa	4511	https://en.wiktionary.org/wiki/fa
fa	4511	https://en.wiktionary.org/wiki/fa
pike	4477	https://en.wiktionary.org/wiki/pike
it	4427	https://en.wiktionary.org/wiki/it
-s	4423	https://en.wiktionary.org/wiki/-s
I love you	4373	https://en.wiktionary.org/wiki/I_love_you

Viewing the first 20 of total 22,846 rows

Download Full Results

Query

select
    css_text_first(content, 'h1#firstHeading') as word,
    cardinality(words(css_text_first(content, '#content'))) as article_word_count,
    url
from 
    pages
where 
    url_domain = 'wiktionary.org' 
        and
    url like 'https://en.wiktionary.org/wiki/%'
        and
    url not like 'https://en.wiktionary.org/wiki/%:%'
order by article_word_count desc

Load in editor

Data scanned 1.57 GB

Results 1.55 MB (22,846 rows)

Rank the English Wiktionary words by the length of their articles

Turn the web into a database!