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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

99 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
commy	14	47	1264	(None)
comfy	15	37	1021	1	comfy
comma	11	45	1479	1	comma
mommy	11	40	1075	1	mommy
pommy	14	44	986	1	pommy
tommy	12	47	1223	1	tommy
boomy	12	54	2182	2	boomy
campy	14	51	1618	2	campy
chammy	18	48	895	2	chammy
chummy	18	38	589	2	chummy
clammy	15	35	633	2	clammy
coaly	10	55	2159	2	coaly
cobby	14	55	1641	2	cobby
cocky	16	42	1593	2	cocky
coky	13	75	2682	2	co_ky
colby	12	44	1506	2	colby
colly	10	49	2677	2	colly
coly	9	69	4053	2	co_ly
coma	8	71	3485	2	co_ma
comae	9	71	2842	2	comae
comal	9	51	2513	2	comal
comas	9	58	3300	2	comas
comb	10	66	3211	2	co_mb
combe	11	62	2354	2	combe
combo	11	45	1943	2	combo
combs	11	61	2296	2	combs
come	8	75	4770	2	co_me
comedy	14	37	823	2	comedy
comely	13	42	1373	2	comely
comer	9	58	3269	2	comer
comes	9	72	4699	2	comes
comet	9	59	4607	2	comet
comic	11	47	2181	2	comic
comity	13	3	1271	2	comity
comix	16	35	1320	2	comix
commas	12	48	1457	2	commas
commie	12	42	1552	2	commie
commit	12	40	1670	2	commit
commix	19	40	776	2	commix
common	12	3	1080	2	common
comp	10	67	3125	2	co_mp
comply	15	28	1038	2	comply
compo	11	53	1857	2	compo
comps	11	55	2605	2	comps
compt	11	63	2822	2	compt
comte	9	61	2547	2	comte
coney	10	59	3288	2	coney
conky	14	58	1874	2	conky
cony	9	65	3783	2	co_ny
cooey	10	58	2822	2	cooey
cooky	14	53	2136	2	cooky
cooly	10	55	2542	2	cooly
coomb	11	56	1570	2	coomb
copay	12	65	1631	2	copay
copy	11	62	2980	2	co_py
corby	12	50	1853	2	corby
corky	14	52	2115	2	corky
corm	8	57	3538	2	corm_
corms	9	56	2622	2	corms
corny	10	60	2327	2	corny
cory	9	69	4151	2	co_ry
cosey	10	62	2671	2	cosey
cosy	9	72	3270	2	co_sy
covey	13	61	2178	2	covey
cowry	13	55	1248	2	cowry
cowy	12	64	2736	2	co_wy
coy	8	105	5755	2	co__y
coyly	13	56	1489	2	coyly
cozey	19	67	1854	2	cozey
cozy	18	58	2380	2	co_zy
crummy	15	36	589	2	crummy
doomy	11	60	1826	2	doomy
dormy	11	58	1747	2	dormy
dummy	13	47	1278	2	dummy
emmy	11	60	1324	2	_emmy
foamy	13	53	1320	2	foamy
gammy	13	55	1489	2	gammy
gemmy	13	52	1105	2	gemmy
gummy	13	54	1365	2	gummy
hammy	15	51	1343	2	hammy
homey	13	59	2484	2	homey
homy	12	66	2322	2	ho_my
immy	11	46	1183	2	_immy
jammy	19	48	1019	2	jammy
jemmy	19	49	855	2	jemmy
jimmy	19	53	850	2	jimmy
loamy	10	59	1334	2	loamy
mammy	11	52	1516	2	mammy
momma	8	51	1105	2	momma
mummy	11	49	1362	2	mummy
rammy	12	43	1249	2	rammy
roomy	10	71	1806	2	roomy
rummy	12	42	1241	2	rummy
scummy	15	26	522	2	scummy
tammy	12	40	1322	2	tammy
tummy	12	47	1199	2	tummy
womby	15	59	1009	2	womby
wormy	13	75	1425	2	wormy
yummy	15	42	915	2	yummy

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	99	1.596	33709.3
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	1.922	92971.4