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

Here are the results of your fuzzy-string dictionary search for “defected” with Change Limit: [1] [2] [3]

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.

42 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
defected	15	28	997	(None)
defeated	13	28	1216	1	defeated
defecated	16	3	749	1	defecated
deflected	16	3	598	1	deflected
dejected	19	30	759	1	dejected
detected	12	28	973	1	detected
refected	14	23	1166	1	refected
affected	17	4	480	2	affected
decocted	14	3	769	2	decocted
deducted	13	5	624	2	deducted
defaced	14	29	1097	2	defac_ed
defatted	13	3	567	2	defatted
defeater	12	26	1166	2	defeater
defecate	14	3	879	2	defecate_
defecates	15	3	859	2	defecates
defect	12	48	1617	2	defect__
defector	14	27	795	2	defector
defects	13	45	1152	2	defect_s
defenced	15	3	720	2	defenced
defended	14	3	722	2	defended
defensed	13	3	622	2	defensed
deferred	13	10	636	2	deferred
deflated	13	34	1230	2	deflated
deleted	9	33	1491	2	dele_ted
demented	12	3	1127	2	demented
depicted	14	3	774	2	depicted
deserted	10	10	1220	2	deserted
detecter	11	29	873	2	detecter
detested	10	27	962	2	detested
devested	13	23	913	2	devested
directed	12	3	823	2	directed
effected	17	4	499	2	effected
ejected	17	29	765	2	_ejected
elected	10	28	1261	2	_elected
erected	10	32	1399	2	_erected
infected	14	22	940	2	infected
perfected	17	3	664	2	perfected
redefected	17	4	385	2	redefected
reflected	15	4	798	2	reflected
rejected	18	27	1011	2	rejected
resected	11	25	1474	2	resected
selected	11	5	978	2	selected

Search took 4 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	121059	0.390	458182.1
2	DLD Change Limit	121059	42	3.236	37410.1
3	Display Results	42	42	0.013	3230.8
	(SQL Overall)	178691	42	3.639	49104.4