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

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

79 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
abdicated	15	4	701	(None)
abdicate	13	4	890	1	abdicate_
abdicates	14	4	815	1	abdicates
abdicator	14	4	626	2	abdicator
abducted	14	4	409	2	abduc_ted
addicted	13	4	507	2	addic_ted
dedicated	14	3	1025	2	dedicated
fabricated	18	4	540	2	fabricated
indicated	13	3	1095	2	indicated
medicated	15	4	1007	2	medicated
radicated	13	4	1012	2	radicated
abated	9	59	1845	3	ab___ated
abdicable	16	8	502	3	abdicable
abdicating	16	8	615	3	abdicating
abdication	15	4	822	3	abdication
abdicators	15	4	626	3	abdicators
abduced	13	7	484	3	abduc__ed
abductee	13	4	478	3	abduc_tee
aberrated	12	4	587	3	aberrated
ablated	10	25	1344	3	ab__lated
abnegated	13	4	416	3	abnegated
abominated	15	4	520	3	abominated
abreacted	14	4	429	3	abreacted
abrogated	13	12	671	3	abrogated
activated	15	6	788	3	activated
adducted	13	4	391	3	adduc_ted
adjudicated	23	5	191	3	adjudicated
adulated	10	3	975	3	a_dulated
advocated	16	4	464	3	advocated
affricated	19	4	385	3	affricated
agitated	10	3	841	3	a_gitated
allocated	12	4	809	3	allocated
animated	11	16	1237	3	a_nimated
aspirated	12	4	770	3	aspirated
audited	9	3	903	3	audi__ted
auspicated	15	4	430	3	auspicated
aviated	11	3	1026	3	a_vi_ated
baccated	15	14	837	3	_baccated
badinaged	14	11	319	3	badinaged
dedicate	12	3	1280	3	dedicate_
dedicatee	13	4	1034	3	dedicatee
dedicates	13	3	1169	3	dedicates
dictated	12	3	920	3	__dictated
dilated	9	31	1582	3	__dilated
educated	12	3	794	3	_educated
eradicated	14	4	687	3	eradicated
fabricate	16	4	683	3	fabricate_
fabricates	17	4	646	3	fabricates
imbricated	17	4	456	3	imbricated
indicate	11	3	1335	3	indicate_
indicates	12	3	1258	3	indicates
indicted	12	4	920	3	indic_ted
iodinated	11	4	694	3	iodinated
labiated	11	10	930	3	lab_i_ated
loricated	12	4	789	3	loricated
lubricated	15	4	503	3	lubricated
manducated	16	4	456	3	manducated
masticated	15	4	823	3	masticated
mediated	12	30	1187	3	medi_ated
medicate	13	5	1324	3	medicate_
medicates	14	3	1211	3	medicates
meditated	13	4	808	3	meditated
muricated	14	4	824	3	muricated
obligated	13	18	690	3	obligated
obviated	14	4	456	3	obvi_ated
plicated	13	3	1064	3	_plicated
predicated	16	4	914	3	predicated
radiated	10	25	1259	3	radi_ated
radicate	11	4	1287	3	radicate_
radicates	12	4	1207	3	radicates
redictated	14	4	748	3	redictated
rubricated	15	4	504	3	rubricated
sonicated	12	4	845	3	sonicated
spicated	13	30	990	3	_spicated
syndicated	17	4	374	3	syndicated
tunicated	12	25	749	3	tunicated
urticated	12	4	769	3	urticated
vesicated	15	11	765	3	vesicated
vindicated	17	4	512	3	vindicated

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	148641	0.420	425454.8
2	DLD Change Limit	148641	79	6.720	22119.2
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	7.186	24866.5