LINKS

get words lexically-linked to "horse"

SELECT ssensenum,sw.lemma,link,dw.lemma AS linkedlemma,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid LEFT JOIN linktypes USING (linkid) WHERE sw.lemma = 'horse' ORDER BY linkid,ssensenum

ssensenum | lemma | link | linkedlemma | SUBSTRING(sdefinition FROM 1 FOR 60) |
---|---|---|---|---|

1 | horse | hypernym | cater | provide with a horse or horses |

1 | horse | hypernym | ply | provide with a horse or horses |

1 | horse | hypernym | equid | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hypernym | provide | provide with a horse or horses |

1 | horse | hypernym | equine | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hypernym | supply | provide with a horse or horses |

2 | horse | hypernym | gymnastic apparatus | a padded gymnastic apparatus on legs |

2 | horse | hypernym | exerciser | a padded gymnastic apparatus on legs |

3 | horse | hypernym | soldiery | troops trained to fight on horseback |

3 | horse | hypernym | troops | troops trained to fight on horseback |

3 | horse | hypernym | military personnel | troops trained to fight on horseback |

4 | horse | hypernym | framework | a framework for holding wood that is being sawed |

5 | horse | hypernym | chess piece | a chessman shaped to resemble the head of a horse; can move |

5 | horse | hypernym | chessman | a chessman shaped to resemble the head of a horse; can move |

1 | horse | hyponym | poster | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | hack | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | gee-gee | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | chestnut | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | plug | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | protohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | palomino | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | racehorse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | remount | provide with a horse or horses |

1 | horse | hyponym | mare | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | workhorse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | roan | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | pacer | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | hack | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | dawn horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | liver chestnut | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | pinto | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | steeplechaser | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | mount | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | post-horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | polo pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | stable companion | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | high stepper | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | jade | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | eohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | bay | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | bangtail | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | male horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | stalking-horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | riding horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | post horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | wild horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | stablemate | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | stepper | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | nag | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | mesohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | sorrel | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | race horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | female horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | harness horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hyponym | saddle horse | solid-hoofed herbivorous quadruped domesticated since prehis |

2 | horse | hyponym | buck | a padded gymnastic apparatus on legs |

2 | horse | hyponym | long horse | a padded gymnastic apparatus on legs |

2 | horse | hyponym | pommel horse | a padded gymnastic apparatus on legs |

2 | horse | hyponym | vaulting horse | a padded gymnastic apparatus on legs |

2 | horse | hyponym | side horse | a padded gymnastic apparatus on legs |

4 | horse | hyponym | trestle | a framework for holding wood that is being sawed |

1 | horse | part holonym | poll | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | encolure | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | horseflesh | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | withers | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | horseback | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | horsemeat | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | gaskin | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | part holonym | horse's foot | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | member holonym | foal | solid-hoofed herbivorous quadruped domesticated since prehis |

3 | horse | member holonym | trooper | troops trained to fight on horseback |

3 | horse | member holonym | cavalryman | troops trained to fight on horseback |

1 | horse | member meronym | genus equus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | member meronym | equus | solid-hoofed herbivorous quadruped domesticated since prehis |

3 | horse | domain category | military | troops trained to fight on horseback |

3 | horse | domain category | military machine | troops trained to fight on horseback |

3 | horse | domain category | armed forces | troops trained to fight on horseback |

3 | horse | domain category | war machine | troops trained to fight on horseback |

3 | horse | domain category | armed services | troops trained to fight on horseback |

5 | horse | domain category | chess | a chessman shaped to resemble the head of a horse; can move |

5 | horse | domain category | chess game | a chessman shaped to resemble the head of a horse; can move |

get hypernyms for "horse"

SELECT ssensenum,sw.lemma,dw.lemma AS hypernym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'horse' AND linkid=1 AND spos='n' ORDER BY ssensenum

ssensenum | lemma | hypernym | SUBSTRING(sdefinition FROM 1 FOR 60) |
---|---|---|---|

1 | horse | equid | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | equine | solid-hoofed herbivorous quadruped domesticated since prehis |

2 | horse | exerciser | a padded gymnastic apparatus on legs |

2 | horse | gymnastic apparatus | a padded gymnastic apparatus on legs |

3 | horse | military personnel | troops trained to fight on horseback |

3 | horse | soldiery | troops trained to fight on horseback |

3 | horse | troops | troops trained to fight on horseback |

4 | horse | framework | a framework for holding wood that is being sawed |

5 | horse | chess piece | a chessman shaped to resemble the head of a horse; can move |

5 | horse | chessman | a chessman shaped to resemble the head of a horse; can move |

get hyponyms for "horse"

SELECT ssensenum,sw.lemma,dw.lemma AS hyponym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'horse' AND linkid=2 AND spos='n' ORDER BY ssensenum

ssensenum | lemma | hyponym | SUBSTRING(sdefinition FROM 1 FOR 60) |
---|---|---|---|

1 | horse | roan | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | stable companion | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | stablemate | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | gee-gee | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | dawn horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | eohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | mesohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | protohippus | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | male horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | female horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | mare | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | mount | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | riding horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | saddle horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | polo pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | wild horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hack | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | hack | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | jade | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | nag | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | plug | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | pony | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | bangtail | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | race horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | racehorse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | steeplechaser | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | stalking-horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | harness horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | workhorse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | post-horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | post horse | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | poster | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | pacer | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | high stepper | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | stepper | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | chestnut | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | liver chestnut | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | bay | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | sorrel | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | palomino | solid-hoofed herbivorous quadruped domesticated since prehis |

