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

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

93 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
addicted	13	4	507	(None)
adducted	13	4	391	1	adducted
abdicated	15	4	701	2	abdicated
abducted	14	4	409	2	abducted
addict	10	7	1120	2	addict__
addicts	11	7	601	2	addict_s
adduced	12	7	435	2	adduc_ed
admitted	12	3	476	2	admitted
advected	15	3	453	2	advected
audited	9	3	903	2	audi_ted
indicted	12	4	920	2	indicted
readdicted	15	4	336	2	readdicted
abdicate	13	4	890	3	abdicate_
abdicates	14	4	815	3	abdicates
abduced	13	7	484	3	abduc_ed
abductee	13	4	478	3	abductee
acted	8	85	2173	3	a___cted
adapted	11	3	583	3	a_dapted
added	8	49	1843	3	add___ed
addible	11	23	606	3	addible_
addicting	14	8	507	3	addicting
addiction	13	14	601	3	addiction
addictive	16	4	456	3	addictive
addled	9	41	1251	3	add__led
adduce	10	7	645	3	adduc_e_
adducer	11	8	416	3	adduc_er
adduces	11	8	576	3	adduc_es
adduct	10	8	737	3	adduct__
adductor	12	4	346	3	adductor
adducts	11	7	460	3	adduct_s
adhibited	16	4	247	3	adhibited
adjudicated	23	5	191	3	adjudicated
adjusted	17	4	360	3	adjusted
admired	11	3	570	3	admi_red
admittee	11	4	513	3	admittee
admitter	11	3	511	3	admitter
admixed	18	3	373	3	admi_xed
adopted	11	3	625	3	a_dopted
adulated	10	3	975	3	adulated
adverted	13	3	610	3	adverted
advice	12	10	788	3	advic_e_
advices	13	13	693	3	advic_es
advised	12	13	604	3	advi_sed
advocated	16	4	464	3	advocated
affected	17	4	479	3	affected
afflicted	18	4	343	3	afflicted
agisted	9	3	820	3	a_gisted
airted	7	42	1450	3	a__irted
anointed	9	3	834	3	anointed
anticked	15	3	839	3	anticked
arointed	9	3	900	3	arointed
articled	11	3	706	3	articled
assisted	9	3	622	3	assisted
astricted	12	4	743	3	astricted
audibled	12	22	409	3	audibled
auditee	8	3	1157	3	audi_tee
auricled	11	13	570	3	auricled
aviated	11	3	1026	3	a_viated
awaited	11	4	696	3	awai_ted
caddice	13	32	773	3	caddic_e_
caddices	14	29	785	3	caddic_es
caddied	12	37	1056	3	caddi__ed
caddised	13	31	589	3	caddi_sed
dedicated	14	3	1025	3	dedicated
deducted	13	5	624	3	deducted
deiced	10	42	1448	3	_deic_ed
depicted	14	3	774	3	depicted
diced	9	58	2468	3	__dic_ed
dicked	14	49	2086	3	__dicked
dieted	8	31	1549	3	__dieted
dinted	8	44	1984	3	__dinted
doited	8	50	1663	3	_doi_ted
drifted	12	36	795	3	_drifted
ducted	10	40	1212	3	__ducted
eddied	9	24	832	3	eddi__ed
edited	8	39	1367	3	_edi_ted
endited	9	35	1291	3	endi_ted
evicted	13	3	724	3	_evicted
indicated	13	3	1095	3	indicated
indictee	11	4	962	3	indictee
indicter	11	4	814	3	indicter
indited	9	35	1502	3	indi_ted
inducted	12	3	727	3	inducted
maledicted	16	4	254	3	maledicted
mediated	12	30	1187	3	mediated
medicated	15	4	1007	3	medicated
paddocked	20	4	208	3	paddocked
pedicled	14	3	645	3	pedicled
predicted	15	3	891	3	predicted
radiated	10	25	1259	3	radiated
radicated	13	4	1012	3	radicated
redacted	12	4	1024	3	redacted
waddied	13	35	856	3	waddi__ed

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	146162	0.170	1051123.5
2	DLD Change Limit	146162	93	7.283	20068.9
3	Display Results	93	93	0.046	2021.7
	(SQL Overall)	178691	93	7.499	23828.6