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

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

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.

94 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
commixt	20	35	762	(None)
commit	12	40	1670	1	commi_t
commix	19	40	776	1	commix_
comfit	13	31	1242	2	comfi_t
comix	16	35	1320	2	co_mix_
comment	13	103	1770	2	comment
commie	12	42	1552	2	commi_e
commies	13	37	1845	2	commies
commits	13	38	1238	2	commits
commixed	22	6	474	2	commixed
commixes	21	7	735	2	commixes
cosmist	11	3	1133	2	cosmist
admixt	16	3	733	3	_admixt
bemixt	17	45	1036	3	_bemixt
cambist	13	3	1211	3	cambist
cammie	12	46	1529	3	cammi_e
cammies	13	40	1648	3	cammies
catmint	11	3	1446	3	catmint
chemist	14	36	1500	3	chemist
chymist	17	26	817	3	chymist
coadmit	12	4	783	3	coadmi_t
coaming	12	38	1832	3	coaming
coedit	9	3	1624	3	coedi_t
coempt	12	3	1103	3	coem_pt
coexist	16	3	858	3	coexist
combat	12	3	1675	3	co_mbat
combine	13	30	1472	3	combine
combing	14	37	1473	3	combing
combust	13	3	836	3	combust
comet	9	59	4607	3	co_m_et
comfier	14	3	916	3	comfier
comfiest	15	3	913	3	comfiest
comfits	14	32	874	3	comfits
comfort	14	36	1169	3	comfort
comic	11	47	2181	3	co_mi_c
comics	12	40	1556	3	co_mics
coming	11	42	2545	3	co_ming
comity	13	3	1271	3	co_mity
comma	11	45	1479	3	comm__a
command	14	39	921	3	command
commas	12	48	1457	3	comm_as
commata	13	3	848	3	commata
commend	14	40	1018	3	commend
comments	14	29	1388	3	comments
comminute	15	9	615	3	comminute
committal	15	4	372	3	committal
committed	16	4	572	3	committed
committee	15	4	624	3	committee
commixing	23	4	519	3	commixing
commixture	23	5	239	3	commixt~~ure~~
commode	14	3	812	3	commode
common	12	3	1080	3	comm_on
commons	13	3	1104	3	commons
commove	16	3	596	3	commove
commune	13	32	936	3	commune
communist	15	4	811	3	communist
commute	13	43	1044	3	commute
commy	14	47	1264	3	comm__y
compact	15	37	1221	3	compact
compart	13	40	1600	3	compart
compile	13	3	1244	3	compile
comping	14	35	1859	3	comping
complot	13	3	1068	3	complot
comport	13	36	1684	3	comport
compost	13	45	1535	3	compost
compt	11	63	2822	3	co_m_pt
confit	11	33	1640	3	confi_t
consist	9	3	1603	3	consist
context	16	39	1343	3	context
convict	14	34	1098	3	convict
copyist	14	3	905	3	copyist
cosmic	12	4	1034	3	cosmi_c
cosmid	11	8	1064	3	cosmi_d
cosmids	12	3	763	3	cosmids
cosmism	13	3	701	3	cosmism
cosmists	12	3	799	3	cosmists
cummin	12	8	878	3	cummi_n
cummins	13	5	896	3	cummins
dammit	11	3	1113	3	dammi_t
immix	16	3	503	3	_immix_
mixt	13	68	3192	3	___mixt
mommies	10	39	1227	3	mommies
omit	6	53	3737	3	_o_mi_t
pommie	12	37	1050	3	pommi_e
pommies	13	37	1284	3	pommies
premixt	18	35	1066	3	premixt
recommit	14	4	555	3	recommi_t
remixt	15	50	1485	3	_remixt
summit	10	3	1154	3	summi_t
tommies	11	38	1298	3	tommies
tomming	12	35	924	3	tomming
tomtit	8	4	1385	3	tomti_t
unmixt	15	37	870	3	_unmixt
vomit	10	26	2257	3	vo_mi_t

Search took 8 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	134027	0.423	422437.4
2	DLD Change Limit	134027	94	6.766	19808.9
3	Display Results	94	94	0.030	3133.3
	(SQL Overall)	178691	94	7.219	24752.9