MYSQL

SELECT * FROM morphology WHERE morph = 'better'

morphid	wordid	lemma	pos	morph
318	58843	good	a	better
318	143642	well	a	better
318	143642	well	r	better

SELECT * FROM morphology WHERE lemma = 'good'

morphid	wordid	lemma	pos	morph
309	58843	good	a	best
318	58843	good	a	better

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'chivy'

lemma	pos	morph
chivy	v	chevied
chivy	v	chevies
chivy	v	chevying
chivy	v	chivied
chivy	v	chivvied
chivy	v	chivvies
chivy	v	chivvying

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'quiz'

lemma	pos	morph
quiz	n	quizzes
quiz	v	quizzed
quiz	v	quizzes
quiz	v	quizzing

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'gas'

lemma	pos	morph
gas	n	gas
gas	n	gasses
gas	v	gassed
gas	v	gasses
gas	v	gassing

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE morph = 'better'

lemma	pos	morph
good	a	better
well	a	better
well	r	better

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'well'

lemma	pos	morph
well	a	better
well	r	best
well	r	better

SELECT lemma,pos,morph FROM morphmaps INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE lemma = 'be'

lemma	pos	morph
be	v	am
be	v	are
be	v	been
be	v	is
be	v	was
be	v	were

SELECT lemma,COUNT(morph) AS N,GROUP_CONCAT(morph) AS morphs,GROUP_CONCAT(pos) FROM morphology GROUP BY lemma HAVING N > 1 LIMIT 20

lemma	N	morphs	GROUP_CONCAT(pos)
abet	2	abetted,abetting	v,v
abhor	2	abhorred,abhorring	v,v
abut	2	abutted,abutting	v,v
aby	2	abought,abye	v,v
acquit	2	acquitted,acquitting	v,v
ad-lib	2	ad-libbing,ad-libbed	v,v
admit	2	admitted,admitting	v,v
airdrop	2	airdropping,airdropped	v,v
airy	2	airiest,airier	a,a
allot	2	allotted,allotting	v,v
allow for	3	allowed for,allows for,allowing for	v,v,v
angry	2	angrier,angriest	a,a
annul	2	annulling,annulled	v,v
antheridium	2	andtheridia,antheridia	n,n
appal	2	appalling,appalled	v,v
appall	2	appalled,appalling	v,v
arc	2	arcking,arcked	v,v
argali	2	argali,araglis	n,n
arise	2	arose,arisen	v,v
arty	2	artiest,artier	a,a

SELECT morph,COUNT(lemma) AS N,GROUP_CONCAT(lemma) AS lemmas,GROUP_CONCAT(pos) FROM morphology GROUP BY morph HAVING N > 1 LIMIT 20

morph	N	lemmas	GROUP_CONCAT(pos)
appalled	2	appal,appall	v,v
appalling	2	appal,appall	v,v
assegais	2	assagai,assegai	n,n
auspices	2	auspex,auspice	n,n
axes	2	ax,axis	n,n
bacchantes	2	bacchant,bacchante	n,n
bases	2	base,basis	n,n
beadsmen	2	beadsman,bedesman	n,n
best	2	good,well	a,r
better	3	good,well,well	a,a,r
bicennaries	2	bicentenary,bicentennial	n,n
brants	2	brant,brent	n,n
caddied	2	caddie,caddy	v,v
caddies	2	caddie,caddy	v,v
caddying	2	caddie,caddy	v,v
comics	2	comic strip,comic	n,n
distilled	2	distil,distill	v,v
distilling	2	distil,distill	v,v
djinn	2	djinni,djinny	n,n
enrolled	2	enrol,enroll	v,v

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

