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

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

73 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
affection	17	4	589	(None)
affections	18	4	589	1	affections
abjection	20	4	532	2	abjection
advection	15	4	555	2	advection
affectation	19	4	384	2	affectation
affecting	18	4	523	2	affecting
affectional	19	5	389	2	affectional
affectioned	20	5	245	2	affectioned
affective	20	13	541	2	affective
affliction	18	4	354	2	affliction
defection	15	16	1064	2	defection
flection	13	23	956	2	_flection
infection	14	4	1047	2	infection
refection	14	15	1228	2	refection
abduction	14	12	541	3	abduction
abjections	21	4	567	3	abjections
abreaction	14	4	465	3	abreaction
action	8	47	1968	3	a___ction
addiction	13	14	601	3	addiction
adduction	13	22	516	3	adduction
advections	16	4	555	3	advections
affect	14	4	890	3	affect___
affectations	20	4	343	3	affectations
affected	17	4	479	3	affect_ed
affecter	16	4	452	3	affect_er
affecters	17	6	393	3	affecters
affectionate	20	7	210	3	affection~~ate~~
affects	15	3	539	3	affect__s
affixation	23	4	439	3	affixation
afflictions	19	4	340	3	afflictions
affusion	14	4	392	3	aff_usion
assertion	9	4	672	3	assertion
attention	9	4	610	3	attention
auction	9	34	1293	3	a__uction
bijection	20	13	479	3	bijection
bilection	13	15	680	3	bilection
bisection	13	13	698	3	bisection
bolection	13	11	767	3	bolection
confection	17	4	1118	3	confection
defecation	16	7	980	3	defecation
defections	16	15	1020	3	defections
deflection	16	14	773	3	deflection
dejection	19	17	866	3	dejection
detection	12	13	1041	3	detection
direction	12	8	978	3	direction
disaffection	21	5	320	3	~~dis~~affection
effecting	18	4	558	3	effecting
effective	20	7	619	3	effective
effector	16	4	487	3	effect_or
ejection	17	25	1004	3	_ejection
election	10	20	1535	3	_election
erection	10	21	1551	3	_erection
evection	13	19	1083	3	_evection
exsection	18	4	749	3	exsection
faction	12	26	1333	3	__faction
fiction	12	20	1073	3	__fiction
flections	14	23	921	3	_flections
fraction	13	5	948	3	_fraction
friction	13	4	791	3	_friction
function	13	3	784	3	_function
infections	15	5	1023	3	infections
inflection	15	4	763	3	inflection
injection	18	3	865	3	injection
lection	9	26	1486	3	__lection
objection	20	4	509	3	objection
olfaction	14	6	423	3	olfaction
perfection	17	4	836	3	perfection
refections	15	18	1164	3	refections
reflection	15	16	899	3	reflection
rejection	18	17	1025	3	rejection
resection	11	16	1327	3	resection
section	9	25	1566	3	__section
selection	11	3	1127	3	selection

Search took 9 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.436	409841.7
2	DLD Change Limit	148641	73	7.516	19776.6
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.982	22386.7