CASED FORMS
SELECT * FROM words WHERE lemma='neolithic'
wordidlemma
89314neolithic
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='neolithic'
wordidlemmacasedwordidcased
89314neolithic22079Neolithic
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='shakespeare'
wordidlemmacasedwordidcased
118422shakespeare28927Shakespeare
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE cased='shaKEspeare'
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE cased='Shakespeare'
wordidlemmacasedwordidcased
118422shakespeare28927Shakespeare
SELECT * FROM words INNER JOIN casedwords USING (wordid) WHERE lemma='am'
wordidlemmacasedwordidcased
4403am106AM
4403am1262Am
SELECT * FROM words LEFT JOIN casedwords USING (wordid) WHERE lemma='abolition'
wordidlemmacasedwordidcased
618abolition
SELECT cased,definition FROM senses INNER JOIN casedwords USING (wordid,casedwordid) INNER JOIN synsets USING (synsetid) WHERE cased='Jackson'
caseddefinition
JacksonEnglish film actress who later became a member of British Parliament (born in 1936)
JacksonUnited States singer who began singing with his four brothers and later became a highly successful star during the 1980s (born in 1958)
JacksonUnited States singer who did much to popularize gospel music (1911-1972)
JacksonUnited States civil rights leader who led a national campaign against racial discrimination and ran for presidential nomination (born in 1941)
JacksonUnited States writer of romantic novels about the unjust treatment of Native Americans (1830-1885)
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)
Jackson7th president of the US; successfully defended New Orleans from the British in 1815; expanded the power of the presidency (1767-1845)
Jacksona town in western Wyoming
Jacksona town in western Tennessee
Jacksoncapital of the state of Mississippi on the Pearl River
Jacksona town in south central Michigan
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)
4032AB,Ab
8652AC,Ac
32202AL,Al
36642ALGOL,Algol
44032AM,Am
72302AR,Ar
84382AS,As
86012Ashcan School,Ashcan school
96362AU,Au
104502BA,Ba
145712Black Maria,black Maria
166942BR,Br
190222CA,Ca
221722CD,Cd
221882CE,Ce
228682CF,Cf
246402Christian Church,Christian church
264612CO,Co
278362Common Era,Common era
339242Db,dB
339312DDC,ddC
339322ddI,DDI
385382DOS,DoS
395352DS,Ds
403972EB,Eb
432562ER,Er
439132EU,Eu
498832FM,Fm
522262GA,Ga
530892GB,Gb
530952GD,Gd
575772GI,Gi
637872HF,Hf
679282IN,In
706402IR,Ir
733932KB,kB
744672KR,Kr
746522LA,La
802442MA,mA
816902MAO,Mao
817902MArch,March
828742MB,Mb
829042MD,Md
846932MIDI,Midi
856882MN,Mn
856972MO,Mo
872192MS,Ms
872292MT,Mt
880202Mv,mV
889802NB,Nb
889852ND,Nd
889882NE,Ne
914502NP,Np
918762OB,Ob
944622OS,Os
955462PA,Pa
975402PB,Pb
1018332Pm,PM
1018642Po,PO
1035342PR,Pr
1075352RA,Ra
1080622RAM,Ram
1111982RF,Rf
1112012RH,Rh
1120552RN,Rn
1153072SB,Sb
1153112SC,Sc
1163672SE,Se
1194652SI,Si
1213972SM,Sm
1222862SoHo,Soho
1306232TB,Tb
1306262TC,Tc
1355972Trojan Horse,Trojan horse
1424392WAC,Wac
1465172YB,Yb
1468412Young Turk,young Turk
1469872ZB,Zb
senses having a cased form
SELECT COUNT(*) FROM senses WHERE NOT ISNULL(casedwordid)
COUNT(*)
43972
words having a cased form
SELECT COUNT(*) FROM words INNER JOIN casedwords USING (wordid)
COUNT(*)
40791