lemma	N	GROUP_CONCAT(morph)	GROUP_CONCAT(pos)
chivy	7	chevying,chivied,chevies,chevied,chivvying,chivvies,chivvied	v,v,v,v,v,v,v
be	6	am,were,been,is,was,are	v,v,v,v,v,v
wry	5	wried,wryest,wriest,wryer,wrier	v,a,a,a,a
red	5	redded,red,redding,reddest,redder	v,v,v,a,a
gas	5	gasses,gasses,gassed,gassing,gas	v,n,v,v,n
shy	5	shyest,shyer,shiest,shier,shied	a,a,a,a,v
swap	5	swopping,swopped,swapping,swapped,swops	v,v,v,v,v
trammel	5	tramelling,tramelled,trameling,trameled,tramels	v,v,v,v,v
dry	5	dried,dryest,dryer,driest,drier	v,a,a,a,a
tan	4	tanned,tanning,tannest,tanner	v,v,a,a
dun	4	dunned,dunning,dunnest,dunner	v,v,a,a
prim	4	primmer,primmed,primming,primmest	a,v,v,a
flat	4	flatted,flatting,flattest,flatter	v,v,a,a
throw out	4	throws out,thrown out,threw out,throwing out	v,v,v,v
fat	4	fatted,fatting,fattest,fatter	v,v,a,a
wet	4	wetting,wettest,wetter,wetted	v,a,a,v
trim	4	trimmest,trimmer,trimmed,trimming	a,a,v,v
squat	4	squatted,squatting,squattest,squatter	v,v,a,a
go deep	4	going deep,goes deep,gone deep,went deep	v,v,v,v
pasquinade	4	pasquil,pasquils,pasquilling,pasquilled	v,v,v,v
quiz	4	quizzed,quizzing,quizzes,quizzes	v,v,v,n
sly	4	slyest,sliest,slyer,slier	a,a,a,a
drab	4	drabber,drabbed,drabbing,drabbest	a,v,v,a
shake hands	4	shaking hands,shook hands,shakes hands,shaken hands	v,v,v,v
dim	4	dimmed,dimming,dimmest,dimmer	v,v,a,a
wan	4	wanner,wanned,wanning,wannest	a,v,v,a
mad	4	madder,madded,madding,maddest	a,v,v,a
forbid	4	forbade,forbad,forbidding,forbidden	v,v,v,v
thin	4	thinning,thinnest,thinner,thinned	v,a,a,v
fit	4	fittest,fitter,fitted,fitting	a,a,v,v
beget	4	begetting,begotten,begat,begot	v,v,v,v
snug	4	snuggest,snugger,snugged,snugging	a,a,v,v
take pains	4	took pains,taking pains,takes pains,taken pains	v,v,v,v
coordinate	4	co-ordinated,co-ordinate,co-ordinating,co-ordinates	v,v,v,v
forget	3	forgetting,forgotten,forgot	v,v,v
man	3	manning,manned,men	v,v,n
jump off	3	jumped off,jumps off,jumping off	v,v,v
fancy	3	fanciest,fancier,fancied	a,a,v
dizzy	3	dizziest,dizzier,dizzied	a,a,v
bestride	3	bestrid,bestrode,bestridden	v,v,v
well	3	better,best,better	r,r,a
ken	3	kent,kenning,kenned	v,v,v
curet	3	curettes,curetted,curetting	v,v,v
ban	3	bani,banning,banned	n,v,v
underlie	3	underlying,underlay,underlain	v,v,v
bandy	3	bandiest,bandier,bandied	a,a,v
easy	3	easier,easied,easiest	a,v,a
shrink	3	shrunken,shrunk,shrank	v,v,v
tidy	3	tidiest,tidier,tidied	a,a,v
bid	3	bidden,bade,bidding	v,v,v
savvy	3	savviest,savvier,savvied	a,a,v
go	3	goes,gone,went	n,v,v
program	3	programmed,programming,programmes	v,v,v
overlie	3	overlying,overlay,overlain	v,v,v
busy	3	busied,busiest,busier	v,a,a
prologue	3	prologing,prologed,prologs	v,v,v
colly	3	colliest,collier,collied	a,a,v
whiz	3	whizzing,whizzes,whizzed	v,v,v
caddie	3	caddies,caddied,caddying	v,v,v
caddy	3	caddies,caddied,caddying	v,v,v
ko	3	ko'ing,ko'd,ko's	v,v,v
swim	3	swimming,swam,swum	v,v,v
muddy	3	muddiest,muddier,muddied	a,a,v
bear	3	borne,born,bore	v,v,v
smite	3	smote,smitten,smit	v,v,v
lie	3	lying,lay,lain	v,v,v
get	3	gotten,got,getting	v,v,v
get started	3	got started,getting started,gets started	v,v,v
untidy	3	untidied,untidiest,untidier	v,a,a
os	3	ora,ossa,osar	n,n,n
bed	3	bedding,bedded,bed	v,v,v
steady	3	steadied,steadiest,steadier	v,a,a
bloody	3	bloodiest,bloodier,bloodied	a,a,v
giddy	3	giddiest,giddier,giddied	a,a,v
nonplus	3	nonplussing,nonplusses,nonplussed	v,v,v
empty	3	emptiest,emptier,emptied	a,a,v
hallah	3	halloth,hallot,challoth	n,n,n
gin	3	ginning,ginned,gan	v,v,v
sing	3	singing,sung,sang	v,v,v
dirty	3	dirtiest,dirtier,dirtied	a,a,v
pen	3	pent,penning,penned	v,v,v
sink	3	sunken,sunk,sank	v,v,v
cleave	3	cloven,cleft,clove	v,v,v
deepfreeze	3	deep-freezes,deep-freezed,deep-freeze	v,v,v
spit	3	spat,spitting,spitted	v,v,v
allow for	3	allowed for,allows for,allowing for	v,v,v
join battle	3	joins battle,joining battle,joined battle	v,v,v
think the world of	3	thought the world of,thinks the world of,thinking the world of	v,v,v
join forces	3	joining forces,joined forces,joins forces	v,v,v
begin	3	begun,began,beginning	v,v,v
grip	3	gript,gripping,gripped	v,v,v
degas	3	degassed,degassing,degasses	v,v,v
weary	3	wearied,weariest,wearier	v,a,a
bog down	3	bogging down,bogged down,bogs down	v,v,v
jolly	3	jolliest,jollier,jollied	a,a,v
cry	3	crying,cried,cryings	n,v,n
tallith	3	tallithes,tallaisim,tallitoth	n,n,n
transship	3	transshipped,tranship,transshipping	v,v,v
pretty	3	prettiest,prettier,prettied	a,a,v
shit	3	shat,shitting,shitted	v,v,v

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

