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

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

82 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
chilled	13	33	1093	(None)
chiller	12	41	1218	1	chiller
hilled	10	40	2222	1	_hilled
shilled	11	33	1362	1	shilled
achillea	13	4	410	2	achillea
billed	9	42	2490	2	_billed
called	9	41	2673	2	c_alled
cavilled	14	3	673	2	cavilled
ceiled	9	41	1495	2	cei_led
celled	9	44	2032	2	c_elled
chalked	17	44	986	2	chalked
chicle	13	43	1254	2	chicle_
chicles	14	35	1250	2	chicles
chided	13	51	1396	2	chi_ded
chield	12	46	1021	2	chiel_d
child	11	45	1622	2	chi_l_d
childbed	17	4	288	2	childbed
childe	12	47	1121	2	childe_
childes	13	42	1127	2	childes
chile	10	56	2689	2	chi_le_
chiles	11	54	2530	2	chi_les
chiliad	13	3	756	2	chiliad
chilies	12	42	1830	2	chilies
chill	10	56	1987	2	chill__
chillers	13	37	1092	2	chillers
chillest	13	25	959	2	chillest
chilli	11	43	1277	2	chill_i
chillier	13	32	842	2	chillier
chillies	13	41	1348	2	chillies
chillis	12	44	1160	2	chillis
chills	11	47	1770	2	chill_s
chillum	14	3	544	2	chillum
chilly	14	41	1322	2	chill_y
chimed	14	58	1483	2	chi_med
chimley	17	8	516	2	chimley
chined	12	56	2006	2	chi_ned
chinked	17	40	1102	2	chinked
chinned	13	48	1049	2	chinned
chipped	17	41	1081	2	chipped
chirked	17	38	1033	2	chirked
chirmed	15	37	973	2	chirmed
chirped	15	37	978	2	chirped
chirred	13	36	1212	2	chirred
chiseled	14	3	588	2	chiseled
chiselled	15	4	422	2	chiselled
chivied	16	36	838	2	chivied
coiled	9	51	2394	2	coi_led
culled	9	40	2247	2	c_ulled
dilled	8	41	2222	2	_dilled
drilled	9	47	1167	2	drilled
filled	10	49	2226	2	_filled
frilled	11	39	1160	2	frilled
gilled	8	45	2163	2	_gilled
grilled	9	40	1283	2	grilled
helled	10	40	2470	2	_helled
hiller	9	44	2163	2	_hiller
hilloed	11	32	1129	2	_hilloed
hilted	10	40	1604	2	_hilted
hulled	10	39	2001	2	_hulled
killed	11	39	1877	2	_killed
milled	9	43	2617	2	_milled
nilled	7	39	1945	2	_nilled
pilled	9	42	2275	2	_pilled
prilled	10	47	1300	2	prilled
quilled	17	32	928	2	quilled
rilled	7	45	2565	2	_rilled
schiller	13	29	647	2	schiller
shelled	11	38	1509	2	shelled
shrilled	12	4	686	2	shrilled
skilled	12	31	1086	2	skilled
spilled	10	36	1362	2	spilled
stilled	8	33	1479	2	stilled
swilled	11	36	1183	2	swilled
thirled	11	32	809	2	thirled
thrilled	12	3	549	2	thrilled
tilled	7	47	2295	2	_tilled
trilled	8	41	1631	2	trilled
twilled	11	39	803	2	twilled
unchilled	15	4	556	2	unchilled
whiled	13	45	1413	2	whi_led
whirled	14	36	804	2	whirled
willed	10	47	2245	2	_willed

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.376	475242.0
2	DLD Change Limit	107671	82	3.030	35535.0
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	3.439	51960.2