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

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

321 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
crumby	15	40	811	(None)
brumby	15	38	595	1	brumby
crumb	11	43	1359	1	crumb_
crumbly	16	34	752	1	crumbly
crumbs	12	40	923	1	crumbs
crummy	15	36	589	1	crummy
chubby	18	4	412	2	chubby
chummy	18	38	589	2	chummy
clubby	15	3	468	2	clubby
clumpy	15	40	957	2	clumpy
clumsy	13	32	619	2	clumsy
crabby	15	34	675	2	crabby
crambe	12	3	907	2	crambe
crambo	12	3	804	2	crambo
crampy	15	47	1099	2	crampy
crimpy	15	48	939	2	crimpy
cruddy	13	3	419	2	cruddy
crumbed	14	37	847	2	crumbed
crumber	13	33	964	2	crumber
crumble	13	34	1040	2	crumble
crumbum	15	4	374	2	crumbum
crump	11	56	1642	2	crum_p
crumply	16	33	609	2	crumply
crumps	12	45	1434	2	crumps
crusty	11	49	1134	2	crusty
cubby	14	52	1212	2	c_ubby
drumly	12	3	570	2	drumly
frumpy	16	46	688	2	frumpy
grubby	14	32	450	2	grubby
grumbly	15	35	540	2	grumbly
grumpy	14	49	815	2	grumpy
rubby	12	44	1386	2	_rubby
ruby	9	78	1994	2	_ru_by
rugby	11	44	813	2	_rugby
rumba	9	36	1251	2	_rumba
rumbly	13	44	1216	2	_rumbly
rummy	12	42	1241	2	_rummy
scrubby	16	4	280	2	scrubby
army	9	66	2418	3	ar_m_y
arum	6	61	2903	3	arum__
arums	7	55	1783	3	arum_s
brambly	16	29	625	3	brambly
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
bubby	11	50	1393	3	_bubby
bumpy	14	47	1505	3	_bumpy
busby	12	61	1329	3	_busby
cabby	14	53	1456	3	c_abby
calmly	13	3	761	3	calmly
calumny	14	4	386	3	calumny
campy	14	51	1618	3	c_ampy
caramba	13	3	689	3	caramba
causey	11	35	1327	3	causey
cerumen	11	4	776	3	cerumen
chammy	18	48	895	3	chammy
champy	18	50	961	3	champy
chimb	14	48	1356	3	chimb_
chimbly	19	7	459	3	chimbly
chimbs	15	39	1030	3	chimbs
chromy	16	30	990	3	chrom_y
chub	11	55	1641	3	chu_b_
chubs	12	54	1262	3	chu_bs
chucky	20	41	800	3	chucky
chuffy	20	44	586	3	chuffy
chum	11	63	1800	3	chum__
chump	14	53	1544	3	chum_p
chumps	15	43	1382	3	chumps
chums	12	50	1583	3	chum_s
chunky	18	46	827	3	chunky
clammy	15	35	633	3	clammy
climb	11	54	1359	3	climb_
climbs	12	49	872	3	climbs
clomb	11	57	1470	3	clomb_
club	8	58	1947	3	clu_b_
clubs	9	54	1510	3	clu_bs
clumber	13	40	1144	3	clumber
clump	11	55	1745	3	clum_p
clumps	12	153	1464	3	clumps
clunky	15	44	789	3	clunky
cobby	14	55	1641	3	c_obby
colby	12	44	1506	3	c_olby
comb	10	66	3211	3	c_omb_
combe	11	62	2354	3	c_ombe
combo	11	45	1943	3	c_ombo
combs	11	61	2296	3	c_ombs
comfy	15	37	1021	3	c_omfy
commy	14	47	1264	3	c_ommy
coomb	11	56	1570	3	coomb_
coombe	12	41	1009	3	coombe
coombs	12	42	1019	3	coombs
corby	12	50	1853	3	c_orby
corymb	15	3	522	3	corymb_
corymbs	16	3	345	3	corymbs
county	11	43	1332	3	county
crab	8	57	2767	3	cr_ab_
crabs	9	54	2139	3	cr_abs
cracky	17	50	1022	3	cracky
crafty	14	47	891	3	crafty
craggy	13	39	660	3	craggy
cram	8	56	3549	3	cram__
crambes	13	3	996	3	crambes
crambos	13	3	678	3	crambos
cramp	11	51	2069	3	cram_p
cramps	12	56	1556	3	cramps
crams	9	62	2915	3	cram_s
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
crappy	15	44	680	3	crappy
crawly	14	46	1076	3	crawly
crazy	19	55	1122	3	cr_azy
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
creepy	13	41	880	3	creepy
creme	9	43	1932	3	crem_e
cremes	10	45	1799	3	cremes
crepey	13	51	1093	3	crepey
crepy	12	48	1270	3	cr_epy
cressy	11	43	911	3	cressy
crib	8	63	2358	3	cr_ib_
cribs	9	45	1675	3	cr_ibs
crikey	15	31	778	3	crikey
crime	9	48	2269	3	crim_e
crimes	10	55	2158	3	crimes
criminy	14	26	845	3	criminy
crimp	11	56	1580	3	crim_p
crimps	12	46	1345	3	crimps
crispy	13	47	856	3	crispy
croaky	15	52	848	3	croaky
crony	10	59	1867	3	cr_ony
croupy	13	45	873	3	croupy
crowdy	15	46	717	3	crowdy
cru	5	71	2956	3	cru___
cruces	10	51	1754	3	cruces
crucify	17	4	406	3	crucify
cruck	13	56	1532	3	cru_ck
crucks	14	44	1258	3	crucks
crud	7	52	1961	3	cru__d
crude	8	60	1857	3	cru_de
crudely	13	3	627	3	crudely
cruder	9	56	1238	3	cruder
crudes	9	62	1862	3	crudes
crudity	13	3	604	3	crudity
cruds	8	58	1585	3	cru_ds
cruel	7	48	1590	3	cru_el
cruelly	12	3	656	3	cruelly
cruelty	12	3	411	3	cruelty
cruet	7	48	3184	3	cru_et
cruets	8	53	1495	3	cruets
cruise	8	43	1404	3	cruise
crumbers	14	33	824	3	crumbers
crumbier	14	5	636	3	crumbier
crumbing	15	26	781	3	crumbing
crumbled	15	35	744	3	crumbled
crumbles	14	32	968	3	crumbles
crumbums	16	4	273	3	crumbums
crummie	13	3	615	3	crummie
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crumple	13	36	836	3	crumple
crunch	13	34	950	3	crunch
crunchy	17	32	476	3	crunchy
cruor	7	3	1045	3	cru_or
cruors	8	3	864	3	cruors
crura	7	3	1258	3	cru_ra
crural	8	6	1063	3	crural
crus	6	58	2848	3	cru__s
cruse	7	57	2610	3	cru_se
cruses	8	81	2771	3	cruses
cruset	8	44	2509	3	cruset
crush	10	68	1599	3	cru_sh
crusily	12	19	909	3	crusily
crust	7	58	2766	3	cru_st
crusts	8	49	1654	3	crusts
crutch	13	40	824	3	crutch
crux	13	54	1500	3	cru__x
cruxes	15	49	1156	3	cruxes
cry	8	97	2624	3	cr___y
crybaby	19	4	193	3	crybaby
cub	7	69	4094	3	c_u_b_
cube	8	58	3021	3	c_u_be
cubs	8	58	3238	3	c_u_bs
cuddy	12	51	1197	3	c_uddy
cully	10	55	2046	3	c_ully
cum	7	64	4016	3	c_um__
cumber	12	40	1670	3	c_umber
cumbia	12	37	989	3	c_umbia
cumin	9	46	1697	3	c_umin
cuppy	14	47	1038	3	c_uppy
curably	14	20	1077	3	curably
curacy	13	3	959	3	curacy
curb	8	67	3222	3	c_urb_
curbs	9	48	2165	3	c_urbs
curdy	11	59	1652	3	c_urdy
curly	10	53	2123	3	c_urly
curry	10	59	2034	3	c_urry
curtly	11	4	928	3	curtly
curtsy	11	5	664	3	curtsy
curvey	14	41	1184	3	curvey
curvy	13	60	1337	3	c_urvy
cushy	13	44	1232	3	c_ushy
cutey	10	58	1979	3	c_utey
cutty	10	54	1722	3	c_utty
dauby	11	52	1122	3	dau_by
drub	7	59	2013	3	dru_b_
drubs	8	59	1383	3	dru_bs
druggy	12	34	474	3	druggy
drum	7	65	2159	3	drum__
drumble	12	33	789	3	drumble
drums	8	54	1587	3	drum_s
dumb	9	71	2410	3	_dumb_
dumbly	14	39	960	3	_dumbly
dumbo	10	56	1406	3	_dumbo
dumbs	10	59	1575	3	_dumbs
dumky	15	45	1134	3	_dumky
dummy	13	47	1278	3	_dummy
dumpy	13	54	1475	3	_dumpy
fruity	12	42	969	3	fruity
frump	12	69	1256	3	frum_p
frumps	13	47	978	3	frumps
fumy	12	71	1858	3	_fum_y
glumly	12	35	662	3	glumly
glumpy	14	52	719	3	glumpy
grabby	14	33	618	3	grabby
gremmy	14	5	447	3	gremmy
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	grim_y
grub	7	72	2008	3	gru_b_
grubs	8	63	1260	3	gru_bs
gruffy	16	39	601	3	gruffy
grum	7	56	2508	3	grum__
grumble	12	34	923	3	grumble
grume	8	62	1816	3	grum_e
grumes	9	44	1555	3	grumes
grump	10	51	1531	3	grum_p
grumphy	18	44	362	3	grumphy
grumps	11	45	1057	3	grumps
grungy	11	34	597	3	grungy
gumbo	10	44	1358	3	_gumbo
gummy	13	54	1365	3	_gummy
hubby	15	50	1140	3	_hubby
humbly	16	40	1052	3	_humbly
humpy	15	51	1567	3	_humpy
jumbo	16	43	1107	3	_jumbo
jumpy	19	57	1281	3	_jumpy
knubby	17	4	278	3	knubby
krubi	11	3	652	3	kru_bi
lamby	12	51	1484	3	_lamby
limby	12	57	1407	3	_limby
lumpy	12	66	1591	3	_lumpy
mumbly	15	31	946	3	_mumbly
mummy	11	49	1362	3	_mummy
nubby	12	50	1103	3	_nubby
numb	8	55	2061	3	_numb_
numbly	13	44	1066	3	_numbly
numbs	9	49	1309	3	_numbs
orby	9	75	1960	3	or__by
outby	10	4	1153	3	_outby
plumb	11	45	1407	3	plumb_
plumbs	12	45	933	3	plumbs
plummy	15	37	566	3	plummy
plumy	12	42	1323	3	plum_y
primly	13	43	962	3	primly
rammy	12	43	1249	3	_rammy
rhumb	12	43	865	3	rhumb_
rhumba	13	37	555	3	rhumba
rhumbs	13	36	677	3	rhumbs
ribby	12	41	968	3	_ribby
rimy	9	66	2128	3	_rim_y
rub	5	63	4282	3	_ru_b_
rubbly	13	37	1061	3	_rubbly
rube	6	55	3201	3	_ru_be
rubs	6	61	3349	3	_ru_bs
ruddy	10	45	1175	3	_ruddy
ruly	7	63	2314	3	_ru_ly
rum	5	66	4464	3	_rum__
rumbas	10	25	1201	3	_rumbas
rumble	10	37	1881	3	_rumble
rumen	7	44	1950	3	_rumen
rumor	7	10	1132	3	_rumor
rump	8	67	2908	3	_rum_p
rumply	13	34	857	3	_rumply
rumps	9	59	2229	3	_rumps
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
scrub	9	49	1420	3	scru_b_
scrubs	10	42	1031	3	scru_bs
scruffy	18	4	264	3	scruffy
scrum	9	54	1820	3	scrum__
scrums	10	46	1425	3	scrum_s
scummy	15	26	522	3	scummy
shrubby	17	4	236	3	shrubby
slummy	13	32	586	3	slummy
snubby	13	4	453	3	snubby
spumy	12	46	1036	3	spum_y
stubby	13	4	504	3	stubby
stumpy	13	45	813	3	stumpy
thrummy	17	4	217	3	thrummy
thumb	12	45	1128	3	thumb_
thumbs	13	37	744	3	thumbs
trampy	13	49	925	3	trampy
trembly	14	3	552	3	trembly
trilby	11	4	497	3	trilby
trimly	11	44	1089	3	trimly
truly	8	41	1155	3	tru_ly
trump	9	56	1512	3	trum_p
trumps	10	46	1188	3	trumps
trusty	9	47	1011	3	trusty
tubby	12	45	1140	3	_tubby
tummy	12	47	1199	3	_tummy
umbo	8	55	1666	3	__umbo
upby	11	3	906	3	__upby
womby	15	59	1009	3	_womby
yummy	15	42	915	3	_yummy

Search took 6 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.373	479064.3
2	DLD Change Limit	112716	321	4.953	22757.1
3	Display Results	321	321	0.110	2918.2
	(SQL Overall)	178691	321	5.436	32871.8