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

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

63 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
deflector	15	5	506	(None)
defector	14	27	795	1	def_ector
deflectors	16	5	477	1	deflectors
reflector	14	4	573	1	reflector
defecator	15	4	638	2	def_ecator
defectors	15	23	788	2	def_ectors
deflator	12	32	834	2	defl_ator
deflect	13	39	997	2	deflect__
deflected	16	3	598	2	deflected
deflection	16	14	773	2	deflection
deflects	14	33	673	2	deflect_s
detector	11	27	832	2	de_tector
effector	16	4	487	2	_effector
elector	9	33	1325	2	_e_lector
inflector	14	6	534	2	inflector
neglector	12	5	343	2	neglector
reflectors	15	4	550	2	reflectors
selector	10	4	860	2	se_lector
collector	13	4	639	3	collector
defalcator	16	4	317	3	defalcator
defeater	12	26	1166	3	def_eater
defecators	16	5	625	3	def_ecators
defect	12	48	1617	3	def_ect__
defected	15	28	997	3	def_ected
defection	15	16	1064	3	def_ection
defects	13	45	1152	3	def_ect_s
deflater	12	32	1160	3	defl_ater
deflators	13	34	815	3	defl_ators
deflecting	17	3	650	3	deflecting
deflections	17	18	732	3	deflections
deflective	19	5	609	3	deflective
deflexion	20	4	282	3	deflexion
defoliator	14	4	418	3	defoliator
delator	8	30	1502	3	de_l_ator
delegator	11	4	624	3	de_legator
depictor	13	5	551	3	de_pictor
depleter	11	29	885	3	deple_ter
detecter	11	29	873	3	de_tecter
detectors	12	27	830	3	de_tectors
detractor	12	14	721	3	detractor
director	11	4	777	3	d_irector
dissector	12	4	551	3	dissector
effecter	16	6	477	3	_effecter
effectors	17	5	503	3	_effectors
ejector	16	37	860	3	_e_jector
electors	10	30	1384	3	_e_lectors
electro	9	28	1003	3	_e_lectro
erector	9	35	1380	3	_e_rector
infector	13	47	884	3	inf_ector
inflectors	15	4	520	3	inflectors
inflictor	14	4	401	3	inflictor
lector	8	35	1498	3	___lector
neglecter	12	6	363	3	neglecter
neglectors	13	6	353	3	neglectors
prelector	13	4	809	3	prelector
refectory	17	4	602	3	ref_ectory
reflect	12	39	1371	3	reflect__
reflected	15	4	798	3	reflected
reflection	15	16	899	3	reflection
reflects	13	28	887	3	reflect_s
refractor	14	15	632	3	refractor
rejector	17	23	772	3	re_jector
selectors	11	4	895	3	se_lectors

Search took 7 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.173	1032896.0
2	DLD Change Limit	148641	63	6.500	22867.8
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	6.703	26658.4