WordNet (cased forms)
cased forms
SELECT * FROM words WHERE lemma='neolithic'
wordidlemma
89420neolithic
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='neolithic'
wordidlemmacasedwordidcased
89420neolithic22113Neolithic
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='shakespeare'
wordidlemmacasedwordidcased
118556shakespeare28975Shakespeare
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE cased='shaKEspeare'
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE cased='Shakespeare'
wordidlemmacasedwordidcased
118556shakespeare28975Shakespeare
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='am'
wordidlemmacasedwordidcased
4410am107AM
4410am1261Am
SELECT * FROM words LEFT JOIN casedwords USING (wordid) WHERE lemma='abolition'
wordidlemmacasedwordidcased
619abolition
SELECT cased,definition FROM senses INNER JOIN casedwords USING (wordid,casedwordid) INNER JOIN synsets USING (synsetid) WHERE cased='Jackson'
caseddefinition
Jacksona town in south central Michigan
Jacksoncapital of the state of Mississippi on the Pearl River
Jacksona town in western Tennessee
Jacksona town in western Wyoming
Jackson7th president of the US; successfully defended New Orleans from the British in 1815; expanded the power of the presidency (1767-1845)
Jacksongeneral in the Confederate Army during the American Civil War whose troops at the first Battle of Bull Run stood like a stone wall (1824-1863)
JacksonUnited States writer of romantic novels about the unjust treatment of Native Americans (1830-1885)
JacksonUnited States civil rights leader who led a national campaign against racial discrimination and ran for presidential nomination (born in 1941)
JacksonUnited States singer who did much to popularize gospel music (1911-1972)
JacksonUnited States singer who began singing with his four brothers and later became a highly successful star during the 1980s (born in 1958)
JacksonEnglish film actress who later became a member of British Parliament (born in 1936)
SELECT cased,definition FROM senses INNER JOIN casedwords USING (wordid,casedwordid) INNER JOIN synsets USING (synsetid) WHERE cased='C'
caseddefinition
Cstreet names for cocaine
Cthe 3rd letter of the Roman alphabet
C(music) the keynote of the scale of C major
Ca general-purpose programing language closely associated with the UNIX operating system
Ca unit of electrical charge equal to the amount of charge transferred by a current of 1 ampere in 1 second
Ca degree on the centigrade scale of temperature
Cten 10s
Can abundant nonmetallic tetravalent element occurring in three allotropic forms: amorphous carbon and graphite and diamond; occurs in all organic compounds
Ca base found in DNA and RNA and derived from pyrimidine; pairs with guanine
Cone of the four nucleotides used in building DNA; all four nucleotides have a common phosphate group and a sugar (ribose)
Ca vitamin found in fresh fruits (especially citrus fruits) and vegetables; prevents scurvy
SELECT lemma,cased,SUBSTRING(definition FROM 1 FOR 64) FROM senses INNER JOIN words USING (wordid) LEFT JOIN casedwords USING (wordid,casedwordid) INNER JOIN synsets USING (synsetid) WHERE lemma='C'
lemmacasedSUBSTRING(definition FROM 1 FOR 64)
cCstreet names for cocaine
cCthe 3rd letter of the Roman alphabet
cC(music) the keynote of the scale of C major
cCa general-purpose programing language closely associated with th
cCa unit of electrical charge equal to the amount of charge transf
cCa degree on the centigrade scale of temperature
cCten 10s
cCan abundant nonmetallic tetravalent element occurring in three a
cCa base found in DNA and RNA and derived from pyrimidine; pairs w
cCone of the four nucleotides used in building DNA; all four nucle
cCa vitamin found in fresh fruits (especially citrus fruits) and v
cthe speed at which light travels in a vacuum; the constancy and
cbeing ten more than ninety
lemma having several cased forms
SELECT wordid,COUNT(casedwordid) AS N,GROUP_CONCAT(cased) FROM casedwords GROUP BY wordid HAVING N > 1 ORDER BY N DESC
wordidNGROUP_CONCAT(cased)
4052AB,Ab
8662AC,Ac
32232AL,Al
36702Algol,ALGOL
44102Am,AM
72362Ar,AR
84462As,AS
86072Ashcan School,Ashcan school
96422Au,AU
104552BA,Ba
145822Black Maria,black Maria
167012BR,Br
190282CA,Ca
221772CD,Cd
221932CE,Ce
228732Cf,CF
246472Christian Church,Christian church
264692Co,CO
278482Common Era,Common era
339432Db,dB
339502DDC,ddC
339512ddI,DDI
385622DoS,DOS
395592Ds,DS
404252EB,Eb
432882Er,ER
439452Eu,EU
499202FM,Fm
522612GA,Ga
531242GB,Gb
531302GD,Gd
576152GI,Gi
638362Hf,HF
679852IN,In
706982IR,Ir
734542KB,kB
745342KR,Kr
747202LA,La
803272MA,mA
817762MAO,Mao
818762MArch,March
829612Mb,MB
829912Md,MD
847832Midi,MIDI
857822MN,Mn
857912Mo,MO
873172MS,Ms
873272MT,Mt
881202Mv,mV
890872Nb,NB
890922ND,Nd
890952Ne,NE
915542Np,NP
919802OB,Ob
945682Os,OS
956542PA,Pa
976552Pb,PB
1019512Pm,PM
1019822Po,PO
1036562PR,Pr
1076602RA,Ra
1081892RAM,Ram
1113272RF,Rf
1113302RH,Rh
1121852Rn,RN
1154402Sb,SB
1154442Sc,SC
1164992SE,Se
1196022Si,SI
1215322Sm,SM
1224232SoHo,Soho
1307722Tb,TB
1307752Tc,TC
1357472Trojan Horse,Trojan horse
1426002WAC,Wac
1466872YB,Yb
1470082Young Turk,young Turk
1471572ZB,Zb
senses having a cased form
SELECT COUNT(*) FROM senses WHERE NOT ISNULL(casedwordid)
COUNT(*)
44024
words having a cased form
SELECT COUNT(*) FROM words INNER JOIN casedwords USING (wordid)
COUNT(*)
40850