MYSQL

SELECT word,posid,sensenum,synsetid,SUBSTRING(definition FROM 1 FOR 64),SUBSTRING(sampleset FROM 1 FOR 50) FROM dict WHERE word = 'want' ORDER BY posid,sensenum

word	posid	sensenum	synsetid	SUBSTRING(definition FROM 1 FOR 64)	SUBSTRING(sampleset FROM 1 FOR 50)
want	n	1	113208	a state of extreme poverty
want	n	2	112981	the state of needing something that is absent or unavailable	there is a serious lack of insight into the proble
want	n	3	85916	anything that is necessary but lacking	he had sufficient means to meet his simple needs\|I
want	n	4	76130	a specific feeling of desire	he got his wish\|he was above all wishing and desir
want	v	1	32089	feel or have a desire for; want strongly	I want to go home now\|I want my own room
want	v	2	21985	have need of	This piano wants the attention of a competent tune
want	v	3	24005	hunt or look for; want for a particular reason	Your former neighbor is wanted by the FBI\|Uncle Sa
want	v	4	14649	wish or demand the presence of	I want you here at noon!
want	v	5	45373	be without, lack; be deficient in	want courtesy\|want the strength to go on living\|fl

SELECT word,posid,sensenum,synsetid,SUBSTRING(definition FROM 1 FOR 64),SUBSTRING(sampleset FROM 1 FOR 50) FROM dict WHERE word = 'like' AND posid = 'v' ORDER BY posid,sensenum

word	posid	sensenum	synsetid	SUBSTRING(definition FROM 1 FOR 64)	SUBSTRING(sampleset FROM 1 FOR 50)
like	v	1	32082	to hope, to desire or to prefer to have something, or to do some	Do you care to try this dish?\|Would you like to co
like	v	2	31296	find enjoyable or agreeable	I like jogging\|She likes to read Russian novels
like	v	3	31291	be fond of	I like my nephews
like	v	4	14393	feel about or towards; consider, evaluate, or regard	How did you like the President's speech last night
like	v	5	32099	want to have	I'd like a beer now!

SELECT word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64),SUBSTRING(sampleset FROM 1 FOR 50) FROM dict WHERE word = 'want' AND posid = 'v' ORDER BY posid,sensenum

word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)	SUBSTRING(sampleset FROM 1 FOR 50)
want	v	1	feel or have a desire for; want strongly	I want to go home now\|I want my own room
want	v	2	have need of	This piano wants the attention of a competent tune
want	v	3	hunt or look for; want for a particular reason	Your former neighbor is wanted by the FBI\|Uncle Sa
want	v	4	wish or demand the presence of	I want you here at noon!
want	v	5	be without, lack; be deficient in	want courtesy\|want the strength to go on living\|fl

SELECT word,posid,sensenum,tagcount,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE word = 'want' ORDER BY posid,sensenum

word	posid	sensenum	tagcount	SUBSTRING(definition FROM 1 FOR 64)
want	n	1	3	a state of extreme poverty
want	n	2	1	the state of needing something that is absent or unavailable
want	n	3	1	anything that is necessary but lacking
want	n	4	1	a specific feeling of desire
want	v	1	389	feel or have a desire for; want strongly
want	v	2	15	have need of
want	v	3	3	hunt or look for; want for a particular reason
want	v	4	2	wish or demand the presence of
want	v	5		be without, lack; be deficient in

SELECT word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE word LIKE 'fear%' ORDER BY word,posid,sensenum

word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)
fear	n	1	an emotion experienced in anticipation of some specific pain or
fear	n	2	an anxious feeling
fear	n	3	a feeling of profound respect for someone or something
fear	v	1	be afraid or feel anxious or apprehensive about a possible or pr
fear	v	2	be afraid or scared of; be frightened of
fear	v	3	be sorry; used to introduce an unpleasant statement
fear	v	4	be uneasy or apprehensive about
fear	v	5	regard with feelings of respect and reverence; consider hallowed
fearful	a	1	lacking courage; ignobly timid and faint-hearted
fearful	s	2	experiencing or showing fear
fearful	s	3	causing fear or dread or terror
fearful	s	4	extremely distressing
fearful	s	5	timid by nature or revealing timidity
fearfully	r	1	in fear
fearfully	r	2	in an alarming manner
fearfulness	n	1	an emotion experienced in anticipation of some specific pain or
fearfulness	n	2	the trait of being afraid
fearless	a	1	oblivious of dangers or perils or calmly resolute in facing them
fearless	s	2	invulnerable to fear or intimidation
fearlessly	r	1	without fear
fearlessness	n	1	feeling no fear
fearlessness	n	2	the trait of feeling no fear
fearsome	s	1	causing fear or dread or terror
fearsomely	r	1	in a fearsome manner

