MYSQL

SELECT * FROM morphs WHERE morph = 'better'

morphid	morph
298	better

SELECT * FROM morphs LEFT JOIN lexes_morphs USING (morphid) LEFT JOIN words USING (wordid) WHERE word = 'good'

wordid	morphid	morph	luid	posid	word
60519	289	best	87168	a	good
60519	298	better	87168	a	good

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE word = 'chivy'

word	posid	morph
chivy	v	chevied
chivy	v	chevies
chivy	v	chevying
chivy	v	chivied
chivy	v	chivvied
chivy	v	chivvies
chivy	v	chivvying

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE word = 'quiz'

word	posid	morph
quiz	v	quizzed
quiz	n	quizzes
quiz	v	quizzes
quiz	v	quizzing

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE word = 'gas'

word	posid	morph
gas	n	gas
gas	v	gassed
gas	n	gasses
gas	v	gasses
gas	v	gassing

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE morph = 'better'

word	posid	morph
good	a	better
well	a	better
well	r	better

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE word = 'well'

word	posid	morph
well	r	best
well	a	better
well	r	better

SELECT word,posid,morph FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) WHERE word = 'be'

word	posid	morph
be	v	am
be	v	are
be	v	been
be	v	is
be	v	was
be	v	were

SELECT word,COUNT(morph) AS N,GROUP_CONCAT(morph) AS morphs,GROUP_CONCAT(posid) FROM morphs LEFT JOIN lexes_morphs USING (morphid) LEFT JOIN words USING (wordid) GROUP BY word HAVING N > 1 LIMIT 20

word	N	morphs	GROUP_CONCAT(posid)
abet	2	abetting,abetted	v,v
abhor	2	abhorring,abhorred	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
agora	2	agorae,agorae	n,n
airy	2	airier,airiest	a,a
allot	2	allotted,allotting	v,v
angry	2	angrier,angriest	a,a
annul	2	annulled,annulling	v,v
antheridium	2	andtheridia,antheridia	n,n
appal	2	appalled,appalling	v,v
appall	2	appalled,appalling	v,v
arc	2	arcking,arcked	v,v
argali	2	argali,araglis	n,n
arise	2	arisen,arose	v,v
arty	2	artiest,artier	a,a
ashy	2	ashier,ashiest	a,a

SELECT morph,COUNT(word) AS N,GROUP_CONCAT(word) AS lemmas,GROUP_CONCAT(posid) FROM morphs LEFT JOIN lexes_morphs USING (morphid) LEFT JOIN words USING (wordid) GROUP BY morph HAVING N > 1 LIMIT 20

morph	N	lemmas	GROUP_CONCAT(posid)
agorae	2	agora,agora	n,n
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
chelae	2	chela,chela	n,n
distilled	2	distil,distill	v,v
distilling	2	distil,distill	v,v
djinn	2	djinni,djinny	n,n

SELECT word,COUNT(wordid) AS N,GROUP_CONCAT(morph),GROUP_CONCAT(posid) FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY wordid HAVING N > 2 ORDER BY N DESC

