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

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

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
crested	10	34	1655	(None)
chested	13	38	1168	1	chested
created	10	43	2346	1	created
crusted	10	37	1276	1	crusted
rested	7	44	3078	1	_rested
wrested	11	34	1093	1	wrested
arrested	9	3	917	2	arrested
bested	9	49	2276	2	_bested
breasted	11	3	882	2	breasted
caressed	11	3	917	2	caressed
cerated	10	39	2247	2	cerated
cessed	9	46	1561	2	c_essed
cheated	13	44	1635	2	cheated
cisted	9	52	1752	2	c_isted
cleated	10	34	1785	2	cleated
clefted	13	32	676	2	clefted
coasted	10	40	1596	2	coasted
corseted	11	3	1147	2	corseted
costed	9	56	2312	2	c_osted
crafted	13	41	977	2	crafted
crashed	13	42	1421	2	crashed
crated	9	48	2777	2	cr_ated
creaked	14	34	1323	2	creaked
creamed	12	39	1371	2	creamed
creased	10	43	1559	2	creased
create	8	51	2638	2	create_
creates	9	52	2520	2	creates
credited	12	3	825	2	credited
creed	8	57	2739	2	cre__ed
creeled	10	40	1201	2	creeled
creeped	12	32	971	2	creeped
creeshed	14	3	570	2	creeshed
cremated	13	34	1296	2	cremated
crenated	11	30	1391	2	crenated
creosoted	12	4	404	2	creosoted
creped	11	41	1572	2	cre_ped
cresses	9	42	1981	2	cresses
cresset	9	33	1994	2	cresset
crest	7	46	3269	2	crest__
crestal	9	3	1213	2	crestal
crests	8	52	1870	2	crest_s
crewed	12	53	1656	2	cre_wed
crisped	12	40	1011	2	crisped
crossed	10	53	1390	2	crossed
crushed	13	41	1197	2	crushed
curetted	11	3	717	2	curetted
dressed	9	35	1187	2	dressed
egested	9	3	812	2	egested
erected	10	32	1399	2	erected
forested	12	3	1246	2	forested
freshed	14	33	1259	2	freshed
fretted	11	34	1185	2	fretted
frosted	11	32	1188	2	frosted
greeted	9	31	1138	2	greeted
guested	9	15	771	2	guested
jested	14	44	1650	2	_jested
nested	7	47	2007	2	_nested
oersted	8	3	956	2	oersted
pressed	10	33	1731	2	pressed
prester	9	35	1962	2	prester
priested	11	3	839	2	priested
quested	17	16	839	2	quested
reested	8	29	1623	2	reested
rented	7	44	2659	2	_rented
reseed	7	48	2329	2	_reseed
resited	8	51	2242	2	_resited
rester	6	38	3243	2	_rester
retted	7	48	2631	2	_retted
rusted	7	50	2092	2	_rusted
tested	7	44	2152	2	_tested
treated	8	36	1870	2	treated
tressed	8	37	1426	2	tressed
trusted	8	34	1279	2	trusted
trysted	11	42	827	2	trysted
unrested	9	19	1452	2	unrested
vested	10	42	1735	2	_vested
wrester	10	28	1241	2	wrester
wrestled	12	29	676	2	wrestled
zested	16	42	1404	2	_zested

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	107671	0.390	458182.1
2	DLD Change Limit	107671	79	3.236	33272.9
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	3.656	48876.1