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

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

77 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
caulicles	13	4	438	(None)
calicles	12	38	1143	1	ca_licles
caulicle	12	4	504	1	caulicle_
auricles	10	13	833	2	_auricles
calices	11	43	2169	2	ca_lic_es
caliches	15	38	1226	2	ca_liches
calicle	11	31	1143	2	ca_licle_
calicoes	12	39	1159	2	ca_licoes
calycles	15	29	569	2	ca_lycles
canticles	13	3	918	2	canticles
caudices	13	33	734	2	caudic_es
cubicles	14	3	588	2	c_ubicles
culices	11	37	1312	2	c_ulic_es
cuticles	12	3	789	2	c_uticles
articles	10	3	1024	3	_articles
audibles	11	21	553	3	_audibles
audiles	8	31	1261	3	_audi_les
auricle	9	13	981	3	_auricle_
auricled	11	13	570	3	_auricled
cabrioles	13	7	636	3	cabrioles
caddices	14	29	785	3	caddic_es
calces	10	44	2005	3	ca_l_c_es
calcicoles	13	4	402	3	calcicoles
calcines	12	3	1475	3	ca_lcines
calcites	12	3	1300	3	ca_lcites
caleches	15	26	993	3	ca_leches
calibres	12	3	710	3	ca_libres
caliche	14	32	995	3	ca_liche_
calicos	11	39	1349	3	ca_lic_os
calipees	12	4	741	3	ca_lipees
calliopes	13	4	614	3	calliopes
callipees	13	4	530	3	callipees
calyces	14	42	880	3	ca_lyc_es
calycle	14	24	583	3	ca_lycle_
canailles	11	4	827	3	canailles
canticle	12	3	970	3	canticle_
caprices	14	3	989	3	capric_es
caprioles	13	7	675	3	caprioles
carices	11	42	2095	3	ca_ric_es
carioles	10	8	1707	3	ca_rioles
carlines	10	35	2164	3	carli_nes
carrioles	11	6	947	3	carrioles
caruncles	13	4	500	3	caruncles
caudillos	12	4	356	3	caudillos
caudles	10	39	1281	3	cau__dles
caules	8	59	2725	3	cau___les
cauline	9	22	1560	3	cauli_ne_
caulis	8	53	2008	3	cauli___s
chalices	15	3	1081	3	chalic_es
chicles	14	35	1250	3	c__hicles
cilices	11	38	1402	3	c_ilic_es
clavicles	16	4	367	3	clavicles
cliches	14	42	1374	3	c__liches
cornicles	13	6	824	3	cornicles
coulisses	11	4	563	3	coulisses
crucibles	15	4	374	3	crucibles
cubicle	13	3	700	3	c_ubicle_
culches	14	37	1074	3	c_ul_ches
culicids	13	4	562	3	c_ulicids
culicines	13	4	701	3	c_ulicines
cultches	15	31	653	3	c_ultches
curlicues	13	4	334	3	curlicues
curricles	13	10	542	3	curricles
cuticle	11	3	823	3	c_uticle_
cylices	14	35	928	3	c_ylic_es
fascicles	16	6	426	3	fascicles
follicles	14	4	410	3	follicles
funicles	13	24	683	3	_funicles
malices	11	43	1662	3	ma_lic_es
panicles	12	10	1011	3	pa_nicles
particles	13	3	980	3	particles
pellicles	13	4	492	3	pellicles
radicles	11	24	970	3	ra_dicles
sanicles	10	14	994	3	sa_nicles
silicles	10	3	707	3	_silicles
tunicles	10	21	713	3	_tunicles
wavicles	16	3	378	3	wa_vicles

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	148641	0.550	324892.7
2	DLD Change Limit	148641	77	8.263	17988.7
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	8.846	20200.2