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

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

75 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
prededucted	18	5	233	(None)
prededuct	15	4	310	2	prededuct__
prededucts	16	4	222	2	prededuct_s
deducted	13	5	624	3	___deducted
prededucting	19	5	255	3	prededucting
predicted	15	3	891	3	pr__edicted
preedited	13	3	763	3	pre_ed_ited
preelected	15	4	578	3	pre_elected
preenacted	15	4	497	3	pre_enacted
preerected	15	4	557	3	pre_erected
prelected	14	3	913	3	prele__cted
preselected	16	4	396	3	preselected
rededicated	16	14	481	3	_rededicated
redefected	17	4	385	3	_redefected
reeducated	14	8	482	3	_re_educated
reinducted	14	6	441	3	_reinducted
adducted	13	4	391	4	__ad_ducted
deduced	12	6	668	4	___deduc_ed
overeducated	19	5	435	4	overeducated
perfected	17	3	664	4	perfe__cted
perpetuated	16	5	375	4	perpetuated
persecuted	15	4	350	4	persecu_ted
praelected	15	4	439	4	pr_aelected
preacted	13	27	1094	4	pr__e_acted
preadapted	16	4	373	4	pre_adapted
preadjusted	22	5	235	4	preadjusted
preadopted	16	4	435	4	pre_adopted
preceded	14	3	829	4	preced___ed
precented	14	3	1069	4	prece__nted
predated	12	5	1327	4	pr__ed_ated
predebate	14	4	616	4	prede_bate_
predeceased	17	5	298	4	predeceased
predefined	17	4	427	4	prede_fined
predestined	15	4	518	4	predestined
predicated	16	4	914	4	pred_icated
predigested	16	5	307	4	predigested
preempted	16	4	468	4	pre_e_mpted
preexcited	22	4	350	4	pre_excited
preexisted	20	4	378	4	pre_existed
preheated	15	3	981	4	prehe__ated
prejudiced	23	4	254	4	prejudic_ed
premeditated	18	5	353	4	premeditated
prerequired	23	5	136	4	prerequired
presented	12	3	1163	4	prese__nted
pretested	12	14	911	4	prete__sted
pretexted	19	13	569	4	prete__xted
prevented	15	3	900	4	preve__nted
produced	14	5	607	4	pr__oduc_ed
projected	21	16	582	4	proje__cted
prosected	14	15	863	4	prose__cted
prosecuted	15	4	428	4	prosecu_ted
protected	14	15	865	4	prote__cted
readdicted	15	4	336	4	_readdicted
reconducted	17	4	428	4	_reconducted
redacted	12	4	1024	4	_r__edacted
rededicate	14	12	557	4	_rededicate_
rededicates	15	11	507	4	_rededicates
redefeated	15	4	488	4	_redefeated
redirected	14	4	477	4	_redirected
reduced	11	6	1032	4	_r__educ_ed
reedited	10	3	1008	4	_re_ed_ited
reeducate	12	8	549	4	_re_educate_
reeducates	13	7	519	4	_re_educates
reejected	19	5	509	4	_re_ejected
reelected	12	3	831	4	_re_elected
reenacted	12	3	685	4	_re_enacted
reerected	12	3	861	4	_re_erected
refected	14	23	1166	4	_refe__cted
reindicted	14	8	504	4	_reindicted
reinduced	13	7	460	4	_reinduc_ed
rejected	18	27	1011	4	_reje__cted
relucted	11	3	865	4	_r__elucted
remediated	14	4	655	4	_remediated
resected	11	25	1474	4	_rese__cted
reselected	13	4	563	4	_reselected

Search took 9 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.423	422437.4
2	DLD Change Limit	148819	75	8.343	17837.6
3	Display Results	75	75	0.046	1630.4
	(SQL Overall)	178691	75	8.812	20278.1