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

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

61 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
predilection	17	5	409	(None)
predilections	18	5	355	1	predilections
prediction	15	4	1030	2	predi__ction
predigestion	16	7	382	2	predigestion
preelection	15	13	648	2	pre_election
prelection	14	15	1129	2	pre__lection
preselection	16	15	488	2	preselection
redirection	14	4	604	2	_redirection
predication	16	4	1243	3	predi_cation
predictions	16	4	965	3	predi__ctions
predigestions	17	7	328	3	predigestions
prelections	15	12	1046	3	pre__lections
preselections	17	14	444	3	preselections
redigestion	13	8	415	3	_redigestion
redirections	15	4	616	3	_redirections
reelection	12	19	863	3	_re_election
reflection	15	16	899	3	_re_flection
bilection	13	15	680	4	___bilection
codirection	16	4	473	4	_codirection
deflection	16	14	773	4	_de_flection
direction	12	8	977	4	___direction
election	10	20	1535	4	__e__lection
indirection	14	5	637	4	_indirection
misdirection	17	5	415	4	misdirection
perdition	12	4	901	4	perdi___tion
perfection	17	4	836	4	p_e_rfection
postelection	16	5	454	4	postelection
predation	12	3	1346	4	pred___ation
predications	17	4	1118	4	predi_cations
predicting	16	4	987	4	predi__cting
predictive	18	4	742	4	predi__ctive
predictor	14	4	709	4	predi__ct_or
predigesting	17	5	368	4	predigesting
preelecting	16	4	647	4	pre_electing
preignition	14	5	443	4	pre_ignition
preinduction	17	5	378	4	preinduction
prelecting	15	3	1016	4	pre__lecting
prelector	13	4	809	4	pre__lect_or
prelibation	15	12	866	4	preli_bation
premigration	17	5	569	4	premigration
preselecting	17	4	429	4	preselecting
prevention	15	4	917	4	pre__vention
production	15	4	789	4	prod__uction
projection	21	5	876	4	pr__ojection
protection	14	5	1147	4	pr__otection
recollection	16	5	485	4	_recollection
redaction	12	5	966	4	_red__action
redigestions	14	8	386	4	_redigestions
redirecting	15	4	560	4	_redirecting
reduction	12	5	990	4	_red__uction
reelections	13	16	794	4	_re_elections
refection	14	15	1228	4	_re__fection
reflections	16	17	855	4	_re_flections
reinfection	16	4	544	4	_reinfection
reinjection	20	4	458	4	_reinjection
rejection	18	17	1025	4	_re__jection
reliction	11	3	1069	4	_re__liction
repletion	11	4	769	4	_re_ple_tion
resection	11	16	1327	4	_re__section
selection	11	3	1127	4	_se__lection
trisection	12	4	598	4	tr__isection

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	124790	0.203	880251.2
2	DLD Change Limit	124790	61	7.673	16263.5
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	7.906	22601.9