WordNet (morphology)
morphology
lemma from morph
SELECT * FROM morphology WHERE morph = 'better'
morphidwordidlemmaposmorph
31858883goodabetter
318143804wellabetter
318143804wellrbetter
morph from lemma
SELECT * FROM morphology WHERE lemma = 'good'
morphidwordidlemmaposmorph
30958883goodabest
31858883goodabetter
chivy-chevied,chevies,chevying,chivied,chivvied,chivvies,chivvying
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'chivy'
lemmaposmorph
chivyvchevied
chivyvchevies
chivyvchevying
chivyvchivied
chivyvchivvied
chivyvchivvies
chivyvchivvying
quiz(n,v)-quizzes
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'quiz'
lemmaposmorph
quiznquizzes
quizvquizzed
quizvquizzes
quizvquizzing
gas(n,v)-gasses
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'gas'
lemmaposmorph
gasngas
gasngasses
gasvgassed
gasvgasses
gasvgassing
good,well-better
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE morph = 'better'
lemmaposmorph
goodabetter
wellabetter
wellrbetter
well(a,r)-better
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'well'
lemmaposmorph
wellabetter
wellrbest
wellrbetter
be-am,are,been,is,was,were
SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'be'
lemmaposmorph
bevam
bevare
bevbeen
bevis
bevwas
bevwere
morphs per lemma
SELECT lemma,COUNT(morph) AS N,GROUP_CONCAT(morph) AS morphs,GROUP_CONCAT(pos) FROM morphology GROUP BY lemma HAVING N > 1 LIMIT 20
lemmaNmorphsGROUP_CONCAT(pos)
abet2abetting,abettedv,v
abhor2abhorring,abhorredv,v
abut2abutting,abuttedv,v
aby2abye,aboughtv,v
acquit2acquitting,acquittedv,v
ad-lib2ad-libbing,ad-libbedv,v
admit2admitted,admittingv,v
airdrop2airdropping,airdroppedv,v
airy2airiest,airiera,a
allot2allotted,allottingv,v
allow for3allowing for,allowed for,allows forv,v,v
angry2angrier,angriesta,a
annul2annulled,annullingv,v
antheridium2andtheridia,antheridian,n
appal2appalled,appallingv,v
appall2appalled,appallingv,v
arc2arcking,arckedv,v
argali2argali,araglisn,n
arise2arose,arisenv,v
arty2artier,artiesta,a
lemma per morph
SELECT morph,COUNT(lemma) AS N,GROUP_CONCAT(lemma) AS lemmas,GROUP_CONCAT(pos) FROM morphology GROUP BY morph HAVING N > 1 LIMIT 20
morphNlemmasGROUP_CONCAT(pos)
appalled2appal,appallv,v
appalling2appal,appallv,v
assegais2assagai,assegain,n
auspices2auspex,auspicen,n
axes2ax,axisn,n
bacchantes2bacchant,bacchanten,n
bases2base,basisn,n
beadsmen2beadsman,bedesmann,n
best2good,wella,r
better3good,well,wella,a,r
bicennaries2bicentenary,bicentennialn,n
brants2brant,brentn,n
caddied2caddie,caddyv,v
caddies2caddie,caddyv,v
caddying2caddie,caddyv,v
comics2comic strip,comicn,n
distilled2distil,distillv,v
distilling2distil,distillv,v
djinn2djinni,djinnyn,n
enrolled2enrol,enrollv,v
lemma - 3 (or more) morphs
SELECT lemma,COUNT(wordid) AS N,GROUP_CONCAT(morph),GROUP_CONCAT(pos) FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY wordid HAVING N > 2 ORDER BY N DESC
lemmaNGROUP_CONCAT(morph)GROUP_CONCAT(pos)
chivy7chivvied,chevying,chivied,chevies,chevied,chivvying,chivviesv,v,v,v,v,v,v
be6are,were,am,been,is,wasv,v,v,v,v,v
dry5dried,dryest,dryer,driest,drierv,a,a,a,a
gas5gasses,gasses,gassed,gassing,gasv,n,v,v,n
red5redder,redded,red,redding,reddesta,v,v,v,a
shy5shied,shyest,shyer,shiest,shierv,a,a,a,a
swap5swops,swopping,swopped,swapping,swappedv,v,v,v,v
trammel5tramels,tramelling,tramelled,trameling,trameledv,v,v,v,v
wry5wryer,wrier,wried,wryest,wriesta,a,v,a,a
beget4begetting,begotten,begat,begotv,v,v,v
coordinate4co-ordinated,co-ordinate,co-ordinating,co-ordinatesv,v,v,v
dim4dimmed,dimming,dimmest,dimmerv,v,a,a
drab4drabbest,drabber,drabbed,drabbinga,a,v,v
dun4dunner,dunned,dunning,dunnesta,v,v,a
fat4fatter,fatted,fatting,fattesta,v,v,a
fit4fitting,fittest,fitter,fittedv,a,a,v
flat4flatter,flatted,flatting,flattesta,v,v,a
forbid4forbidden,forbade,forbad,forbiddingv,v,v,v
go deep4going deep,goes deep,gone deep,went deepv,v,v,v
mad4madder,madded,madding,maddesta,v,v,a
pasquinade4pasquil,pasquils,pasquilling,pasquilledv,v,v,v
prim4primmest,primmer,primmed,primminga,a,v,v
quiz4quizzes,quizzes,quizzed,quizzingv,n,v,v
shake hands4shaking hands,shook hands,shakes hands,shaken handsv,v,v,v
sly4slyest,sliest,slyer,sliera,a,a,a
snug4snuggest,snugger,snugged,snugginga,a,v,v
squat4squatted,squatting,squattest,squatterv,v,a,a
take pains4taken pains,took pains,taking pains,takes painsv,v,v,v
tan4tanner,tanned,tanning,tannesta,v,v,a
thin4thinning,thinnest,thinner,thinnedv,a,a,v
throw out4throwing out,throws out,thrown out,threw outv,v,v,v
trim4trimmest,trimmer,trimmed,trimminga,a,v,v
wan4wannest,wanner,wanned,wanninga,a,v,v
wet4wetted,wetting,wettest,wetterv,v,a,a
allow for3allowing for,allowed for,allows forv,v,v
ban3bani,banning,bannedn,v,v
bandy3bandied,bandiest,bandierv,a,a
bear3bore,borne,bornv,v,v
bed3bedded,bed,beddingv,v,v
begin3begun,began,beginningv,v,v
bestride3bestrid,bestrode,bestriddenv,v,v
bid3bidden,bade,biddingv,v,v
bloody3bloodiest,bloodier,bloodieda,a,v
bog down3bogging down,bogged down,bogs downv,v,v
busy3busied,busiest,busierv,a,a
caddie3caddies,caddied,caddyingv,v,v
caddy3caddies,caddied,caddyingv,v,v
cleave3cleft,cloven,clovev,v,v
colly3colliest,collier,collieda,a,v
cry3cryings,crying,criedn,n,v
curet3curetting,curettes,curettedv,v,v
deepfreeze3deep-freezes,deep-freezed,deep-freezev,v,v
degas3degasses,degassed,degassingv,v,v
dirty3dirtiest,dirtier,dirtieda,a,v
dizzy3dizziest,dizzier,dizzieda,a,v
easy3easiest,easier,easieda,a,v
empty3emptiest,emptier,emptieda,a,v
fancy3fanciest,fancier,fancieda,a,v
forget3forgot,forgetting,forgottenv,v,v
get3gotten,got,gettingv,v,v
get started3gets started,got started,getting startedv,v,v
giddy3giddiest,giddier,giddieda,a,v
gin3ginning,gan,ginnedv,v,v
go3goes,gone,wentn,v,v
grip3gript,gripping,grippedv,v,v
hallah3halloth,hallot,challothn,n,n
join battle3joined battle,joins battle,joining battlev,v,v
join forces3joined forces,joins forces,joining forcesv,v,v
jolly3jolliest,jollier,jollieda,a,v
jump off3jumps off,jumping off,jumped offv,v,v
ken3kenned,kent,kenningv,v,v
ko3ko's,ko'ing,ko'dv,v,v
lie3lying,lay,lainv,v,v
man3manning,manned,menv,v,n
muddy3muddiest,muddier,muddieda,a,v
nonplus3nonplussing,nonplusses,nonplussedv,v,v
os3osar,ora,ossan,n,n
overlie3overlain,overlying,overlayv,v,v
pen3pent,penning,pennedv,v,v
pretty3prettiest,prettier,prettieda,a,v
program3programmes,programmed,programmingv,v,v
prologue3prologs,prologing,prologedv,v,v
savvy3savviest,savvier,savvieda,a,v
shit3shat,shitting,shittedv,v,v
shrink3shrunken,shrunk,shrankv,v,v
sing3singing,sung,sangv,v,v
sink3sunken,sunk,sankv,v,v
smite3smote,smitten,smitv,v,v
spit3spat,spitting,spittedv,v,v
steady3steadier,steadied,steadiesta,v,a
swim3swimming,swam,swumv,v,v
tallith3tallithes,tallaisim,tallitothn,n,n
think the world of3thinking the world of,thought the world of,thinks the world ofv,v,v
tidy3tidied,tidiest,tidierv,a,a
transship3transshipped,tranship,transshippingv,v,v
underlie3underlying,underlay,underlainv,v,v
untidy3untidier,untidied,untidiesta,v,a
weary3wearier,wearied,weariesta,v,a
well3better,best,betterr,r,a
whiz3whizzing,whizzes,whizzedv,v,v
morph - 2 (or more) lemmas
SELECT morph,COUNT(morphid) AS N ,GROUP_CONCAT(lemma),GROUP_CONCAT(pos) FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY morphid HAVING N > 1 ORDER BY N DESC
morphNGROUP_CONCAT(lemma)GROUP_CONCAT(pos)
better3good,well,wella,r,a
appalled2appal,appallv,v
appalling2appall,appalv,v
assegais2assegai,assagain,n
auspices2auspice,auspexn,n
axes2axis,axn,n
bacchantes2bacchante,bacchantn,n
bases2base,basisn,n
beadsmen2beadsman,bedesmann,n
best2good,wella,r
bicennaries2bicentennial,bicentenaryn,n
brants2brent,brantn,n
caddied2caddy,caddiev,v
caddies2caddy,caddiev,v
caddying2caddy,caddiev,v
comics2comic,comic stripn,n
distilled2distill,distilv,v
distilling2distill,distilv,v
djinn2djinny,djinnin,n
enrolled2enroll,enrolv,v
enrolling2enrol,enrollv,v
enthralled2enthrall,enthralv,v
enthralling2enthrall,enthralv,v
entozoa2entozoon,entozoann,n
epizoa2epizoon,epizoann,n
feed2fee,feedv,v
fulfilled2fulfill,fulfilv,v
fulfilling2fulfill,fulfilv,v
gasses2gas,gasv,n
haggadas2haggadah,haggadan,n
halteres2haltere,haltern,n
ichthyosauruses2ichthyosaurus,ichthyosaurn,n
installed2install,instalv,v
installing2install,instalv,v
leaves2leave,leafn,n
litai2litas,litn,n
masses2mass,massen,n
mishnayoth2mishnah,mishnan,n
monades2monas,monadn,n
morses2morse,morsn,n
oedemata2oedema,edeman,n
oesophagi2esophagus,oesophagusn,n
offer2offer,offa,a
overflown2overfly,overflowv,v
paraleipses2paralipsis,paraleipsisn,n
plectra2plectrum,plectronn,n
ploughmen2plowman,ploughmann,n
prothalamia2prothalamium,prothalamionn,n
quizzes2quiz,quizv,n
rabatos2rebato,rabaton,n
saguaros2sahuaro,saguaron,n
shofroth2shophar,shofarn,n
signori2signore,signiorn,n
singing2singe,singv,v
soles2sole,soln,n
taeniae2tenia,taenian,n
taxes2taxis,taxn,n
touracos2turaco,touracon,n
tyros2tyro,tiron,n
wahhabis2wahhabi,wahabin,n
morph matching several pos
SELECT lemma,morph,GROUP_CONCAT(pos),COUNT(*) AS N FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY wordid,morphid HAVING N > 1 ORDER BY N DESC
lemmamorphGROUP_CONCAT(pos)N
gasgassesv,n2
quizquizzesv,n2
wellbetterr,a2