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

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

71 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
unaffecting	20	5	216	(None)
affecting	18	4	523	2	__affecting
disaffecting	22	5	293	3	disaffecting
effecting	18	4	558	3	__effecting
infecting	15	10	967	3	in__fecting
inflecting	16	4	631	3	in_flecting
unaffected	19	4	294	3	unaffect_ed
advecting	16	4	511	4	__advecting
affectingly	23	5	239	4	__affectingly
affection	17	4	589	4	__affection
affections	18	4	589	4	__affections
affective	20	13	541	4	__affective
afflicting	19	4	348	4	__afflicting
buffeting	18	4	378	4	_buffe_ting
cathecting	18	4	483	4	_cathecting
chaffering	22	10	464	4	chaffe_ring
coinfecting	19	4	457	4	coinfecting
confecting	18	3	1055	4	_confecting
defecting	16	25	1022	4	__defecting
deflecting	17	3	650	4	_deflecting
enacting	11	3	1136	4	ena___cting
genuflecting	19	6	125	4	genuflecting
graffiting	18	4	292	4	graff_iting
ineffective	22	7	393	4	ineffective
infesting	13	10	951	4	in__festing
inflicting	16	4	572	4	in_flicting
infracting	16	4	735	4	in_fracting
injecting	19	9	769	4	in__jecting
inspecting	15	4	622	4	in_specting
leafleting	14	4	289	4	leafle_ting
leafletting	15	4	198	4	leafletting
mafficking	25	4	264	4	_mafficking
manifesting	17	6	273	4	manifesting
naffing	14	35	903	4	_naff___ing
nauseating	11	4	498	4	_nauseating
neglecting	14	4	454	4	_neglecting
niffering	16	4	513	4	_niffe_ring
perfecting	18	4	751	4	_perfecting
praelecting	16	4	453	4	praelecting
redefecting	18	4	437	4	redefecting
refecting	15	24	1335	4	__refecting
reflecting	16	3	882	4	_reflecting
reinfecting	17	4	515	4	reinfecting
snaffling	16	4	376	4	snaff__ling
trafficking	24	5	178	4	trafficking
trajecting	20	4	429	4	tra_jecting
transecting	14	4	737	4	transecting
transfecting	18	5	516	4	transfecting
unabating	12	4	675	4	una__bating
unaffectedly	24	6	147	4	unaffectedly
unaffectionate	22	7	123	4	unaffectionate
unageing	10	3	627	4	una_ge__ing
unappealing	16	5	219	4	unappealing
unbelting	12	3	766	4	un__belting
unbreeching	19	4	216	4	unbreeching
uncreating	13	3	1047	4	un_creating
underacting	15	4	752	4	underacting
undereating	13	6	955	4	undereating
unfearing	13	3	888	4	un__fearing
unfeeling	13	3	711	4	un__feeling
unfencing	15	4	595	4	un__fencing
unfitting	13	3	642	4	un__fitting
unfreeing	13	4	510	4	un_fre_eing
unfreezing	23	4	334	4	un_freezing
unfrocking	20	4	353	4	un_frocking
unrelenting	12	4	442	4	unrelenting
unresting	10	3	1113	4	un__resting
unseating	10	7	1320	4	un__seating
unsetting	10	8	899	4	un__setting
unsuspecting	17	5	197	4	unsuspecting
unweeting	13	3	647	4	un__weeting

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.156	1145455.1
2	DLD Change Limit	148819	71	9.593	15513.3
3	Display Results	71	71	0.033	2151.5
	(SQL Overall)	178691	71	9.782	18267.3