MYSQL

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

lemma	pos	sensenum	synsetid	SUBSTRING(definition FROM 1 FOR 64)	SUBSTRING(sampleset FROM 1 FOR 50)
want	n	1	114493426	a state of extreme poverty
want	n	2	114449405	the state of needing something that is absent or unavailable	water is the critical deficiency in desert regions
want	n	3	109367991	anything that is necessary but lacking	I tried to supply his wants
want	n	4	107486229	a specific feeling of desire	he was above all wishing and desire
want	v	1	201825237	feel or have a desire for; want strongly	I want my own room
want	v	2	201188725	have need of
want	v	3	201317064	hunt or look for; want for a particular reason	Uncle Sam wants you
want	v	4	200709205	wish or demand the presence of
want	v	5	202632567	be without, lack; be deficient in	want the strength to go on living\|flood victims wa

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

lemma	pos	sensenum	synsetid	SUBSTRING(definition FROM 1 FOR 64)	SUBSTRING(sampleset FROM 1 FOR 50)
like	v	1	201824736	prefer or wish to do something	Would you like to come along to the movies?
like	v	2	201777210	find enjoyable or agreeable	She likes to read Russian novels
like	v	3	201776952	be fond of
like	v	4	200691665	feel about or towards; consider, evaluate, or regard
like	v	5	201825962	want to have

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

lemma	pos	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 my own room
want	v	2	have need of
want	v	3	hunt or look for; want for a particular reason	Uncle Sam wants you
want	v	4	wish or demand the presence of
want	v	5	be without, lack; be deficient in	want the strength to go on living\|flood victims wa

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

lemma	pos	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	0	be without, lack; be deficient in

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

lemma	pos	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	3	lacking courage; ignobly timid and faint-hearted
fearful	s	1	experiencing or showing fear
fearful	s	2	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 lemma,pos,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE lemma LIKE '%wards' ORDER BY lemma,pos,sensenum

lemma	pos	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
forwards	r	2	in a forward direction
frontwards	r	1	at or to or toward the front
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 lemma,pos,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE lemma LIKE '%ipod%' ORDER BY lemma,pos,sensenum

lemma	pos	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 lemma,pos,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict WHERE lemma LIKE 'rhino%s' ORDER BY lemma,pos,sensenum

lemma	pos	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 lexdomainname,lemma,pos,sensenum,SUBSTRING(definition FROM 1 FOR 64) FROM dict INNER JOIN lexdomains USING(lexdomainid,pos) WHERE lemma LIKE '%ipod%' ORDER BY lexdomainid,lemma,pos,sensenum

lexdomainname	lemma	pos	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.linkdef	antipodal	n	1	the relation of opposition along a diameter
noun.linkdef	antipodal opposition	n	1	the relation of opposition along a diameter
noun.linkdef	antipode	n	1	direct opposite

SELECT SUBSTRING(definition FROM 1 FOR 64) FROM synsets WHERE pos= '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,pos,GROUP_CONCAT(lemma),SUBSTRING(definition FROM 1 FOR 60) FROM dict WHERE synsetid IN (201824736,201777210,201776952,200691665,201825962) GROUP BY synsetid

synsetid	pos	GROUP_CONCAT(lemma)	SUBSTRING(definition FROM 1 FOR 60)
200691665	v	like	feel about or towards; consider, evaluate, or regard
201776952	v	like	be fond of
201777210	v	like	find enjoyable or agreeable
201824736	v	wish,like,care	prefer or wish to do something
201825962	v	like	want to have

synsetid	pos	GROUP_CONCAT(lemma)	SUBSTRING(definition FROM 1 FOR 60)
300019731	s	handy,ready to hand	easy to reach
300062626	s	handy	skillful with the hands
300604897	s	handy	easy to use