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

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

52 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
chicle	13	43	1254	(None)
chicles	14	35	1250	1	chicles
chicly	16	42	920	1	chicly
chile	10	56	2689	1	chi_le
calicle	11	31	1143	2	calicle
chic	11	59	2520	2	chic__
chica	12	58	1826	2	chic_a
chicane	14	8	955	2	chicane
chicas	13	59	1647	2	chicas
chicer	13	45	1360	2	chicer
chichi	16	3	709	2	chichi
chick	16	54	1913	2	chic_k
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chicks	17	53	1759	2	chicks
chico	12	42	1825	2	chic_o
chicos	13	46	1483	2	chicos
chics	12	39	2094	2	chic_s
chide	11	53	2101	2	chi_de
chiel	10	49	1897	2	chiel_
chield	12	46	1021	2	chield
chiels	11	51	1593	2	chiels
chigoe	12	3	753	2	chigoe
child	11	45	1622	2	chi_ld
childe	12	47	1121	2	childe
chiles	11	54	2530	2	chi_les
chili	10	62	1848	2	chi_li
chill	10	56	1987	2	chi_ll
chilled	13	33	1093	2	chilled
chiller	12	41	1218	2	chiller
chilli	11	43	1277	2	chilli
chills	11	47	1770	2	chills
chilly	14	41	1322	2	chilly
chime	12	53	2259	2	chi_me
chimla	13	3	759	2	chimla
chimley	17	8	516	2	chimley
chine	10	52	3172	2	chi_ne
chirre	11	41	1185	2	chirre
chisel	11	21	1194	2	chisel
chive	13	51	1762	2	chi_ve
choice	13	20	1052	2	choic_e
chuckle	18	3	644	2	chuckle
chyle	13	49	1348	2	ch_yle
cicale	10	3	1450	2	c_icale
circle	10	3	970	2	circle
cliche	13	37	1245	2	cliche
cubicle	13	3	700	2	cubicle
cuticle	11	3	823	2	cuticle
cycle	12	3	952	2	c_ycle
icicle	10	3	658	2	icicle
vehicle	15	17	525	2	vehicle
while	11	54	1869	2	whi_le

Search took 3 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	82551	0.340	525561.8
2	DLD Change Limit	82551	52	2.173	37989.4
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	2.529	70656.8