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

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

89 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
accessed	13	8	541	(None)
accesses	12	8	749	1	accesses
abscessed	14	4	270	2	abscessed
acceded	13	3	611	2	acce_ded
accented	13	10	779	2	accented
accepted	15	10	540	2	accepted
access	10	3	768	2	access__
accosted	13	4	553	2	accosted
accursed	13	5	463	2	accursed
accused	12	36	842	2	acc_used
assessed	9	4	502	2	assessed
caressed	11	3	917	2	caressed
cessed	9	46	1561	2	__cessed
excessed	18	4	494	2	excessed
recessed	11	3	972	2	recessed
abbesses	12	3	533	3	abbesses
abscesses	13	4	410	3	abscesses
accede	11	3	830	3	acce_de_
acceder	12	3	536	3	acce_der
accedes	12	3	772	3	acce_des
acceptee	14	10	574	3	acceptee
accepter	14	14	495	3	accepter
accessary	16	5	272	3	accessary
accessing	14	4	583	3	accessing
accession	13	4	523	3	accession
accessioned	16	5	250	3	access~~ion~~ed
accessory	16	4	332	3	accessory
accorded	14	15	536	3	accorded
accreted	13	3	634	3	accreted
accrued	12	3	382	3	acc_rued
accuse	10	34	1103	3	acc_use_
accuser	11	34	793	3	acc_user
accuses	11	41	1219	3	acc_uses
actresses	11	3	793	3	actresses
addressed	12	4	365	3	addressed
aggressed	12	4	420	3	aggressed
amassed	10	38	863	3	a_massed
ancresses	11	3	841	3	ancresses
appeased	13	3	579	3	appeased
appressed	14	4	594	3	appressed
arrested	9	3	916	3	arrested
ascended	12	4	651	3	ascended
asceses	9	3	862	3	asce_ses
aspersed	11	42	830	3	aspersed
assesses	7	3	738	3	assesses
attested	9	3	630	3	attested
blessed	10	31	949	3	_blessed
caresser	10	3	881	3	caresser
caresses	10	3	1406	3	caresses
caucussed	14	4	191	3	caucussed
ceased	9	49	2078	3	__ceased
censed	9	40	1632	3	__censed
cesses	8	42	2136	3	__cesses
chassed	13	47	1213	3	_chassed
cheesed	13	39	1068	3	_cheesed
chesses	12	41	1263	3	_chesses
chested	13	38	1167	3	_chested
classed	10	41	1365	3	_classed
creased	10	43	1559	3	_creased
cresses	9	42	1981	3	_cresses
cresset	9	33	1994	3	_cresset
crested	10	34	1654	3	_crested
crossed	10	53	1390	3	_crossed
cussed	9	49	1712	3	__cussed
deceased	12	4	772	3	deceased
dressed	9	35	1187	3	_dressed
egressed	10	4	688	3	egressed
excesses	17	3	675	3	excesses
fessed	10	45	1506	3	__fessed
finessed	12	13	679	3	finessed
focussed	14	17	404	3	focussed
guessed	9	17	660	3	_guessed
harnessed	13	18	620	3	harnessed
hocussed	14	15	379	3	hocussed
incensed	11	27	795	3	incensed
jessed	14	41	1230	3	__jessed
licensed	11	14	572	3	licensed
messed	9	50	1818	3	__messed
obsessed	11	4	427	3	obsessed
precessed	14	3	752	3	precessed
pressed	10	33	1731	3	_pressed
processed	14	4	680	3	processed
recesses	10	3	1232	3	recesses
schussed	14	4	305	3	schussed
stressed	9	12	854	3	stressed
successes	13	4	564	3	successes
succussed	14	4	339	3	succussed
tressed	8	37	1426	3	_tressed
yessed	10	45	1116	3	__yessed

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.423	422437.4
2	DLD Change Limit	146162	89	7.140	20470.9
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	7.609	23484.2