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

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

66 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
comitial	12	4	869	(None)
comitia	11	3	972	1	comitia_
coital	8	41	1705	2	co_it_al
comical	13	3	1222	2	comi_cal
comities	12	3	1779	2	comities
committal	15	4	372	2	committal
conidial	11	5	950	2	conidial
somital	9	3	940	2	somit_al
cambial	13	40	1076	3	cam_bial
camisia	11	28	1024	3	camisia_
camisias	12	26	860	3	camisias
capital	11	23	1152	3	capit_al
chital	11	43	1388	3	c_hit_al
citral	8	11	1389	3	c__itral
coastal	9	4	1104	3	coast_al
coattail	10	4	531	3	coattail
coaxial	16	15	700	3	co_axial
cocktail	16	4	536	3	cocktail
codicil	12	4	681	3	codici_l
coition	9	3	1431	3	co_ition
coitional	11	4	869	3	co_itional
colitic	11	29	1619	3	coliti_c
colitis	9	26	1735	3	coliti_s
colonial	10	4	1134	3	colonial
comal	9	51	2513	3	com___al
comatic	13	18	1694	3	comati_c
comatik	15	13	972	3	comati_k
comatiks	16	14	804	3	comatiks
comatula	12	4	426	3	comatula
comedian	13	4	745	3	comedian
cometic	13	12	1572	3	cometi_c
comity	13	3	1271	3	comit__y
committals	16	5	308	3	committals
communal	14	4	635	3	communal
comprisal	15	4	451	3	comprisal
compting	15	30	1360	3	compting
conical	11	3	1620	3	coni_cal
conidia	10	6	930	3	conidia_
conidian	11	6	838	3	conidian
convivial	17	6	411	3	convivial
cordial	10	3	1295	3	co_rdial
cortical	12	4	1221	3	cortical
cosmical	14	4	801	3	cosmi_cal
costal	8	54	1951	3	co_st_al
cotidal	10	3	846	3	coti_dal
countian	10	4	812	3	countian
coxitis	16	23	846	3	coxiti_s
critical	12	3	1026	3	c_ritical
cubital	11	3	710	3	cubit_al
cymatia	14	4	644	3	cymatia_
domical	12	3	937	3	domi_cal
domicil	12	4	643	3	domici_l
dominical	14	4	601	3	dominical
familial	13	6	608	3	familial
gonidial	10	6	594	3	gonidial
homicidal	17	4	387	3	homicidal
hominian	13	5	709	3	hominian
initial	7	3	1188	3	_initial
mitral	8	13	1432	3	__mitral
nominal	9	27	1237	3	nomi_nal
political	13	4	971	3	political
remigial	11	4	660	3	remigial
remittal	10	4	651	3	remittal
somitic	11	15	1263	3	somiti_c
vomiting	14	3	773	3	vomiting
vomitive	16	4	585	3	vomitive

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	66	7.830	18666.9
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.280	21581.0