WordNet Legacy
merging synsets
synsets that merge - wordnet 2.0 to 3.1
SELECT GROUP_CONCAT(srcsynsetid) AS srcsynsetids,synsetid,COUNT(*) AS c FROM synsetmaps2031 GROUP BY synsetid HAVING c > 1 LIMIT 10
srcsynsetidssynsetidc
100017572,1130301041000197932
100424160,1007374461004485252
100438755,1004390511004638652
100564356,1046543631005970092
100865764,1140510731009223242
100938688,1009388301009985992
100952179,1045315641010126262
100983027,1041408721010453652
100983644,1009839681010461162
101129413,1011297371011983572
synsets that merge to specific synset - wordnet 2.0 to 3.1
SELECT srcsynsetid, quality FROM synsetmaps2031 WHERE synsetid = 100019793
srcsynsetidquality
1000175721
1130301041
merging senses
senses that merge - wordnet 2.0 to 3.1
SELECT wordid,lemma,GROUP_CONCAT(srcsynsetid) AS srcsynsetids,synsetid,COUNT(*) AS c,quality FROM sensemaps2130 LEFT JOIN words USING (wordid) GROUP BY synsetid,wordid HAVING c > 1 ORDER BY lemma LIMIT 10
wordidlemmasrcsynsetidssynsetidcquality
2466affiliate202564838,20241170420243531120.8
2492afflict201780580,20007003820179773021
2498afford202335639,20271991020274445120.7
2866agree202717441,20102520120274179321
4316alternation104681685,10099672210101068420.3
7863armenian109551722,10836800410969037121
11447barb200505896,20132727120133918120.8
11798base201078166,20062946820063688820.2
12819begin201060200,20265342620267922720.8
13062belong202280009,20262795520230168021
SELECT m.wordid,lemma,GROUP_CONCAT(srcsynsetid) AS srcsynsetids,GROUP_CONCAT(s.sensekey) AS srcsensekeys,d.synsetid,d.sensekey,COUNT(*) AS c, quality FROM sensemaps2130 AS m LEFT JOIN words USING (wordid) LEFT JOIN senses21 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid GROUP BY m.synsetid,m.wordid HAVING COUNT(*) > 1 ORDER BY lemma LIMIT 10
wordidlemmasrcsynsetidssrcsensekeyssynsetidsensekeycquality
2466affiliate202564838,202411704affiliate%2:41:11::,affiliate%2:41:00::202435311affiliate%2:41:00::20.8
2492afflict201780580,200070038afflict%2:37:00::,afflict%2:29:00::201797730afflict%2:37:00::21
2498afford202335639,202719910afford%2:40:01::,afford%2:42:00::202744451afford%2:42:00::20.7
2866agree202717441,201025201agree%2:42:03::,agree%2:32:04::202741793agree%2:42:03::21
4316alternation104681685,100996722alternation%1:07:00::,alternation%1:04:00::101010684alternation%1:04:00::20.3
7863armenian109551722,108368004armenian%1:18:00::,armenian%1:14:00::109690371armenian%1:18:00::21
11447barb200505896,201327271barb%2:30:00::,barb%2:35:00::201339181barb%2:35:00::20.8
11798base201078166,200629468base%2:33:00::,base%2:31:00::200636888base%2:31:00::20.2
12819begin201060200,202653426begin%2:32:04::,begin%2:42:02::202679227begin%2:42:02::20.8
13062belong202280009,202627955belong%2:40:00::,belong%2:42:00::202301680belong%2:40:00::21
senses that merge to specific synset - wordnet 2.0 to 3.1
SELECT s.sensekey,quality FROM sensemaps2130 AS m LEFT JOIN senses21 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid WHERE d.sensekey = 'afford%2:42:00::'
sensekeyquality
afford%2:40:01::0.7
afford%2:42:00::1
forking synsets
synsets that fork - wordnet 2.0 to 3.1
SELECT srcsynsetid, GROUP_CONCAT(synsetid) AS synsetids,COUNT(*) AS c FROM synsetmaps2031 GROUP BY srcsynsetid HAVING c > 1 LIMIT 10
srcsynsetidsynsetidsc
100016236100002684,1061421752
100017572100020270,100019793,1000210073
100018827100021914,1000214452
100022625100027365,1036875152
100032620100037921,1058117552
100034839100040283,1021606062
100051704100057732,1000553032
100067176100073852,1073177712
100075465100082656,1042109322
100098514100106640,1012487532
synsets that fork from specific synset - wordnet 2.0 to 3.1
SELECT synsetid, quality FROM synsetmaps2031 WHERE srcsynsetid = 100016236
synsetidquality
1000026841
1061421751
forking senses
senses that fork - wordnet 2.0 to 3.1
SELECT wordid,lemma,srcsynsetid,GROUP_CONCAT(synsetid) AS synsetids,COUNT(*) AS c,quality FROM sensemaps2130 LEFT JOIN words USING (wordid) GROUP BY srcsynsetid,wordid HAVING c > 1 ORDER BY lemma LIMIT 10
wordidlemmasrcsynsetidsynsetidscquality
2498afford202335639202358034,20274445120.7
11798base201078166200636888,20275619620.2
13062belong202627955202301680,202737569,202737724,20275635940.6
13295berber108368346106990544,10985031720.2
17206breed104868327105839547,10810141020.2
17357brighten202142732200312815,20277116920.2
25143circle202682349201522716,20191133920.2
27202college103038967103069752,108278169,10827832430.3
27481comb105403930101921440,103074855,10307509730.3
27553come back201986635200548153,200959524,20199898230.2
SELECT m.wordid,lemma,srcsynsetid,s.sensekey,GROUP_CONCAT(d.synsetid) AS synsetids,GROUP_CONCAT(d.sensekey) AS sensekeys,COUNT(*) AS c,quality FROM sensemaps2130 AS m LEFT JOIN words USING (wordid) LEFT JOIN senses21 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid GROUP BY m.srcsynsetid,m.wordid HAVING COUNT(*) > 1 ORDER BY lemma LIMIT 10
wordidlemmasrcsynsetidsensekeysynsetidssensekeyscquality
2498afford202335639afford%2:40:01::202358034,202744451afford%2:40:01::,afford%2:42:00::20.7
11798base201078166base%2:33:00::200636888,202756196base%2:31:00::,base%2:42:04::20.2
13062belong202627955belong%2:42:00::202301680,202737569,202737724,202756359belong%2:40:00::,belong%2:42:01::,belong%2:42:02::,belong%2:42:07::40.6
13295berber108368346berber%1:14:00::106990544,109850317berber%1:10:00::,berber%1:18:00::20.2
17206breed104868327breed%1:07:00::105839547,108101410breed%1:09:00::,breed%1:14:00::20.2
17357brighten202142732brighten%2:39:00::200312815,202771169brighten%2:30:01::,brighten%2:43:00::20.2
25143circle202682349circle%2:42:00::201522716,201911339circle%2:35:12::,circle%2:38:01::20.2
27202college103038967college%1:06:01::103069752,108278169,108278324college%1:06:00::,college%1:14:00::,college%1:14:01::30.3
27481comb105403930comb%1:08:00::101921440,103074855,103075097comb%1:05:00::,comb%1:06:00::,comb%1:06:01::30.3
27553come back201986635come_back%2:38:00::200548153,200959524,201998982come_back%2:30:00::,come_back%2:32:00::,come_back%2:38:01::30.2
senses that fork from specific synset - wordnet 2.0 to 3.1
SELECT d.sensekey,quality FROM sensemaps2130 AS m LEFT JOIN senses21 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid WHERE s.sensekey = 'afford%2:40:01::'
sensekeyquality
afford%2:40:01::0.7
afford%2:42:00::0.7
abase (mono)
SELECT lemma,quality,s.synsetid AS ssynsetid,s.sensekey AS ssensekey,GROUP_CONCAT(d.synsetid) AS dsynsetids,GROUP_CONCAT(d.sensekey) AS dsensekeys FROM sensemaps2030 AS m LEFT JOIN words USING (wordid) LEFT JOIN senses20 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid WHERE lemma='abase' GROUP BY m.srcsynsetid,m.wordid ORDER BY s.sensekey
lemmaqualityssynsetidssensekeydsynsetidsdsensekeys
abase1201747514abase%2:37:00::201799794abase%2:37:00::
afford (poly)
SELECT lemma,GROUP_CONCAT(quality),COUNT(*),s.synsetid AS ssynsetid,s.sensekey AS ssensekey,GROUP_CONCAT(d.synsetid) AS dsynsetids,GROUP_CONCAT(d.sensekey) AS dsensekeys FROM sensemaps2030 AS m LEFT JOIN words USING (wordid) LEFT JOIN senses20 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid WHERE lemma='afford' GROUP BY m.srcsynsetid,m.wordid ORDER BY s.sensekey
lemmaGROUP_CONCAT(quality)COUNT(*)ssynsetidssensekeydsynsetidsdsensekeys
afford11201156300afford%2:34:00::201192628afford%2:34:00::
afford11202271697afford%2:40:00::202339171afford%2:40:00::
afford0.4899999833106996,0.4899999833106996,0.6999999880790713202290392afford%2:40:01::202358034,202744451,202744451afford%2:40:01::,afford%2:42:00::,afford%2:42:00::
afford11202664013afford%2:42:00::202744451afford%2:42:00::
want, from sensekey
SELECT lemma,GROUP_CONCAT(quality),COUNT(*),s.synsetid AS ssynsetid,s.sensekey AS ssensekey,GROUP_CONCAT(d.synsetid) AS dsynsetids,GROUP_CONCAT(d.sensekey) AS dsensekeys FROM sensemaps2030 AS m LEFT JOIN words USING (wordid) LEFT JOIN senses20 AS s ON m.srcsynsetid = s.synsetid AND m.wordid = s.wordid LEFT JOIN senses30 AS d ON m.synsetid = d.synsetid AND m.wordid = d.wordid WHERE s.sensekey LIKE 'want\%%' GROUP BY m.srcsynsetid,m.wordid ORDER BY s.sensekey
lemmaGROUP_CONCAT(quality)COUNT(*)ssynsetidssensekeydsynsetidsdsensekeys
want11107028394want%1:12:00::107486229want%1:12:00::
want11108781184want%1:17:00::109367991want%1:17:00::
want0.89999997615814211113669190want%1:26:00::114493426want%1:26:00::
want11113630173want%1:26:01::114449405want%1:26:01::
want11200685831want%2:31:01::200709205want%2:31:01::
want11201152480want%2:34:00::201188725want%2:34:00::
want11201278011want%2:35:00::201317064want%2:35:00::
want11201772101want%2:37:00::201825237want%2:37:00::
want11202554064want%2:42:01::202632567want%2:42:01::