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

Here are the results of your fuzzy-string dictionary search for “grumpy” 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.

331 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
grumpy	14	49	815	(None)
frumpy	16	46	688	1	frumpy
glumpy	14	52	719	1	glumpy
grump	10	51	1531	1	grump_
grumphy	18	44	362	1	grumphy
grumps	11	45	1057	1	grumps
brumby	15	38	595	2	brumby
bumpy	14	47	1505	2	_bumpy
clumpy	15	40	957	2	clumpy
crampy	15	47	1099	2	crampy
crimpy	15	48	939	2	crimpy
crumby	15	40	811	2	crumby
crummy	15	36	589	2	crummy
crump	11	56	1642	2	crump_
crumply	16	33	609	2	crumply
crumps	12	45	1434	2	crumps
drumly	12	3	570	2	drumly
dumpy	13	54	1475	2	_dumpy
frump	12	69	1256	2	frump_
frumps	13	47	978	2	frumps
gimpy	13	52	1223	2	g_impy
glumly	12	35	662	2	glumly
gramp	10	62	1832	2	gramp_
grampa	11	50	1017	2	grampa
gramps	11	41	1427	2	gramps
grapy	11	54	1643	2	gr_apy
gremmy	14	5	447	2	gremmy
grimly	12	45	993	2	grimly
grimy	11	43	1260	2	grim_y
grippy	14	44	776	2	grippy
gripy	11	51	1525	2	gr_ipy
grubby	14	32	450	2	grubby
gruffy	16	39	601	2	gruffy
grum	7	56	2508	2	grum__
grumbly	15	35	540	2	grumbly
grume	8	62	1816	2	grum_e
grumes	9	44	1555	2	grumes
grumped	13	33	733	2	grumped
grumpily	16	4	346	2	grumpily
grungy	11	34	597	2	grungy
gulpy	11	46	1276	2	g_ulpy
gummy	13	54	1365	2	g_ummy
guppy	13	52	1127	2	g_uppy
humpy	15	51	1567	2	_humpy
jumpy	19	57	1281	2	_jumpy
lumpy	12	66	1591	2	_lumpy
rummy	12	42	1241	2	_rummy
rump	8	67	2908	2	_rump_
rumply	13	34	857	2	_rumply
rumps	9	59	2229	2	_rumps
stumpy	13	45	813	2	stumpy
trampy	13	49	925	2	trampy
trump	9	56	1512	2	trump_
trumps	10	46	1188	2	trumps
army	9	66	2418	3	ar_m_y
arum	6	61	2903	3	arum__
arums	7	55	1783	3	arum_s
brumal	10	4	950	3	brumal
brume	9	58	1798	3	brum_e
brumes	10	64	1707	3	brumes
brushy	14	46	826	3	brushy
bump	10	62	2824	3	_bump_
bumph	14	49	1198	3	_bumph
bumps	11	59	2114	3	_bumps
buppy	14	48	1007	3	_buppy
campy	14	51	1618	3	_campy
champy	18	50	961	3	champy
chummy	18	38	589	3	chummy
chump	14	53	1544	3	chump_
chumps	15	43	1382	3	chumps
clump	11	55	1745	3	clump_
clumps	12	153	1464	3	clumps
clumsy	13	32	619	3	clumsy
cramp	11	51	2069	3	cramp_
cramps	12	56	1556	3	cramps
crappy	15	44	680	3	crappy
creepy	13	41	880	3	creepy
crepy	12	48	1270	3	cr_epy
crimp	11	56	1580	3	crimp_
crimps	12	46	1345	3	crimps
crispy	13	47	856	3	crispy
croupy	13	45	873	3	croupy
cruddy	13	3	419	3	cruddy
crumb	11	43	1359	3	crum_b
crumbly	16	34	752	3	crumbly
crumbs	12	40	923	3	crumbs
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crumple	13	36	836	3	crumple
crusty	11	49	1134	3	crusty
cuppy	14	47	1038	3	_cuppy
drippy	14	44	565	3	drippy
droopy	12	45	824	3	droopy
druggy	12	34	474	3	druggy
drum	7	65	2159	3	drum__
drums	8	54	1587	3	drum_s
drupe	8	50	1299	3	dru_pe
dumky	15	45	1134	3	_dumky
dummy	13	47	1278	3	_dummy
dump	9	59	2709	3	_dump_
dumps	10	52	2010	3	_dumps
erupt	7	42	2006	3	eru_pt
flump	12	46	1472	3	flump_
flumps	13	51	1250	3	flumps
fruity	12	42	969	3	fruity
frumpily	18	4	332	3	frumpily
fumy	12	71	1858	3	_fum_y
galumph	15	10	266	3	galumph
gamay	11	64	1910	3	g_amay
gamey	11	53	2055	3	g_amey
gammy	13	55	1489	3	g_ammy
gamp	9	88	3321	3	g_amp_
gamps	10	53	2371	3	g_amps
gamy	10	54	2753	3	g_am_y
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g__apy
gaudy	10	66	1146	3	gau_dy
gaum	7	57	2642	3	gaum__
gaumed	10	46	1032	3	gaumed
gaums	8	62	1707	3	gaum_s
gauzy	18	48	921	3	gau_zy
gazump	20	3	245	3	gazump_
gazumps	21	3	187	3	gazumps
gemmy	13	52	1105	3	g_emmy
germy	11	51	1366	3	germ_y
geum	7	54	2455	3	geum__
geums	8	54	1411	3	geum_s
gimp	9	61	2404	3	g_imp_
gimps	10	59	1520	3	g_imps
gloppy	14	5	472	3	gloppy
gluey	9	57	1526	3	glu_ey
gluily	10	30	829	3	gluily
glum	7	58	2510	3	glum__
glume	8	51	2046	3	glum_e
glumes	9	45	1681	3	glumes
glumpily	16	4	359	3	glumpily
glums	8	46	2142	3	glum_s
goopy	11	58	1662	3	g_oopy
gouty	9	52	1736	3	gou_ty
grabby	14	33	618	3	grabby
grainy	10	39	1421	3	grainy
gram	7	70	3458	3	gram__
grama	8	56	2028	3	gram_a
gramary	13	5	590	3	gramary
gramas	9	43	1720	3	gramas
gramma	11	49	980	3	gramma
gramme	11	42	1033	3	gramme
grampas	12	39	925	3	grampas
grampus	12	35	631	3	grampus
grams	8	53	2731	3	gram_s
granny	10	43	1116	3	granny
grape	8	48	2466	3	gr_ape
grapey	12	60	1230	3	grapey
graph	11	53	1561	3	gr_aph
grappa	11	39	644	3	grappa
grasp	8	48	1448	3	grasp_
grasps	9	48	925	3	grasps
grassy	10	61	909	3	grassy
gravy	12	55	1211	3	gr_avy
gray	8	53	2989	3	gr__ay
grayly	13	28	796	3	grayly
greasy	10	41	946	3	greasy
greedy	11	51	884	3	greedy
greeny	10	48	1145	3	greeny
grey	8	56	2404	3	gr__ey
greyly	13	31	654	3	greyly
grim	7	69	2942	3	grim__
grime	8	50	2132	3	grim_e
grimed	10	47	1409	3	grimed
grimes	9	46	1903	3	grimes
grimily	13	3	652	3	grimily
grip	7	61	2702	3	gr_ip_
gripe	8	46	2296	3	gr_ipe
gripey	12	41	1120	3	gripey
grippe	11	53	1032	3	grippe
grips	8	55	2013	3	gr_ips
gript	8	51	2617	3	gr_ipt
grisly	10	43	1058	3	grisly
gritty	10	33	840	3	gritty
grody	10	34	1206	3	gr_ody
groggy	12	3	480	3	groggy
groovy	13	37	540	3	groovy
grope	8	48	2161	3	gr_ope
groszy	19	39	570	3	groszy
grotty	10	38	983	3	grotty
grouchy	16	29	424	3	grouchy
group	8	54	1392	3	group_
groups	9	42	1051	3	groups
grouty	10	47	1098	3	grouty
growly	13	49	917	3	growly
grub	7	72	2008	3	gru__b
grubs	8	63	1260	3	gru_bs
grudge	9	38	858	3	grudge
grue	5	58	2571	3	gru__e
gruel	6	60	1474	3	gru_el
gruels	7	39	1015	3	gruels
grues	6	57	2196	3	gru_es
gruff	12	47	1214	3	gru_ff
gruffly	17	41	389	3	gruffly
gruffs	13	33	745	3	gruffs
grugru	8	4	293	3	grugru
grumble	12	34	923	3	grumble
grummer	12	33	878	3	grummer
grummet	12	29	887	3	grummet
grumose	10	3	572	3	grumose
grumous	10	8	660	3	grumous
grumphie	16	4	276	3	grumphie
grumpier	13	3	480	3	grumpier
grumping	14	26	690	3	grumping
grumpish	16	4	376	3	grumpish
grunge	8	35	958	3	grunge
grunt	6	55	2354	3	gru_nt
grunts	7	55	1185	3	grunts
grutch	12	28	556	3	grutch
guimpe	11	3	472	3	guimpe
gulfy	12	46	1200	3	g_ulfy
gully	9	40	2068	3	g_ully
gulp	7	55	2136	3	g_ulp_
gulps	8	47	1507	3	g_ulps
gum	6	74	3953	3	g_um__
gumbo	10	44	1358	3	g_umbo
gumma	10	53	1310	3	g_umma
gums	7	50	3094	3	g_um_s
gunky	13	55	1411	3	g_unky
gunny	9	44	1366	3	g_unny
gurney	10	42	941	3	gurney
gurry	9	45	1541	3	g_urry
gushy	12	52	1312	3	g_ushy
gussy	9	53	1432	3	g_ussy
gusty	9	51	1957	3	g_usty
gutsy	9	64	1284	3	g_utsy
gutty	9	45	1699	3	g_utty
guy	7	57	2894	3	g_u__y
harumph	17	4	293	3	harumph
hempy	15	49	1276	3	_hempy
hump	11	62	2872	3	_hump_
humph	15	57	1221	3	_humph
humps	12	63	2280	3	_humps
jimpy	19	52	1082	3	_jimpy
jump	15	66	2172	3	_jump_
jumps	16	51	1649	3	_jumps
lump	8	65	3170	3	_lump_
lumps	9	56	2498	3	_lumps
mummy	11	49	1362	3	_mummy
mump	10	54	2572	3	_mump_
mumps	11	56	1910	3	_mumps
plummy	15	37	566	3	plummy
plump	11	53	1526	3	plump_
plumply	16	3	422	3	plumply
plumps	12	46	1261	3	plumps
plumy	12	42	1323	3	plum_y
preppy	12	3	552	3	preppy
primly	13	43	962	3	primly
primp	11	56	1592	3	primp_
primps	12	47	1182	3	primps
prompt	12	3	1301	3	prompt
pulpy	12	46	1236	3	_pulpy
pump	10	57	2685	3	_pump_
pumps	11	55	2060	3	_pumps
puppy	11	49	1241	3	_puppy
rammy	12	43	1249	3	_rammy
ramp	8	59	3400	3	_ramp_
ramps	9	62	2463	3	_ramps
raspy	10	65	1170	3	_raspy
rimy	9	66	2128	3	_rim_y
romp	8	59	2657	3	_romp_
romps	9	46	1754	3	_romps
ropy	9	63	2341	3	_r_opy
roupy	10	61	1271	3	_roupy
rubby	12	44	1385	3	_rubby
ruby	9	78	1994	3	_ru_by
ruddy	10	45	1175	3	_ruddy
rugby	11	44	813	3	_rugby
ruly	7	63	2314	3	_ru_ly
rum	5	66	4464	3	_rum__
rumba	9	36	1251	3	_rumba
rumbly	13	44	1216	3	_rumbly
rumen	7	44	1950	3	_rumen
rumor	7	10	1132	3	_rumor
rumple	10	39	1301	3	_rumple
rumpus	10	45	889	3	_rumpus
rums	6	48	3347	3	_rum_s
runny	8	46	1348	3	_runny
runty	8	61	1904	3	_runty
rushy	11	54	1481	3	_rushy
rusty	8	52	2105	3	_rusty
rutty	8	56	1780	3	_rutty
scrimpy	16	48	613	3	scrimpy
scummy	15	26	522	3	scummy
shlumpy	17	4	286	3	shlumpy
shrimpy	17	41	540	3	shrimpy
sirupy	11	37	705	3	siru_py
skimpy	17	47	572	3	skimpy
slummy	13	32	586	3	slummy
slump	9	48	1663	3	slump_
slumps	10	43	1358	3	slumps
soupy	10	61	1540	3	sou_py
spumy	12	46	1036	3	spum_y
stump	9	46	1646	3	stump_
stumps	10	49	1228	3	stumps
sump	8	63	3153	3	_sump_
sumps	9	50	2343	3	_sumps
swampy	16	43	723	3	swampy
syrupy	14	28	582	3	syru_py
thrummy	17	4	217	3	thrummy
thump	12	62	1157	3	thump_
thumps	13	44	935	3	thumps
tramp	9	63	1977	3	tramp_
tramps	10	51	1445	3	tramps
trimly	11	44	1089	3	trimly
trippy	13	45	780	3	trippy
triumph	14	5	333	3	triumph
tromp	9	58	1580	3	tromp_
trompe	10	56	1126	3	trompe
tromps	10	49	1170	3	tromps
truly	8	41	1155	3	tru_ly
trumped	12	43	971	3	trumped
trumpery	15	3	361	3	trumpery
trumpet	11	38	1072	3	trumpet
trusty	9	47	1011	3	trusty
tummy	12	47	1199	3	_tummy
tump	8	59	2703	3	_tump_
tumps	9	54	2079	3	_tumps
ump	7	61	3044	3	__ump_
umps	8	57	2194	3	__umps
vampy	15	53	940	3	_vampy
whump	15	49	1004	3	whump_
whumps	16	42	709	3	whumps
wimpy	15	59	1192	3	_wimpy
yummy	15	42	915	3	_yummy
yuppy	15	48	791	3	_yuppy

Search took 7 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	112716	0.156	1145455.1
2	DLD Change Limit	112716	331	6.080	18538.8
3	Display Results	331	331	0.093	3559.1
	(SQL Overall)	178691	331	6.329	28233.7