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

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

65 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
prelusions	12	5	637	(None)
preclusions	15	4	466	1	preclusions
prelusion	11	5	660	1	prelusion_
prolusions	12	4	588	1	prolusions
delusions	10	3	705	2	_delusions
elusions	8	26	1008	2	__elusions
perfusions	15	9	533	2	perfusions
precisions	14	4	937	2	precisions
preclusion	14	4	521	2	preclusion_
preunions	11	4	648	2	pre_unions
previsions	15	4	773	2	previsions
profusions	15	4	525	2	profusions
prolusion	11	4	636	2	prolusion_
reclusions	12	4	624	2	_reclusions
allusions	9	4	600	3	_allusions
collusions	12	4	597	3	collusions
delusion	9	3	743	3	_delusion_
elisions	8	22	1042	3	__elisions
elusion	7	23	1095	3	__elusion_
elutions	8	25	1305	3	__elutions
exclusions	19	4	501	3	exclusions
illusions	9	4	621	3	_illusions
inclusions	12	7	565	3	inclusions
occlusions	14	4	371	3	occlusions
pensions	10	3	1169	3	p_e_nsions
percussions	15	4	487	3	percussions
perfusion	14	10	588	3	perfusion_
persuasions	13	8	391	3	persuasions
pervasions	15	4	566	3	pervasions
phelonions	15	4	355	3	phelonions
pleustons	11	4	428	3	ple_ustons
plosions	10	3	802	3	p__losions
pollutions	12	4	543	3	pollutions
preassigns	13	4	355	3	preassigns
precautions	15	4	655	3	precautions
precessions	15	4	855	3	precessions
precisians	14	4	641	3	precisians
precision	13	4	1005	3	precision_
predations	13	8	1215	3	predations
prefixions	22	4	387	3	prefixions
prehensions	16	4	594	3	prehensions
prelections	15	12	1046	3	prelections
preluding	13	3	705	3	preludi_ng
prelusive	14	5	558	3	prelusi_ve
prelusory	14	4	287	3	prelus_ory
prenotions	12	4	829	3	prenotions
preoptions	14	4	764	3	preoptions
pretensions	13	4	708	3	pretensions
preunion	10	4	689	3	pre_union_
prevision	14	4	800	3	prevision_
profusion	14	4	570	3	profusion_
propulsions	15	5	330	3	propulsions
protrusions	13	5	414	3	protrusions
provisions	15	4	721	3	provisions
pulsions	10	3	771	3	p_ul_sions
recisions	11	3	991	3	_recisions
reclusion	11	4	650	3	_reclusion_
recursions	12	4	540	3	_recursions
relations	9	24	1833	3	_relations
religions	10	8	660	3	_religions
repulsions	12	4	479	3	_repulsions
reunions	8	3	727	3	_re_unions
revisions	12	3	859	3	_revisions
revulsions	13	4	426	3	_revulsions
seclusions	12	4	463	3	seclusions

Search took 8 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	140603	0.170	1051123.5
2	DLD Change Limit	140603	65	6.890	20406.8
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	7.093	25192.6