Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pygmy” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

311 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
pygmy	16	33	422	(None)
pigmy	13	29	943	1	pigmy
palmy	12	60	1673	2	palmy
piggy	12	40	1143	2	piggy
plumy	12	42	1323	2	plumy
pogey	11	60	1789	2	pogey
pogy	10	56	2355	2	pog_y
pommy	14	44	986	2	pommy
puggy	12	46	1232	2	puggy
agly	8	68	2180	3	_agly
agma	7	76	2326	3	_agma
angry	9	3	1086	3	angry
anomy	10	51	1339	3	anomy
apogamy	15	4	362	3	apogamy
army	9	66	2418	3	_army
atomy	10	74	1519	3	atomy
baggy	12	56	1568	3	baggy
balmy	12	52	1747	3	balmy
barmy	12	52	1876	3	barmy
beamy	12	62	1857	3	beamy
bigamy	14	3	634	3	bigamy
biggy	12	44	1313	3	biggy
bigly	11	48	1475	3	bigly
blimy	12	52	1282	3	blimy
bogey	11	52	2023	3	bogey
boggy	12	61	1607	3	boggy
bogy	10	64	2619	3	bog_y
boomy	12	54	2182	3	boomy
buggy	12	46	1348	3	buggy
byway	16	4	753	3	byway
cagey	11	59	1782	3	cagey
cagy	10	63	2199	3	cag_y
commy	14	47	1264	3	commy
cyma	11	67	1584	3	cy_ma
cyme	11	94	2037	3	cy_me
demy	10	54	2285	3	_demy
digamy	13	3	589	3	digamy
dogey	10	57	1951	3	dogey
doggy	11	52	1487	3	doggy
dogma	9	61	1246	3	dogma
dogy	9	61	2649	3	dog_y
doomy	11	60	1826	3	doomy
dormy	11	58	1747	3	dormy
dummy	13	47	1278	3	dummy
dykey	16	60	867	3	dykey
edgy	9	47	1353	3	edg_y
eggy	9	66	1185	3	_eggy
elmy	9	56	1679	3	_elmy
emmy	11	60	1324	3	_emmy
enemy	10	5	999	3	enemy
eyry	10	63	1588	3	ey_ry
faggy	13	65	1437	3	faggy
filmy	13	61	1404	3	filmy
flamy	13	52	1747	3	flamy
foamy	13	53	1320	3	foamy
fogey	12	56	1787	3	fogey
foggy	13	67	1454	3	foggy
fogy	11	59	2318	3	fog_y
fuggy	13	54	1167	3	fuggy
fumy	12	71	1858	3	_fumy
gammy	13	55	1489	3	gammy
gamy	10	54	2753	3	_gamy
gay	7	68	5649	3	__gay
gemmy	13	52	1105	3	gemmy
germy	11	51	1366	3	germy
gey	7	57	3830	3	__gey
goy	7	78	4455	3	__goy
grimy	11	43	1260	3	grimy
gummy	13	54	1365	3	gummy
guy	7	57	2894	3	__guy
gym	9	57	1906	3	gy_m_
gyms	10	75	1459	3	gy_ms
gypsy	14	63	699	3	gypsy
hammy	15	51	1343	3	hammy
homy	12	66	2322	3	_homy
hymn	12	3	1131	3	hy_mn
immy	11	46	1183	3	_immy
jaggy	17	59	1314	3	jaggy
jammy	19	48	1019	3	jammy
jemmy	19	49	855	3	jemmy
jiggy	17	54	914	3	jiggy
jimmy	19	53	850	3	jimmy
leggy	10	52	1024	3	leggy
limy	9	57	2771	3	_limy
loamy	10	59	1334	3	loamy
loggy	10	57	1419	3	loggy
logy	8	70	2578	3	log_y
magma	10	45	1357	3	magma
malmy	12	48	1634	3	malmy
mammy	11	52	1516	3	mammy
moggy	12	52	1216	3	moggy
mommy	11	40	1075	3	mommy
muggy	12	56	1237	3	muggy
mummy	11	49	1362	3	mummy
my	7	81	2565	3	___my
myoma	12	3	927	3	myoma
myopy	15	45	735	3	myopy
mythy	16	56	867	3	mythy
naggy	10	66	1282	3	naggy
oogamy	12	3	563	3	oogamy
orgy	8	52	1800	3	org_y
pacey	12	67	2028	3	pacey
pacy	11	53	2868	3	p_acy
paddy	12	59	1359	3	paddy
pagan	8	61	2116	3	pagan
page	7	60	3610	3	pag_e
paged	9	59	2678	3	paged
pager	8	47	2820	3	pager
pages	8	52	3507	3	pages
pagod	9	50	1368	3	pagod
pally	10	57	2712	3	pally
palm	8	53	3136	3	palm_
palms	9	49	2175	3	palms
palsy	10	54	1746	3	palsy
paly	9	58	3553	3	p_aly
pam	7	78	5839	3	p_am_
pams	8	56	4176	3	p_ams
pandy	11	50	2117	3	pandy
pansy	10	57	1797	3	pansy
panty	10	59	2930	3	panty
pappy	11	47	1380	3	pappy
pardy	11	55	2395	3	pardy
parry	10	53	2375	3	parry
party	10	66	3061	3	party
pasty	10	57	2505	3	pasty
patly	10	50	2058	3	patly
patsy	10	57	1720	3	patsy
patty	10	47	2361	3	patty
paty	9	52	3456	3	p_aty
pawky	17	38	1015	3	pawky
pay	8	84	6118	3	p__ay
payday	15	3	661	3	payday
peaky	14	57	1815	3	peaky
peaty	10	57	2569	3	peaty
peavy	13	50	1484	3	peavy
pecky	16	55	1509	3	pecky
peery	10	57	1944	3	peery
peg	6	58	4306	3	peg__
pegs	7	55	3176	3	peg_s
penny	10	51	1945	3	penny
peony	10	57	1756	3	peony
peppy	11	43	1036	3	peppy
perdy	11	54	1733	3	perdy
perky	14	53	1948	3	perky
perm	8	58	3463	3	perm_
perms	9	55	2451	3	perms
perry	10	52	2271	3	perry
pesky	14	59	1156	3	pesky
pesty	10	64	2171	3	pesty
petty	10	53	2029	3	petty
phlegmy	18	4	150	3	phlegmy
phony	13	67	1544	3	phony
picky	16	54	1694	3	picky
piety	10	58	1730	3	piety
pig	6	57	4497	3	pig__
pigs	7	66	3422	3	pig_s
pigsty	12	3	593	3	pigsty
pily	9	61	3273	3	p_ily
pima	8	54	2865	3	p_ima
pimp	10	60	2490	3	p_imp
piney	10	57	2750	3	piney
pinky	14	58	2340	3	pinky
pinny	10	52	2206	3	pinny
piny	9	118	3835	3	p_iny
pipy	11	54	2151	3	p_ipy
pithy	13	56	1446	3	pithy
pity	9	60	3193	3	p_ity
pixy	16	61	1776	3	p_ixy
plaguy	12	38	641	3	plaguy
platy	10	50	2166	3	platy
play	9	59	2898	3	p_lay
ploy	9	61	2360	3	p_loy
plum	8	51	2210	3	plum_
plumb	11	45	1407	3	plumb
plume	9	48	1946	3	plume
plummy	15	37	566	3	plummy
plump	11	53	1526	3	plump
plums	9	46	1995	3	plums
ply	8	63	2355	3	p__ly
poboy	12	16	1222	3	poboy
pocky	16	53	1460	3	pocky
podgy	12	56	1077	3	podgy
poem	8	62	2577	3	poem_
poems	9	57	1555	3	poems
poesy	10	50	1406	3	poesy
pogeys	12	41	1035	3	pogeys
pokey	14	53	1897	3	pokey
poky	13	59	2215	3	p_oky
poly	9	62	3515	3	p_oly
polygamy	19	4	407	3	polygamy
pom	7	82	4991	3	p_om_
pome	8	56	3669	3	p_ome
pomo	8	58	2845	3	p_omo
pomp	10	62	2546	3	p_omp
poms	8	70	3774	3	p_oms
pony	9	64	3405	3	p_ony
poofy	13	62	1327	3	poofy
poppy	11	48	1319	3	poppy
popsy	12	57	1340	3	popsy
porgy	11	69	1612	3	porgy
porky	14	50	1933	3	porky
porny	10	60	2019	3	porny
posy	9	60	2842	3	p_osy
potsy	10	58	1561	3	potsy
potty	10	56	2100	3	potty
pouty	10	70	1881	3	pouty
poxy	16	68	2089	3	p_oxy
pram	8	57	3349	3	pram_
prams	9	61	2551	3	prams
pray	9	63	3153	3	p_ray
prexy	17	46	1158	3	prexy
prey	9	62	2848	3	p_rey
pricy	12	48	1456	3	pricy
prim	8	51	3220	3	prim_
prima	9	50	1934	3	prima
prime	9	65	2560	3	prime
primi	9	50	1740	3	primi
primly	13	43	962	3	primly
primo	9	50	1791	3	primo
primp	11	56	1592	3	primp
prims	9	54	2593	3	prims
privy	13	43	983	3	privy
prom	8	76	3170	3	prom_
promo	9	56	2000	3	promo
proms	9	54	2641	3	proms
prosy	10	63	1925	3	prosy
proxy	17	50	1101	3	proxy
pry	8	57	2805	3	p__ry
pudgy	12	49	1116	3	pudgy
puffy	16	44	1075	3	puffy
pug	6	53	3718	3	pug__
puggry	13	37	482	3	puggry
pugh	10	66	1923	3	pug_h
pugs	7	63	3277	3	pug_s
pulpy	12	46	1236	3	pulpy
puma	8	54	2412	3	p_uma
pump	10	57	2685	3	p_ump
punky	14	44	1939	3	punky
punny	10	42	1771	3	punny
punty	10	60	2161	3	punty
puny	9	55	2699	3	p_uny
puppy	11	49	1241	3	puppy
pursy	10	50	1641	3	pursy
purty	10	50	1940	3	purty
pushy	13	46	1435	3	pushy
pussy	10	56	1484	3	pussy
putty	10	47	2140	3	putty
pya	8	70	2375	3	py__a
pyas	9	62	2570	3	py_as
pye	8	64	3250	3	py__e
pyemia	13	3	755	3	pyemia
pyemic	15	3	789	3	pyemic
pyes	9	55	2899	3	py_es
pygmean	15	4	222	3	pygmean
pygmies	15	20	567	3	pygmies
pygmoid	16	4	453	3	pygmoid
pygmyish	22	4	134	3	pygmy~~ish~~
pygmyism	21	4	181	3	pygmy~~ism~~
pyic	11	69	1582	3	py_ic
pyin	9	68	2323	3	py_in
pyins	10	58	1586	3	pyins
pyjama	20	30	348	3	pyjama
pylon	10	36	1400	3	pylon
pyoid	11	5	1376	3	pyoid
pyran	10	5	1447	3	pyran
pyre	9	49	2555	3	py_re
pyres	10	55	2388	3	pyres
pyrex	17	52	1121	3	pyrex
pyric	12	38	1507	3	pyric
pyro	9	60	1939	3	py_ro
pyros	10	57	1829	3	pyros
pyx	15	78	1701	3	py__x
pyxes	17	59	1140	3	pyxes
pyxie	17	35	936	3	pyxie
pyxis	17	45	863	3	pyxis
raggy	10	61	1657	3	raggy
rammy	12	43	1249	3	rammy
regma	8	46	1233	3	regma
rimy	9	66	2128	3	_rimy
roomy	10	71	1806	3	roomy
rugby	11	44	813	3	rugby
rummy	12	42	1241	3	rummy
saggy	10	59	1746	3	saggy
sagy	8	53	2708	3	sag_y
seamy	10	59	2127	3	seamy
sigma	8	45	1383	3	sigma
slimy	10	54	1742	3	slimy
soggy	10	54	1390	3	soggy
spumy	12	46	1036	3	spumy
stimy	10	51	1474	3	stimy
stymy	13	35	829	3	stymy
swamy	13	67	1440	3	swamy
syngamy	16	4	311	3	syngamy
tammy	12	40	1322	3	tammy
thymy	16	43	792	3	thymy
tommy	12	47	1223	3	tommy
tummy	12	47	1199	3	tummy
typey	13	55	1188	3	typey
typy	12	60	1304	3	ty_py
ugly	8	60	1238	3	_ugly
vuggy	13	58	948	3	vuggy
wiggy	13	45	1073	3	wiggy
wormy	13	75	1425	3	wormy
yam	8	74	4899	3	_yam_
yams	9	53	3073	3	_yams
yay	9	69	4871	3	_y_ay
yom	8	80	4344	3	_yom_
yum	8	61	3282	3	_yum_
yummy	15	42	915	3	yummy
zygoma	21	4	349	3	zygoma
zyme	18	191	1494	3	zy_me

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	83667	0.356	501941.0
2	DLD Change Limit	83667	311	3.393	24658.7
3	Display Results	311	311	0.090	3455.6
	(SQL Overall)	178691	311	3.839	46546.2