SELECT word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE word LIKE '%wards' ORDER BY word,posid,sensenum

word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)
afterwards	r	1	happening at a time subsequent to a reference time
backwards	r	1	at or to or toward the back or rear
backwards	r	2	in a manner or order or direction the reverse of normal
bend over backwards	v	1	try very hard to please someone
downwards	r	1	spatially or metaphorically from a higher to a lower level or po
eastwards	r	1	toward the east
edwards	n	1	American theologian whose sermons and writings stimulated a peri
fall over backwards	v	1	try very hard to please someone
forwards	r	1	at or to or toward the front; forward
forwards	r	2	in a forward direction
frontwards	r	1	at or to or toward the front; forward
heavenwards	r	1	toward heaven
homewards	r	1	toward home
inwards	r	1	to or toward the inside of
inwards	r	2	toward the center or interior
jonathan edwards	n	1	American theologian whose sermons and writings stimulated a peri
landwards	r	1	toward land
northwards	r	1	in a northern direction
onwards	r	1	in a forward direction
outwards	r	1	toward the outside
rearwards	r	1	at or to or toward the back or rear
seawards	r	1	in the direction of the sea
sidewards	r	1	toward one side
skywards	r	1	toward the sky
soar upwards	v	1	rise rapidly
southwards	r	1	toward the south
spacewards	r	1	towards outer space
upwards	r	1	spatially or metaphorically from a lower to a higher position
upwards	r	2	to a later time
westwards	r	1	toward the west

SELECT word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE word LIKE '%ipod%' ORDER BY word,posid,sensenum

word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)
amphipod	n	1	a kind of malacostracan crustacean
amphipoda	n	1	small flat-bodied semiterrestrial crustaceans: whale lice; sand-
antipodal	n	1	the relation of opposition along a diameter
antipodal	a	1	relating to the antipodes or situated at opposite sides of the e
antipodal opposition	n	1	the relation of opposition along a diameter
antipode	n	1	direct opposite
antipodean	a	1	relating to the antipodes or situated at opposite sides of the e
antipodes	n	1	any two places or regions on diametrically opposite sides of the
camera tripod	n	1	a tripod used to support a camera
dipodidae	n	1	Old World jerboas
dipodomys	n	1	kangaroo rats
dipodomys ordi	n	1	most widely distributed kangaroo rat: plains and mountain areas
dipodomys phillipsii	n	1	any of various leaping rodents of desert regions of North Americ
family dipodidae	n	1	Old World jerboas
genus dipodomys	n	1	kangaroo rats
genus microdipodops	n	1	kangaroo mice
hemipode	n	1	small quail-like terrestrial bird of southern Eurasia and northe
ipod	n	1	(trademark) a pocket-sized device used to play music files
microdipodops	n	1	kangaroo mice
order amphipoda	n	1	small flat-bodied semiterrestrial crustaceans: whale lice; sand-
tripod	n	1	a three-legged rack used for support
video ipod	n	1	(trademark) an iPod that can also play video files

SELECT word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE word LIKE 'rhino%s' ORDER BY word,posid,sensenum

word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)
rhinoceros	n	1	massive powerful herbivorous odd-toed ungulate of southeast Asia
rhinoceros antiquitatis	n	1	extinct thick-haired species of Arctic regions
rhinoceros unicornis	n	1	having one horn
rhinonicteris	n	1	orange horseshoe bats
rhinonicteris aurantius	n	1	a common bat of northwestern Australia having orange or yellow f
rhinoptera bonasus	n	1	large ray found along eastern coast of North America
rhinosporidiosis	n	1	fungal infection of the nose; often acquired while swimming
rhinostenosis	n	1	narrowing of the passages in the nasal cavities
rhinotracheitis	n	1	a respiratory infection of the nose and throat in cattle
rhinovirus	n	1	any of a group of picornaviruses that are responsible for many u

SELECT domainname,word,posid,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict INNER JOIN domains USING(domainid,posid) WHERE word LIKE '%ipod%' ORDER BY domainid,word,posid,sensenum

