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

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

55 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
chicles	14	35	1250	(None)
chicle	13	43	1254	1	chicle_
chiles	11	54	2530	1	chi_les
calicles	12	38	1143	2	calicles
chicanes	15	5	937	2	chicanes
chicas	13	59	1647	2	chic_as
chicer	13	45	1360	2	chic_er
chicest	14	20	994	2	chic_est
chichis	17	3	707	2	chichis
chickee	18	31	1155	2	chickee
chickees	19	25	851	2	chickees
chicken	18	27	898	2	chicken
chickens	19	26	743	2	chickens
chicks	17	53	1759	2	chic_ks
chicly	16	42	920	2	chicl_y
chicness	15	3	559	2	chicness
chicos	13	46	1483	2	chic_os
chics	12	39	2094	2	chic__s
chides	12	46	2047	2	chi_des
chields	13	50	748	2	chields
chiels	11	51	1593	2	chiel_s
chigoes	13	3	835	2	chigoes
childes	13	42	1127	2	childes
chile	10	56	2689	2	chi_le_
chilies	12	42	1830	2	chilies
chilis	11	55	1787	2	chi_lis
chilled	13	33	1093	2	chilled
chiller	12	41	1218	2	chiller
chillers	13	37	1092	2	chillers
chillest	13	25	959	2	chillest
chillies	13	41	1348	2	chillies
chillis	12	44	1160	2	chillis
chills	11	47	1770	2	chi_lls
chimes	13	49	2257	2	chi_mes
chimlas	14	3	745	2	chimlas
chimley	17	8	516	2	chimley
chimleys	18	8	363	2	chimleys
chinches	18	36	936	2	chinches
chines	11	50	2917	2	chi_nes
chinless	13	3	749	2	chinless
chirres	12	38	1225	2	chirres
chisels	12	21	910	2	chisels
chives	14	43	1759	2	chi_ves
chivies	15	34	1285	2	chivies
choices	14	20	1061	2	choic_es
chuckles	19	3	680	2	chuckles
chyles	14	48	1328	2	ch_yles
circles	11	3	990	2	circles
cliches	14	42	1374	2	cliches
cubicles	14	3	588	2	cubicles
cuticles	12	3	789	2	cuticles
cycles	13	3	930	2	c_ycles
icicles	11	3	594	2	icicles
vehicles	16	20	468	2	vehicles
whiles	12	44	1801	2	whi_les

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	107671	0.373	479064.3
2	DLD Change Limit	107671	55	3.406	31612.2
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	3.795	47085.9