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

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

57 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
affectioned	20	5	245	(None)
affection	17	4	589	2	affection__
affectional	19	5	389	2	affectional
affections	18	4	589	2	affection_s
affected	17	4	479	3	affect___ed
affecting	18	4	523	3	affecti_n_g
affectionate	20	7	210	3	affectionate
affectionless	21	6	187	3	affectionless
affective	20	13	541	3	affecti_ve_
auctioned	12	4	495	3	a__uctioned
fractioned	16	4	461	3	_fractioned
functioned	16	4	399	3	_functioned
sectioned	12	4	652	3	__sectioned
abjection	20	4	532	4	abjection__
abjections	21	4	567	4	abjection_s
accessioned	16	5	250	4	accessioned
actioner	10	4	866	4	a___ctioner
advection	15	4	555	4	advection__
advections	16	4	555	4	advection_s
affectable	20	4	361	4	affectable_
affectation	19	4	384	4	affectation__
affectations	20	4	343	4	affectation_s
affectedness	21	5	320	4	affectedness
affecter	16	4	452	4	affect___er
affectingly	23	5	240	4	affectingly
affectionally	24	5	301	4	affectionally
affectionately	25	7	108	4	affectionately
affectively	25	5	397	4	affectively
affectivity	25	10	326	4	affectivity
afficionado	20	19	139	4	affic_ionado
affined	14	3	641	4	aff___i_ned
affliction	18	4	354	4	affliction__
afflictions	19	4	340	4	affliction_s
ambitioned	15	5	297	4	a_mbitioned
apportioned	16	5	345	4	apportioned
auditioned	12	4	340	4	a_uditioned
confectioner	19	6	414	4	confectioner
defection	15	16	1064	4	defection__
defections	16	15	1020	4	defection_s
effected	17	4	499	4	effect___ed
effecting	18	4	558	4	effecti_n_g
effective	20	7	619	4	effecti_ve_
effectives	21	13	456	4	effecti_ves
effectuated	20	5	199	4	effectuated
festooned	13	4	430	4	__festooned
flection	13	23	956	4	_flection__
flections	14	23	921	4	_flection_s
infection	14	4	1047	4	infection__
infections	15	5	1023	4	infection_s
malfunctioned	21	6	134	4	malfunctioned
mentioned	12	4	683	4	__mentioned
questioned	20	4	318	4	_questioned
refection	14	15	1228	4	refection__
refections	15	18	1164	4	refection_s
sanctioned	13	4	390	4	_sanctioned
suctioned	12	4	528	4	__suctioned
taffetized	26	5	169	4	taffe_ti_zed

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.436	409841.7
2	DLD Change Limit	148819	57	8.986	16561.2
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	9.452	18905.1