0

When I search for the definition for a word let's say 'surprise'. It gives me all the meanings. 

SELECT words.lemma, synsets.definition FROM words INNER JOIN senses USING (wordid) INNER JOIN synsets USING (synsetid) where words.lemma = 'surprise'

enter image description here

This is the same as mentioned online on Princeton's website.

enter image description here

Now when I search for a morpheme of this word - 'surprising' all I am getting is just a single definition wheres wordnet shows four taking other three from the base form surprise.

enter image description here

enter image description here

How do I get which definitions of the base word are used by the morphemes?

mihirjoshi
  • 12,161
  • 7
  • 47
  • 78
  • You probably need to do your own stemming. – bishop Dec 03 '18 at 03:23
  • You can add more *where* clause, and indicate the words that are most frequent in your first search. Refer to this [link](https://stackoverflow.com/questions/16240041/sql-search-multiple-values-in-same-field) which OP aims to optimize his searching algorithm. – BlitzNinja29 Dec 03 '18 at 02:58
  • @bishop even after doing stemming how would I find that only verb forms are used and not the noun. – mihirjoshi Dec 03 '18 at 04:47

0 Answers0