morph	N	GROUP_CONCAT(lemma)	GROUP_CONCAT(pos)
better	3	good,well,well	a,r,a
comics	2	comic strip,comic	n,n
brants	2	brent,brant	n,n
halteres	2	haltere,halter	n,n
ploughmen	2	plowman,ploughman	n,n
entozoa	2	entozoon,entozoan	n,n
taxes	2	taxis,tax	n,n
offer	2	offer,off	a,a
epizoa	2	epizoon,epizoan	n,n
soles	2	sole,sol	n,n
plectra	2	plectrum,plectron	n,n
bases	2	basis,base	n,n
enthralling	2	enthrall,enthral	v,v
haggadas	2	haggadah,haggada	n,n
auspices	2	auspice,auspex	n,n
oesophagi	2	oesophagus,esophagus	n,n
leaves	2	leave,leaf	n,n
enthralled	2	enthrall,enthral	v,v
taeniae	2	tenia,taenia	n,n
fulfilling	2	fulfill,fulfil	v,v
distilling	2	distil,distill	v,v
axes	2	axis,ax	n,n
beadsmen	2	bedesman,beadsman	n,n
oedemata	2	oedema,edema	n,n
best	2	well,good	r,a
fulfilled	2	fulfil,fulfill	v,v
distilled	2	distill,distil	v,v
djinn	2	djinny,djinni	n,n
litai	2	litas,lit	n,n
assegais	2	assegai,assagai	n,n
singing	2	sing,singe	v,v
rabatos	2	rebato,rabato	n,n
appalling	2	appall,appal	v,v
mishnayoth	2	mishnah,mishna	n,n
enrolling	2	enroll,enrol	v,v
caddying	2	caddy,caddie	v,v
prothalamia	2	prothalamion,prothalamium	n,n
signori	2	signore,signior	n,n
overflown	2	overfly,overflow	v,v
morses	2	mors,morse	n,n
gasses	2	gas,gas	v,n
appalled	2	appall,appal	v,v
ichthyosauruses	2	ichthyosaurus,ichthyosaur	n,n
enrolled	2	enroll,enrol	v,v
quizzes	2	quiz,quiz	v,n
caddies	2	caddy,caddie	v,v
wahhabis	2	wahhabi,wahabi	n,n
masses	2	masse,mass	n,n
caddied	2	caddy,caddie	v,v
bacchantes	2	bacchante,bacchant	n,n
installing	2	install,instal	v,v
shofroth	2	shophar,shofar	n,n
monades	2	monas,monad	n,n
bicennaries	2	bicentennial,bicentenary	n,n
touracos	2	turaco,touraco	n,n
saguaros	2	sahuaro,saguaro	n,n
installed	2	install,instal	v,v
tyros	2	tyro,tiro	n,n
paraleipses	2	paralipsis,paraleipsis	n,n
feed	2	fee,feed	v,v

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

lemma	morph	GROUP_CONCAT(pos)	N
gas	gasses	v,n	2
well	better	r,a	2
quiz	quizzes	v,n	2