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

Here are the results of your fuzzy-string dictionary search for “delusionary” with Change Limit: [1] [2] [3] [4] [5]

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.

37 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
delusionary	15	5	250	(None)
delusional	11	5	330	2	delusiona_l
illusionary	14	5	261	2	illusionary
ablutionary	16	5	227	3	ablutionary
deflationary	19	5	227	3	deflationary
delusion	9	3	743	3	delusion___
delusions	10	3	705	3	delusion__s
delusory	12	7	300	3	delus_o__ry
devolutionary	20	6	298	3	devolutionary
exclusionary	24	6	224	3	exclusionary
pensionary	15	5	436	3	pe_nsionary
revisionary	17	7	352	3	revisionary
cautionary	15	5	392	4	_cautionary
conclusionary	20	6	210	4	conclusionary
decisional	13	4	483	4	decisiona_l
delusively	17	5	383	4	delusi_vely
depositary	16	5	238	4	deposi_tary
dictionary	16	5	459	4	d_ictionary
diversionary	19	6	203	4	diversionary
elocutionary	17	6	237	4	_elocutionary
elusion	7	23	1095	4	_elusion___
elusions	8	26	1008	4	_elusion__s
elusory	10	8	399	4	_elus_o__ry
evolutionary	18	5	332	4	evolutionary
illusional	10	5	340	4	illusiona_l
lectionary	15	5	482	4	le_ctionary
legionary	13	4	365	4	__legionary
luminary	13	33	665	4	__lumi_nary
missionary	15	5	366	4	_missionary
petitionary	16	5	376	4	petitionary
previsionary	20	8	330	4	previsionary
reactionary	16	5	369	4	reactionary
recessionary	17	5	306	4	recessionary
reflationary	18	7	261	4	reflationary
reversionary	18	5	206	4	reversionary
revolutionary	19	6	349	4	revolutionary
visionary	15	4	403	4	__visionary

Search took 10 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	148819	0.483	369960.7
2	DLD Change Limit	148819	37	9.236	16112.9
3	Display Results	37	37	0.013	2846.2
	(SQL Overall)	178691	37	9.732	18361.2