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

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

68 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
comma	11	45	1479	(None)
coma	8	71	3485	1	co_ma
commas	12	48	1457	1	commas
commy	14	47	1264	1	commy
momma	8	51	1105	1	momma
coala	7	75	2112	2	coala
cobia	9	41	1751	2	cobia
cobra	9	52	1440	2	cobra
coca	8	80	3064	2	co_ca
cocoa	9	85	1788	2	cocoa
coda	7	70	2935	2	co_da
cola	6	65	4139	2	co_la
colza	16	51	1298	2	colza
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
combat	12	3	1675	2	combat
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
comer	9	58	3269	2	comer
comes	9	72	4699	2	comes
comet	9	59	4607	2	comet
comfy	15	37	1021	2	comfy
comic	11	47	2181	2	comic
comix	16	35	1320	2	comix
command	14	39	921	2	command
commata	13	3	848	2	commata
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
compas	12	58	1706	2	compas
compo	11	53	1857	2	compo
comps	11	55	2605	2	comps
compt	11	63	2822	2	compt
comte	9	61	2547	2	comte
conga	8	54	1987	2	conga
coomb	11	56	1570	2	coomb
copra	9	81	1546	2	copra
coria	7	58	2832	2	coria
corm	8	57	3538	2	corm_
corms	9	56	2622	2	corms
costa	7	55	2373	2	costa
cotta	7	58	1857	2	cotta
cowman	13	9	1037	2	cowman
coxa	13	69	2296	2	co_xa
cyma	11	67	1584	2	c_yma
dogma	9	61	1246	2	dogma
dolma	8	62	1417	2	dolma
douma	8	58	1770	2	douma
gamma	10	61	1611	2	gamma
gemma	10	63	1177	2	gemma
gumma	10	53	1310	2	gumma
korma	11	59	1309	2	korma
lemma	9	48	1103	2	lemma
louma	7	62	1363	2	louma
mamma	8	63	1792	2	mamma
mommas	9	41	1065	2	mommas
mommy	11	40	1075	2	mommy
noma	6	75	2946	2	no_ma
pommy	14	44	986	2	pommy
soma	6	56	3529	2	so_ma
summa	9	47	1331	2	summa
tommy	12	47	1223	2	tommy

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	53800	0.406	440125.6
2	DLD Change Limit	53800	68	3.170	16971.6
3	Display Results	68	68	0.016	4250.0
	(SQL Overall)	178691	68	3.592	49746.9