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

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

36 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
noneffective	23	6	358	(None)
ineffective	22	7	394	2	_ineffective
nonelective	16	6	685	2	none_lective
noninfective	20	5	458	2	noninfective
effective	20	7	619	3	___effective
nondirective	18	5	468	3	nondirective
nonexecutive	24	5	287	3	none_xecutive
nonobjective	26	6	354	3	nonobjective
nonselective	17	5	541	3	nonselective
affective	20	13	541	4	___affective
conflictive	21	5	377	4	con_flictive
connective	17	4	925	4	con__nective
convective	20	4	911	4	con__vective
defective	18	4	800	4	__de_fective
deflective	19	5	609	4	__deflective
effectives	21	13	456	4	___effectives
imperfective	24	5	275	4	imperfective
ineffectively	27	5	313	4	_ineffectively
infective	17	10	897	4	_in__fective
inflective	18	12	657	4	_in_flective
nonactive	14	4	897	4	non___active
nonaddictive	19	6	310	4	nonaddictive
nonassertive	15	5	346	4	nonassertive
noncreative	16	4	823	4	non_creative
nondeceptive	20	5	373	4	nondeceptive
nondeductive	19	5	376	4	nondeductive
nonelection	13	4	720	4	none_lection
nonexecutives	25	6	172	4	none_xecutives
noninductive	18	5	421	4	noninductive
nonreactive	16	4	595	4	non_reactive
nonreflecting	19	5	241	4	nonreflecting
nonsubjective	27	9	251	4	nonsubjective
perfective	20	4	719	4	__perfective
refective	17	4	911	4	__re_fective
reflective	18	5	712	4	__reflective
unreflective	20	5	267	4	unreflective

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.390	458182.1
2	DLD Change Limit	124790	36	7.253	17205.3
3	Display Results	36	36	0.013	2769.2
	(SQL Overall)	178691	36	7.656	23340.0