1 | horse | pinto | solid-hoofed herbivorous quadruped domesticated since prehis |

2 | horse | pommel horse | a padded gymnastic apparatus on legs |

2 | horse | side horse | a padded gymnastic apparatus on legs |

2 | horse | buck | a padded gymnastic apparatus on legs |

2 | horse | long horse | a padded gymnastic apparatus on legs |

2 | horse | vaulting horse | a padded gymnastic apparatus on legs |

4 | horse | trestle | a framework for holding wood that is being sawed |

get words lexically-linked to "black"

SELECT ssensenum,sw.lemma,link,dw.lemma AS linked,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXlexlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid LEFT JOIN linktypes USING (linkid) WHERE sw.lemma = 'black' ORDER BY linkid,ssensenum

ssensenum | lemma | link | linked | SUBSTRING(sdefinition FROM 1 FOR 60) |
---|---|---|---|---|

1 | black | antonym | white | being of the achromatic color of maximum darkness; having li |

1 | black | antonym | white | the quality or state of the achromatic color of least lightn |

2 | black | antonym | white | of or belonging to a racial group having dark skin especiall |

6 | black | antonym | white | (board games) the darker pieces |

1 | black | derivation | black | the quality or state of the achromatic color of least lightn |

1 | black | derivation | blackness | being of the achromatic color of maximum darkness; having li |

1 | black | derivation | black | make or become black |

8 | black | derivation | blackness | extremely dark |

13 | black | derivation | blackness | (of coffee) without cream or sugar |

14 | black | derivation | blackness | soiled with dirt or soot |

get antonyms for "black"

SELECT ssensenum,sw.lemma,dw.lemma AS antonym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXlexlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'black' AND linkid=30 AND spos='a' ORDER BY ssensenum

ssensenum | lemma | antonym | SUBSTRING(sdefinition FROM 1 FOR 60) |
---|---|---|---|

1 | black | white | being of the achromatic color of maximum darkness; having li |

2 | black | white | of or belonging to a racial group having dark skin especiall |

get synsetids "option" is member of

SELECT lemma,sensenum,synsetid FROM wordsXsenses WHERE lemma='option' ORDER BY sensenum

lemma | sensenum | synsetid |
---|---|---|

option | 1 | 113241600 |

option | 2 | 105790944 |

option | 3 | 100161243 |

get synsets "option" is member of

SELECT lemma,sensenum,synsetid,pos,SUBSTRING(definition FROM 1 FOR 60) FROM wordsXsensesXsynsets WHERE lemma='option' ORDER BY sensenum

lemma | sensenum | synsetid | pos | SUBSTRING(definition FROM 1 FOR 60) |
---|---|---|---|---|

option | 1 | 113241600 | n | the right to buy or sell property at an agreed price; the ri |

option | 2 | 105790944 | n | one of a number of things from which only one can be chosen |

option | 3 | 100161243 | n | the act of choosing or selecting |

get synset members

SELECT synsetid,lemma FROM wordsXsensesXsynsets WHERE synsetid = 100161243

synsetid | lemma |
---|---|

100161243 | choice |

100161243 | option |

100161243 | pick |

100161243 | selection |

get comma-separated list of synset members

SELECT synsetid,GROUP_CONCAT(lemma) FROM wordsXsensesXsynsets WHERE synsetid = 100161243 GROUP BY synsetid

synsetid | GROUP_CONCAT(lemma) |
---|---|

100161243 | choice,option,pick,selection |

get synsets

SELECT synsetid,lemma FROM wordsXsensesXsynsets WHERE lemma = 'option'

synsetid | lemma |
---|---|

100161243 | option |

105790944 | option |

113241600 | option |

synonyms

SELECT synsetid,dest.lemma,SUBSTRING(src.definition FROM 1 FOR 60) FROM wordsXsensesXsynsets AS src INNER JOIN wordsXsensesXsynsets AS dest USING(synsetid) WHERE src.lemma = 'option' AND dest.lemma <> 'option'

synsetid | lemma | SUBSTRING(src.definition FROM 1 FOR 60) |
---|---|---|

100161243 | choice | the act of choosing or selecting |

100161243 | pick | the act of choosing or selecting |

100161243 | selection | the act of choosing or selecting |

105790944 | alternative | one of a number of things from which only one can be chosen |

105790944 | choice | one of a number of things from which only one can be chosen |

synonyms (alternative)

SELECT synsetid,lemma,SUBSTRING(definition FROM 1 FOR 60) FROM wordsXsensesXsynsets WHERE synsetid IN ( SELECT synsetid FROM wordsXsensesXsynsets WHERE lemma = 'option') AND lemma <> 'option' ORDER BY synsetid

synsetid | lemma | SUBSTRING(definition FROM 1 FOR 60) |
---|---|---|

100161243 | choice | the act of choosing or selecting |

100161243 | selection | the act of choosing or selecting |

100161243 | pick | the act of choosing or selecting |

105790944 | alternative | one of a number of things from which only one can be chosen |

105790944 | choice | one of a number of things from which only one can be chosen |