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

Here are the results of your fuzzy-string dictionary search for “descry” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

263 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
descry	12	5	618	(None)
decry	11	55	1435	1	de_cry
deary	9	58	2684	2	de_ary
decay	11	47	1848	2	de_cay
decoy	11	57	1631	2	de_coy
decury	12	7	796	2	decury
denary	10	53	1686	2	denary
derry	9	47	2137	2	de_rry
desert	7	27	2549	2	desert
desire	7	4	1530	2	desire
desorb	9	52	1020	2	desorb
desoxy	17	4	462	2	desoxy
destroy	11	3	815	2	destroy
scry	9	60	1776	2	__scry
vestry	12	3	862	2	vestry
aery	7	72	3168	3	ae__ry
beachy	16	40	1125	3	beachy
beechy	16	39	750	3	beechy
beery	10	52	2012	3	be_ery
belfry	14	3	507	3	belfry
berry	10	45	2177	3	be_rry
cedary	12	41	960	3	cedary
celery	11	3	962	3	celery
cesura	8	3	876	3	cesura
cry	8	97	2624	3	___cry
dairy	9	70	1630	3	d_airy
dashy	12	56	1238	3	das_hy
datary	10	3	1024	3	datary
daubry	12	44	548	3	daubry
deacon	9	5	1042	3	deacon
deaconry	14	4	332	3	deaconry
deadly	11	38	1147	3	deadly
deafly	13	38	912	3	deafly
deair	6	58	1719	3	deair_
deairs	7	40	1378	3	deairs
deanery	11	3	761	3	deanery
dear	5	53	4360	3	de_ar_
dearly	10	46	1532	3	dearly
dears	6	57	3688	3	de_ars
deathy	13	42	1023	3	deathy
debar	8	55	1786	3	debar_
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
decaf	11	49	1944	3	de_caf
decal	8	55	2323	3	de_cal
decare	9	39	1915	3	decare
decays	12	46	1291	3	de_cays
decern	9	13	1095	3	decern
deck	11	58	2775	3	de_c_k
decks	12	48	2219	3	de_cks
deco	7	61	2597	3	de_c_o
decor	8	47	1757	3	de_cor
decors	9	40	1777	3	decors
decos	8	55	2212	3	de_cos
decoys	12	39	1128	3	de_coys
decree	9	31	1778	3	de_cree
decrypt	15	4	570	3	de_crypt
deedy	10	43	1589	3	de_edy
deejay	17	3	452	3	deejay
deeply	12	5	701	3	deeply
deer	5	67	3902	3	de_er_
deers	6	49	3052	3	de_ers
defer	9	46	1975	3	defer_
defers	10	51	1694	3	defers
deform	12	5	962	3	deform
defray	13	3	764	3	defray
deftly	13	3	653	3	deftly
defy	11	49	2126	3	de__fy
degerm	10	3	789	3	degerm
dehorn	10	43	965	3	dehorn
dehort	10	46	1810	3	dehort
deice	8	43	2003	3	deic_e
deiced	10	42	1448	3	deiced
deicer	9	41	1441	3	deicer
deicers	10	36	1273	3	deicers
deices	9	41	1937	3	deices
deify	12	41	1276	3	de_ify
deity	9	43	1677	3	de_ity
dekare	11	28	1156	3	dekare
delay	9	48	2063	3	de_lay
delly	9	60	2387	3	de_lly
delusory	12	7	300	3	delusory
demark	13	42	1102	3	demark
demur	8	3	1116	3	demur_
demure	9	3	1153	3	demure
demurs	9	3	977	3	demurs
demy	10	54	2285	3	de__my
denar	6	52	2329	3	denar_
denari	7	109	1735	3	denari
denars	7	46	2143	3	denars
densely	11	4	671	3	densely
denser	7	41	1519	3	denser_
densify	14	3	529	3	densify
density	11	3	758	3	density
deny	8	60	2712	3	de__ny
deoxy	16	4	888	3	de_oxy
depart	9	47	2056	3	depart
deperm	11	3	936	3	deperm
deploy	12	3	758	3	deploy
deport	9	49	2239	3	deport
deputy	12	42	671	3	deputy
deray	9	50	2418	3	de_ray
derby	11	47	1534	3	de_rby
dere	5	68	4590	3	de__re
derisory	12	4	516	3	derisory
derm	7	60	3189	3	de__rm
desalt	7	5	1831	3	desalt
desand	8	48	1263	3	desand
descant	10	43	1559	3	descant
descend	11	24	815	3	descend
descent	10	26	1629	3	descent
describe	13	4	624	3	describe
descried	12	4	807	3	descried
descrier	11	5	762	3	descrier
descries	11	3	1192	3	descries
descrying	16	3	510	3	descry~~ing~~
deserts	8	25	1305	3	deserts
deserve	11	10	870	3	deserve
desex	13	3	1198	3	des_ex
design	8	40	893	3	design
desired	9	3	1198	3	desired
desirer	8	3	1078	3	desirer
desires	8	13	1613	3	desires
desist	7	48	1881	3	desist
desk	9	56	1890	3	des__k
desks	10	59	1307	3	des_ks
desman	9	3	1169	3	desman
desmid	10	4	836	3	desmid
desorbs	10	43	771	3	desorbs
despot	9	34	1329	3	despot
dessert	8	29	1645	3	dessert
destiny	11	31	1146	3	destiny
destroys	12	3	669	3	destroys
deter	6	50	2804	3	deter_
deters	7	47	2468	3	deters
deuce	8	45	1749	3	deuc_e
deuced	10	41	1212	3	deuced
deuces	9	40	1551	3	deuces
devilry	14	3	397	3	devilry
dewar	9	58	1773	3	dewar_
dewars	10	51	1707	3	dewars
dewily	13	3	834	3	dewily
deworm	12	4	953	3	deworm
dewy	11	54	1902	3	de__wy
dextro	14	3	612	3	dextro
dexy	15	61	1855	3	de__xy
dey	7	72	4337	3	de___y
diary	9	50	1697	3	d_iary
dicey	11	48	1933	3	d_icey
dicky	15	48	1624	3	d_icky
dicty	11	51	1629	3	d_icty
dietary	11	5	866	3	dietary
disarm	9	3	1047	3	disarm
disc	7	61	2323	3	disc__
discard	11	3	1021	3	discard
disced	10	49	1465	3	disced
discern	10	3	849	3	discern
disci	8	58	1502	3	disc_i
disco	8	56	1607	3	disc_o
discord	11	3	999	3	discord
discos	9	49	1521	3	discos
discs	8	53	1626	3	disc_s
discus	9	45	1211	3	discus
dishy	12	57	1235	3	dis_hy
dismay	12	22	947	3	dismay
dory	8	58	3623	3	d__ory
doser	6	62	2856	3	doser_
dosers	7	57	2363	3	dosers
dowery	13	43	1166	3	dowery
dowry	12	63	1248	3	d_owry
dreary	10	46	1167	3	dreary
drecky	16	48	633	3	drecky
dressy	10	51	814	3	dres_sy
dry	7	65	2603	3	d___ry
duchy	14	43	1087	3	d_uchy
ducky	15	42	1611	3	d_ucky
dupery	12	37	874	3	dupery
dusky	13	52	1304	3	dus_ky
dusty	9	60	1832	3	dus_ty
ecru	6	58	1953	3	_e_cru
eery	7	61	2962	3	_e_ery
emery	10	48	1433	3	_emery
entry	8	24	1426	3	_entry
escar	7	40	1199	3	_escar
escarp	10	44	900	3	_escarp
escars	8	39	1313	3	_escars
escort	8	46	1648	3	_escort
escot	7	53	2008	3	_escot
escrow	11	3	591	3	_escrow
espy	9	6	937	3	_es_py
essay	8	6	762	3	_essay
estray	9	57	1333	3	_estray
every	11	52	1545	3	_every
eyry	10	63	1588	3	_e_yry
ferry	11	60	2080	3	fe_rry
fescue	11	3	749	3	fescue
gentry	10	34	1044	3	gentry
henry	11	40	1447	3	he_nry
herry	11	49	2247	3	he_rry
jerry	15	50	1618	3	je_rry
kerry	12	49	1609	3	ke_rry
leachy	14	41	973	3	leachy
leary	8	59	2738	3	le_ary
leery	8	59	1913	3	le_ery
memory	13	3	880	3	memory
menschy	17	35	401	3	menschy
mercery	14	39	762	3	mercery
mercury	14	36	489	3	mercury
mercy	12	59	1618	3	merc_y
merry	10	47	2148	3	me_rry
mescal	10	41	1349	3	mescal
meshy	13	56	1278	3	mes_hy
messy	10	49	1383	3	mes_sy
misery	11	41	1354	3	misery
muscly	13	3	745	3	muscly
outcry	11	3	799	3	outcry
pastry	11	49	1303	3	pastry
peachy	16	45	1084	3	peachy
peccary	16	3	628	3	peccary
pecky	16	55	1509	3	pe_cky
peery	10	57	1944	3	pe_ery
peltry	11	28	865	3	peltry
penury	11	4	810	3	penury
perry	10	52	2271	3	pe_rry
pesky	14	59	1156	3	pes_ky
pessary	12	4	687	3	pessary
pesty	10	64	2171	3	pes_ty
piscary	14	3	742	3	piscary
rebury	11	34	921	3	rebury
redry	9	43	1436	3	re_dry
reechy	14	36	782	3	reechy
refry	11	44	1246	3	re_fry
resay	8	53	2054	3	res_ay
rescore	9	56	1620	3	rescore
rescue	8	3	1300	3	rescue
resiny	9	46	1736	3	resiny
resorb	8	49	1435	3	resorb
resort	6	57	2862	3	resort
respray	12	3	650	3	respray
retry	8	47	1808	3	re_try
revery	12	40	1421	3	revery
rosary	9	28	1035	3	rosary
rosery	9	38	1328	3	rosery
scary	10	52	2259	3	__scary
senary	9	37	1607	3	senary
sensory	10	32	909	3	sensory
sentry	9	29	1205	3	sentry
serry	8	48	2412	3	se_rry
spry	9	68	1912	3	__spry
teary	8	51	2405	3	te_ary
techy	13	56	1201	3	te_chy
terry	8	47	2187	3	te_rry
testy	8	54	1906	3	tes_ty
tetchy	14	3	600	3	tetchy
usury	8	8	762	3	_usury
veery	11	58	1625	3	ve_ery
velcro	11	4	413	3	velcro
venery	12	37	1066	3	venery
very	10	80	2564	3	ve__ry
wastry	12	38	877	3	wastry
weary	11	56	2061	3	we_ary
yechy	16	51	908	3	ye_chy
zesty	17	65	1216	3	zes_ty

Search took 6 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	112716	0.390	458182.1
2	DLD Change Limit	112716	263	5.406	20850.2
3	Display Results	263	263	0.093	2828.0
	(SQL Overall)	178691	263	5.889	30343.2