domainname	word	posid	sensenum	SUBSTRING(definition FROM 1 FOR 64)
adj.pert	antipodal	a	1	relating to the antipodes or situated at opposite sides of the e
adj.pert	antipodean	a	1	relating to the antipodes or situated at opposite sides of the e
noun.animal	amphipod	n	1	a kind of malacostracan crustacean
noun.animal	amphipoda	n	1	small flat-bodied semiterrestrial crustaceans: whale lice; sand-
noun.animal	dipodidae	n	1	Old World jerboas
noun.animal	dipodomys	n	1	kangaroo rats
noun.animal	dipodomys ordi	n	1	most widely distributed kangaroo rat: plains and mountain areas
noun.animal	dipodomys phillipsii	n	1	any of various leaping rodents of desert regions of North Americ
noun.animal	family dipodidae	n	1	Old World jerboas
noun.animal	genus dipodomys	n	1	kangaroo rats
noun.animal	genus microdipodops	n	1	kangaroo mice
noun.animal	hemipode	n	1	small quail-like terrestrial bird of southern Eurasia and northe
noun.animal	microdipodops	n	1	kangaroo mice
noun.animal	order amphipoda	n	1	small flat-bodied semiterrestrial crustaceans: whale lice; sand-
noun.artifact	camera tripod	n	1	a tripod used to support a camera
noun.artifact	ipod	n	1	(trademark) a pocket-sized device used to play music files
noun.artifact	tripod	n	1	a three-legged rack used for support
noun.artifact	video ipod	n	1	(trademark) an iPod that can also play video files
noun.location	antipodes	n	1	any two places or regions on diametrically opposite sides of the
noun.relation	antipodal	n	1	the relation of opposition along a diameter
noun.relation	antipodal opposition	n	1	the relation of opposition along a diameter
noun.relation	antipode	n	1	direct opposite

SELECT SUBSTRING(definition FROM 1 FOR 64) FROM synsets WHERE posid= 'n' AND definition LIKE '(trademark)%' LIMIT 20

SUBSTRING(definition FROM 1 FOR 64)
(trademark) a guide dog trained to guide a blind person
(trademark) a pocket-sized device used to play music files
(trademark) an iPod that can also play video files
(trademark) a child's plastic construction set for making mechan
(trademark) an in-line skate
(trademark) a desktop rotary card index with removable cards; us
(trademark) a self-balancing personal transportation device with
(trademark) a pocket-sized stereo system with light weight earph
(trademark) a hollow plastic ball with cutouts
(trademark) an operating system with a graphical user interface
(trademark) a sweet aromatic French wine (red or white) used chi
(trademark) a liquid that temporarily disables a person; prepare
(trademark) a microscopic and traceable identification particle

SELECT synsetid,posid,GROUP_CONCAT(word),SUBSTRING(definition FROM 1 FOR 60) FROM dict WHERE synsetid IN (1,2,3,4,5) GROUP BY synsetid

synsetid	posid	GROUP_CONCAT(word)	SUBSTRING(definition FROM 1 FOR 60)
1	a	able	(usually followed by `to') having the necessary means or ski
2	n	entity	that which is perceived or known or inferred to have its own
3	r	a capella,a cappella	without musical accompaniment
4	v	breathe,respire,suspire,take a breath	draw air into, and expel out of, the lungs
5	r	a.d.,ad,anno domini	in the Christian era; used before dates after the supposed y

SELECT synsetid,posid,GROUP_CONCAT(word),SUBSTRING(definition FROM 1 FOR 60) FROM dict WHERE synsetid IN (SELECT synsetid FROM synsets INNER JOIN senses USING (synsetid) INNER JOIN words USING(wordid) WHERE word='spread') GROUP BY synsetid

synsetid	posid	GROUP_CONCAT(word)	SUBSTRING(definition FROM 1 FOR 60)
8132	n	spreading,spread	act of extending over a wider scope or expanse of space or t
12017	s	spread,dispersed	distributed or spread over a considerable extent
18513	v	disperse,spread,propagate,pass around,distribute,disseminate,diffuse,circulate,circularize,circularise,broadcast	cause to become widely known
18532	v	spread,go around,circulate	become widely known and passed on
24978	v	spread,distribute	distribute or disperse widely
25001	v	spread,propagate	become distributed or widespread
25851	s	spread,outspread	fully extended in width
28163	v	unfold,spread out,spread,open	spread out or open from a closed or folded state
28701	v	spread	distribute over a surface in a layer
28704	v	spread	cover by spreading something over
32433	s	spread	prepared or arranged for a meal; especially having food set
35864	v	diffuse,fan out,spread,spread out	move outward
36215	v	scatter,spread,spread out	strew or distribute over an area
46351	v	overspread,spread	spread across or over
48461	n	bed cover,bed covering,bedcover,bedspread,counterpane,spread	decorative cover for a bed
57979	n	spread,cattle farm,cattle ranch,ranch	farm consisting of a large tract of land along with faciliti
62028	n	gap,spread	a conspicuous disparity or difference as between two figures
63760	n	spread,scatter	a haphazard distribution in all directions
63832	n	spread	the expansion of a person's girth (especially at middle age)
69426	n	spread,spread head,spreadhead,facing pages	two facing pages of a book or other publication
75888	n	spread,spreading	process or result of distributing or extending over a wide e
76639	n	banquet,feast,spread	a meal that is well prepared and greatly enjoyed
78530	n	paste,spread	a tasty mixture to be spread on bread or crackers or used in