word	N	GROUP_CONCAT(morph)	GROUP_CONCAT(posid)
chivy	7	chevied,chevies,chevying,chivied,chivvied,chivvies,chivvying	v,v,v,v,v,v,v
be	6	am,are,been,is,was,were	v,v,v,v,v,v
shy	5	shied,shier,shiest,shyer,shyest	v,a,a,a,a
dry	5	dried,drier,driest,dryer,dryest	v,a,a,a,a
gas	5	gas,gassed,gasses,gasses,gassing	n,v,n,v,v
trammel	5	trameled,trameling,tramelled,tramelling,tramels	v,v,v,v,v
swap	5	swapped,swapping,swopped,swopping,swops	v,v,v,v,v
fit	4	fitted,fitter,fittest,fitting	v,a,a,v
dim	4	dimmed,dimmer,dimmest,dimming	v,a,a,v
tan	4	tanned,tanner,tannest,tanning	v,a,a,v
dun	4	dunned,dunner,dunnest,dunning	v,a,a,v
fat	4	fatted,fatter,fattest,fatting	v,a,a,v
prim	4	primmed,primmer,primmest,primming	v,a,a,v
forbid	4	forbad,forbade,forbidden,forbidding	v,v,v,v
squat	4	squatted,squatter,squattest,squatting	v,a,a,v
sly	4	slier,sliest,slyer,slyest	a,a,a,a
real	4	reales,reales,reis,reis	n,n,n,n
quiz	4	quizzed,quizzes,quizzes,quizzing	v,n,v,v
thin	4	thinned,thinner,thinnest,thinning	v,a,a,v
tear	4	tore,tore,torn,torn	v,v,v,v
coordinate	4	co-ordinate,co-ordinated,co-ordinates,co-ordinating	v,v,v,v
wry	4	wrier,wriest,wryer,wryest	a,a,a,a
trim	4	trimmed,trimmer,trimmest,trimming	v,a,a,v
wan	4	wanned,wanner,wannest,wanning	v,a,a,v
wet	4	wetted,wetter,wettest,wetting	v,a,a,v
beget	4	begat,begetting,begot,begotten	v,v,v,v
man	3	manned,manning,men	v,v,n
program	3	programmed,programmes,programming	v,v,v
whiz	3	whizzed,whizzes,whizzing	v,v,v
shit	3	shat,shitted,shitting	v,v,v
shrink	3	shrank,shrunk,shrunken	v,v,v
sing	3	sang,singing,sung	v,v,v
sink	3	sank,sunk,sunken	v,v,v
smite	3	smit,smitten,smote	v,v,v
spit	3	spat,spitted,spitting	v,v,v
well	3	best,better,better	r,a,r
weary	3	wearied,wearier,weariest	v,a,a
steady	3	steadied,steadier,steadiest	v,a,a
underlie	3	underlain,underlay,underlying	v,v,v
transship	3	tranship,transshipped,transshipping	v,v,v
swim	3	swam,swimming,swum	v,v,v
tidy	3	tidied,tidier,tidiest	v,a,a
tallith	3	tallaisim,tallithes,tallitoth	n,n,n
empty	3	emptied,emptier,emptiest	v,a,a
bandy	3	bandied,bandier,bandiest	v,a,a
bear	3	bore,born,borne	v,v,v
bed	3	bed,bedded,bedding	v,v,v
begin	3	began,beginning,begun	v,v,v
bestride	3	bestrid,bestridden,bestrode	v,v,v
bid	3	bade,bidden,bidding	v,v,v
bloody	3	bloodied,bloodier,bloodiest	v,a,a
busy	3	busied,busier,busiest	v,a,a
caddie	3	caddied,caddies,caddying	v,v,v
caddy	3	caddied,caddies,caddying	v,v,v
cleave	3	cleft,clove,cloven	v,v,v
cry	3	cried,crying,cryings	v,n,n
degas	3	degassed,degasses,degassing	v,v,v
dirty	3	dirtied,dirtier,dirtiest	v,a,a
dizzy	3	dizzied,dizzier,dizziest	v,a,a
pen	3	penned,penning,pent	v,v,v
fancy	3	fancied,fancier,fanciest	v,a,a
forget	3	forgetting,forgot,forgotten	v,v,v
get	3	getting,got,gotten	v,v,v
gin	3	gan,ginned,ginning	v,v,v
go	3	goes,gone,went	n,v,v
grip	3	gripped,gripping,gript	v,v,v
hallah	3	challoth,hallot,halloth	n,n,n
jolly	3	jollied,jollier,jolliest	v,a,a
lie	3	lain,lay,lying	v,v,v
ban	3	bani,banned,banning	n,v,v
muddy	3	muddied,muddier,muddiest	v,a,a
nonplus	3	nonplussed,nonplusses,nonplussing	v,v,v
os	3	ora,osar,ossa	n,n,n
overlie	3	overlain,overlay,overlying	v,v,v

SELECT morph,COUNT(morphid) AS N ,GROUP_CONCAT(word),GROUP_CONCAT(posid) FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY morphid HAVING N > 1 ORDER BY N DESC

morph	N	GROUP_CONCAT(word)	GROUP_CONCAT(posid)
better	3	good,well,well	a,a,r
reales	2	real,real	n,n
installed	2	instal,install	v,v
installing	2	instal,install	v,v
leaves	2	leaf,leave	n,n
litai	2	lit,litas	n,n
masses	2	mass,masse	n,n
monades	2	monad,monas	n,n
oedemata	2	edema,oedema	n,n
oesophagi	2	esophagus,oesophagus	n,n
overflown	2	overflow,overfly	v,v
paraleipses	2	paraleipsis,paralipsis	n,n
plectra	2	plectron,plectrum	n,n
ploughmen	2	ploughman,plowman	n,n
prothalamia	2	prothalamion,prothalamium	n,n
quizzes	2	quiz,quiz	n,v
rabatos	2	rabato,rebato	n,n
halteres	2	halter,haltere	n,n
reis	2	real,real	n,n
saguaros	2	saguaro,sahuaro	n,n
shofroth	2	shofar,shophar	n,n
signori	2	signior,signore	n,n
singing	2	sing,singe	v,v
soles	2	sol,sole	n,n
taeniae	2	taenia,tenia	n,n
taxes	2	tax,taxis	n,n
tore	2	tear,tear	v,v
torn	2	tear,tear	v,v
touracos	2	touraco,turaco	n,n
tyros	2	tiro,tyro	n,n
wound	2	wind,wind	v,v
chelae	2	chela,chela	n,n
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
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
ichthyosauruses	2	ichthyosaur,ichthyosaurus	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
enrolling	2	enrol,enroll	v,v
enthralled	2	enthral,enthrall	v,v
enthralling	2	enthral,enthrall	v,v
entozoa	2	entozoan,entozoon	n,n
epizoa	2	epizoan,epizoon	n,n
feed	2	fee,feed	v,v
fulfilled	2	fulfil,fulfill	v,v
fulfilling	2	fulfil,fulfill	v,v
gasses	2	gas,gas	n,v
agorae	2	agora,agora	n,n

SELECT word,morph,GROUP_CONCAT(posid),COUNT(*) AS N FROM lexes_morphs INNER JOIN words USING (wordid) INNER JOIN morphs USING (morphid) GROUP BY wordid,morphid HAVING N > 1 ORDER BY N DESC

word	morph	GROUP_CONCAT(posid)	N
agora	agorae	n,n	2
chela	chelae	n,n	2
gas	gasses	n,v	2
quiz	quizzes	n,v	2
real	reales	n,n	2
real	reis	n,n	2
tear	tore	v,v	2
tear	torn	v,v	2
well	better	a,r	2
wind	wound	v,v	2