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

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

74 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
distilled	11	4	718	(None)
distiller	10	4	667	1	distiller
discipled	15	4	567	2	discipled
dispelled	13	11	757	2	dispelled
distill	8	30	1132	2	distill__
distillers	11	4	513	2	distillers
distillery	14	4	315	2	distillery
distills	9	31	904	2	distill_s
instilled	10	4	530	2	instilled
misbilled	14	4	517	2	misbilled
mistitled	12	4	628	2	mistitled
pistolled	12	5	517	2	pistolled
redistilled	13	5	280	2	redistilled
stilled	8	33	1479	2	__stilled
bastille	10	4	800	3	bastille_
bastilles	11	4	736	3	bastilles
dentiled	10	3	974	3	denti_led
destined	10	33	1245	3	desti_ned
devilled	13	3	674	3	d_evilled
dialled	9	5	1013	3	di__alled
dilled	8	41	2222	3	d___illed
dirtied	9	32	1085	3	dirti__ed
disabled	12	4	871	3	dis_abled
discalced	15	4	565	3	discalced
disciple	13	4	667	3	disciple_
disciples	14	4	640	3	disciples
disentitled	13	5	408	3	disentitled
dishelmed	16	4	509	3	dishelmed
disliked	14	28	855	3	disli_ked
dislimned	13	4	462	3	dislimned
dismissed	13	4	461	3	dismissed
dispeller	12	14	698	3	dispeller
dissolved	14	4	559	3	dissolved
distained	11	3	960	3	distained
distally	12	3	955	3	distall_y
distanced	13	4	857	3	distanced
distasted	11	3	796	3	distasted
distended	12	15	792	3	distended
distil	7	36	1643	3	disti_l__
distillate	11	4	674	3	distillate
distillates	12	4	615	3	distillates
distilling	12	4	779	3	distilling
distils	8	30	1580	3	disti_l_s
distorted	11	3	937	3	distorted
districted	14	4	822	3	districted
disturbed	13	19	558	3	disturbed
disvalued	14	4	419	3	disvalued
drilled	9	47	1167	3	d__rilled
hostelled	13	4	573	3	hostelled
installed	10	4	585	3	installed
instiller	9	4	495	3	instiller
intitled	9	6	734	3	_intitled
miscalled	14	4	744	3	miscalled
misdialed	13	4	551	3	misdialed
misdialled	14	4	301	3	misdialled
misfiled	14	27	865	3	misfi_led
mistimed	13	3	912	3	misti_med
mistitle	10	3	852	3	mistitle_
mistitles	11	4	795	3	mistitles
pastille	10	3	894	3	pastille_
pastilles	11	4	870	3	pastilles
pistoled	11	25	959	3	pist_oled
shilled	11	33	1362	3	__shilled
skilled	12	31	1086	3	__skilled
spilled	10	36	1362	3	__spilled
stalled	8	35	1569	3	__stalled
stifled	11	35	1109	3	__stifled
stiller	7	34	1430	3	__stiller
stilted	8	35	1147	3	__stilted
swilled	11	36	1183	3	__swilled
tilled	7	47	2295	3	___tilled
unskilled	14	4	460	3	unskilled
unspilled	12	4	509	3	unspilled
untilled	9	7	1056	3	_untilled

Search took 7 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.423	422437.4
2	DLD Change Limit	148641	74	6.140	24208.6
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	6.593	27103.1