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

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

58 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
chilies	12	42	1830	(None)
childes	13	42	1127	1	childes
chiles	11	54	2530	1	chil_es
chilis	11	55	1787	1	chili_s
chillies	13	41	1347	1	chillies
chivies	15	34	1285	1	chivies
bailies	9	41	2020	2	bailies
ceilis	8	54	1374	2	ceili_s
chalices	15	3	1081	2	chalices
challies	13	39	1563	2	challies
charlies	13	34	1422	2	charlies
chevies	15	35	1144	2	chevies
chicles	14	35	1250	2	chicles
chides	12	46	2047	2	chi_des
chigoes	13	3	835	2	chigoes
childe	12	47	1121	2	childe_
chile	10	56	2689	2	chil_e_
chili	10	62	1848	2	chili__
chiliad	13	3	756	2	chiliad
chiliads	14	4	585	2	chiliads
chiliasm	15	13	451	2	chiliasm
chiliast	13	11	793	2	chiliast
chilled	13	33	1093	2	chilled
chiller	12	41	1218	2	chiller
chillers	13	37	1091	2	chillers
chillest	13	25	959	2	chillest
chillier	13	32	842	2	chillier
chilliest	14	35	891	2	chilliest
chillis	12	44	1160	2	chillis
chills	11	47	1770	2	chil_ls
chimblies	18	4	502	2	chimblies
chimes	13	49	2257	2	chi_mes
chines	11	50	2917	2	chi_nes
chippies	17	30	975	2	chippies
chirres	12	38	1225	2	chirres
chitins	12	27	1379	2	chitins
chitlins	13	28	939	2	chitlins
chitties	13	3	1077	2	chitties
chives	14	43	1759	2	chi_ves
chivied	16	36	838	2	chivied
chivvies	19	5	442	2	chivvies
cholines	13	22	1449	2	cholines
chyles	14	48	1328	2	chyl_es
cilices	11	38	1402	2	c_ilices
cities	8	45	2485	2	c_ities
civies	11	41	1644	2	c_ivies
colies	8	48	3705	2	c_olies
collies	9	43	2658	2	collies
coolies	9	38	2496	2	coolies
cullies	9	44	1996	2	cullies
dailies	8	42	1926	2	dailies
doilies	8	40	1736	2	doilies
ghillies	12	40	866	2	ghillies
holies	9	46	3003	2	_holies
lilies	6	30	2141	2	_lilies
whiles	12	44	1801	2	whil_es
whirlies	14	16	737	2	whirlies
whities	13	31	1325	2	whities

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.140	1276364.3
2	DLD Change Limit	107671	58	2.923	36835.8
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	3.093	57772.7