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

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

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

351 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
deles	6	51	3925	(None)
dales	6	64	3974	1	dales
dees	5	63	5663	1	de_es
dekes	10	52	2445	1	dekes
dele	5	68	4308	1	dele_
deled	7	53	2654	1	deled
delfs	9	49	1867	1	delfs
delis	6	49	2854	1	delis
dells	6	66	3094	1	dells
dels	5	67	4547	1	del_s
delts	6	57	3179	1	delts
delves	10	49	1708	1	delves
demes	8	60	3269	1	demes
denes	6	56	3972	1	denes
dexes	13	52	2451	1	dexes
doles	6	78	4375	1	doles
peles	7	57	3808	1	peles
teles	5	45	3600	1	teles
abeles	8	47	1939	2	abeles
ables	7	59	3554	2	ables
addles	8	42	1660	2	addles
aedes	6	46	2514	2	aedes
ales	4	70	6710	2	_ales
aneles	6	46	2629	2	aneles
arles	5	67	3574	2	arles
axles	12	52	1947	2	axles
bales	7	62	5008	2	bales
bees	6	54	5338	2	be_es
belies	8	46	3105	2	belies
belles	8	53	2599	2	belles
bells	7	64	3216	2	bells
bels	6	61	4249	2	bel_s
belts	7	59	3116	2	belts
benes	7	55	3623	2	benes
beses	7	58	3072	2	beses
biles	7	55	4214	2	biles
boles	7	54	4860	2	boles
cedes	8	49	2732	2	cedes
cees	6	59	4159	2	ce_es
celeb	9	3	1487	2	celeb
celebs	10	3	788	2	celebs
cells	7	54	2806	2	cells
cels	6	55	3497	2	cel_s
celts	7	53	2578	2	celts
cepes	9	44	2446	2	cepes
ceres	7	55	4001	2	ceres
cetes	7	57	3110	2	cetes
coles	7	60	5506	2	coles
daces	8	50	3068	2	daces
dale	5	56	4398	2	dale_
dalles	7	42	2206	2	dalles
dals	5	71	4512	2	dal_s
dames	8	54	3585	2	dames
dares	6	61	4670	2	dares
dates	6	56	3915	2	dates
dazes	15	50	2414	2	dazes
deads	7	57	2691	2	deads
dealer	7	41	2214	2	dealer
dealers	8	41	1861	2	dealers
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dears	6	57	3688	2	dears
deaves	10	53	1953	2	deaves
debs	7	65	3024	2	de_bs
debts	8	64	1837	2	debts
debyes	12	3	810	2	debyes
deciles	10	44	1772	2	deciles
deckles	14	33	1280	2	deckles
decks	12	48	2219	2	decks
decos	8	55	2212	2	decos
dee	4	76	6582	2	de_e_
deed	6	53	4090	2	de_ed
deeds	7	54	2376	2	deeds
deem	7	54	3289	2	de_em
deems	8	54	2177	2	deems
deep	7	60	3188	2	de_ep
deeps	8	49	2177	2	deeps
deer	5	67	3902	2	de_er
deers	6	49	3052	2	deers
deet	5	73	5658	2	de_et
deets	6	53	3024	2	deets
defer	9	46	1975	2	defer
defers	10	51	1694	2	defers
defies	10	46	2405	2	defies
defiles	11	40	1684	2	defiles
defis	9	67	1750	2	defis
deflea	10	3	744	2	deflea
defleas	11	4	722	2	defleas
degas	7	51	1916	2	degas
deices	9	41	1937	2	deices
deils	6	57	2286	2	deils
deke	9	52	2876	2	deke_
deked	11	57	1853	2	deked
del	4	67	5275	2	del__
delates	8	35	2628	2	delates
delay	9	48	2063	2	delay
delays	10	40	1405	2	delays
delead	8	41	1234	2	delead
deleads	9	37	970	2	deleads
delete	7	36	2070	2	delete
deletes	8	31	1793	2	deletes
delf	8	54	3657	2	del_f
delft	9	56	2332	2	delft
delfts	10	43	967	2	delfts
deli	5	56	3129	2	del_i
delimes	10	3	1419	2	delimes
delish	10	52	1561	2	delish
delist	7	46	2505	2	delist
dell	5	69	3820	2	del_l
dellies	8	36	2221	2	dellies
delly	9	60	2387	2	delly
delt	5	78	5527	2	del_t
delta	6	61	1777	2	delta
deltas	7	44	1482	2	deltas
deludes	9	18	1064	2	deludes
deluges	9	16	926	2	deluges
delve	9	60	1826	2	delve
delved	11	41	1275	2	delved
delver	10	49	1349	2	delver
delvers	11	34	1199	2	delvers
deme	7	65	3628	2	deme_
demies	9	48	2580	2	demies
demos	8	60	2299	2	demos
dene	5	66	4341	2	dene_
denies	7	47	2964	2	denies
dens	5	59	4507	2	de_ns
dense	6	59	2350	2	dense
dents	6	50	3180	2	dents
dere	5	68	4590	2	dere_
derms	8	50	2289	2	derms
desex	13	3	1198	2	desex
desks	10	59	1307	2	desks
deter	6	50	2804	2	deter
deters	7	47	2468	2	deters
detest	7	41	2284	2	detest
deuces	9	40	1551	2	deuces
devas	9	62	1888	2	devas
devel	9	42	1712	2	devel
devels	10	43	1390	2	devels
devest	10	44	1870	2	devest
devs	8	64	2403	2	de_vs
dewed	10	50	2030	2	dewed
dewless	11	3	747	2	dewless
dews	8	62	3060	2	de_ws
dexies	14	50	1834	2	dexies
deys	8	50	2747	2	de_ys
dholes	10	49	1479	2	dholes
dices	8	64	3424	2	dices
dienes	7	57	1990	2	dienes
dies	5	56	5352	2	d_ies
dieses	7	52	1869	2	dieses
dikes	10	58	3133	2	dikes
dills	6	55	3097	2	dills
dimes	8	58	3304	2	dimes
dines	6	64	4915	2	dines
dites	6	63	3915	2	dites
dives	9	58	3240	2	dives
does	5	65	5447	2	d_oes
doges	7	56	3016	2	doges
dole	5	65	5000	2	dole_
doled	7	54	3091	2	doled
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	dol_s
dolts	6	56	2631	2	dolts
domes	8	57	3556	2	domes
dopes	8	49	3504	2	dopes
doses	6	59	3850	2	doses
dotes	6	58	3669	2	dotes
doves	9	47	2815	2	doves
dozes	15	52	2630	2	dozes
drees	6	56	2852	2	drees
dries	6	47	3367	2	dries
duces	8	63	2747	2	duces
dudes	7	54	2437	2	dudes
dueled	8	48	1366	2	dueled
dueler	7	42	1368	2	dueler
duelers	8	34	1205	2	duelers
duels	6	56	1923	2	duel_s
dues	5	60	4550	2	d_ues
dukes	10	50	2347	2	dukes
dulls	6	45	2374	2	dulls
dulse	6	54	1504	2	dulse
dulses	7	39	1365	2	dulses
dunes	6	53	3217	2	dunes
dupes	8	64	2593	2	dupes
dures	6	56	3592	2	dures
dwells	10	41	771	2	dwells
dyes	8	53	3189	2	d_yes
dykes	13	52	1557	2	dykes
dynes	9	59	1758	2	dynes
edges	7	57	1872	2	edges
ediles	7	40	1698	2	ediles
eels	4	65	3674	2	eel_s
ekes	8	67	2660	2	_ekes
elds	5	63	2485	2	_elds
elks	8	58	2003	2	_elks
ells	4	64	3135	2	_ells
elms	6	73	2270	2	_elms
els	3	76	4572	2	_el_s
else	4	59	2308	2	_else
elves	8	51	1874	2	_elves
emes	6	54	3466	2	_emes
eses	4	53	3610	2	_eses
eves	7	62	3046	2	_eves
ewes	7	63	2870	2	_ewes
exes	11	65	3081	2	_exes
eyes	7	58	3788	2	_eyes
feces	10	56	2536	2	feces
feels	8	52	2304	2	feels
fees	7	64	5060	2	fe_es
fells	8	53	2738	2	fells
felts	8	53	2454	2	felts
femes	10	56	2622	2	femes
feres	8	60	3818	2	feres
fetes	8	56	3014	2	fetes
fezes	17	52	2002	2	fezes
files	8	54	4127	2	files
flees	8	58	2875	2	flees
gales	6	54	4248	2	gales
gees	5	56	4788	2	ge_es
gelds	7	51	1834	2	gelds
gelee	6	36	2698	2	gelee
gelees	7	41	1626	2	gelees
gels	5	68	3610	2	gel_s
gelts	6	59	2461	2	gelts
genes	6	51	3309	2	genes
glees	6	50	2759	2	glees
gules	6	48	3104	2	gules
hales	8	54	4984	2	hales
hebes	10	55	2167	2	hebes
heels	8	56	2553	2	heels
hells	8	50	3204	2	hells
helms	10	56	1946	2	helms
helos	8	49	2806	2	helos
helps	10	52	1934	2	helps
helves	12	43	1606	2	helves
hemes	10	50	3108	2	hemes
heres	8	62	4590	2	heres
hexes	15	51	2304	2	hexes
holes	8	47	4865	2	holes
idles	6	67	2012	2	idles
isles	5	42	2056	2	isles
jees	11	59	3854	2	je_es
jefes	15	56	1367	2	jefes
jells	12	55	2216	2	jells
jetes	12	49	2284	2	jetes
joles	12	52	3083	2	joles
kales	9	57	3098	2	kales
keels	9	46	2241	2	keels
kelep	11	60	1455	2	kelep
keleps	12	47	881	2	keleps
kelps	11	51	1642	2	kelps
kelts	9	52	2263	2	kelts
kexes	16	62	1681	2	kexes
lees	4	54	5588	2	le_es
leges	6	44	2728	2	leges
lenes	5	47	3852	2	lenes
les	3	56	6307	2	__les
leses	5	49	3081	2	leses
lexes	12	72	2526	2	lexes
males	7	50	4979	2	males
melds	8	48	2238	2	melds
melee	7	37	2910	2	melee
melees	8	36	1808	2	melees
mells	7	50	3133	2	mells
mels	6	59	4153	2	mel_s
melts	7	49	3010	2	melts
memes	9	49	2770	2	memes
meres	7	51	4357	2	meres
merles	8	53	2276	2	merles
metes	7	47	3621	2	metes
mezes	16	77	1926	2	mezes
miles	7	46	4507	2	miles
moles	7	47	4792	2	moles
mules	7	50	3429	2	mules
nenes	5	53	2967	2	nenes
neves	8	70	2187	2	neves
odyles	10	34	856	2	odyles
ogles	6	52	2318	2	ogles
oles	4	64	5347	2	_oles
orles	5	53	2621	2	orles
pales	7	57	5380	2	pales
pedes	8	53	2728	2	pedes
peels	7	52	2642	2	peels
pees	6	52	5737	2	pe_es
pekes	11	46	2356	2	pekes
pele	6	55	3955	2	pele_
pelfs	10	50	1629	2	pelfs
pelts	7	61	2881	2	pelts
pelves	11	45	1466	2	pelves
penes	7	58	3922	2	penes
peres	7	62	4664	2	peres
piles	7	47	4261	2	piles
poles	7	53	5100	2	poles
pules	7	45	3881	2	pules
rales	5	49	4749	2	rales
reales	6	49	3412	2	reales
redes	6	51	3912	2	redes
reels	5	53	3326	2	reels
rees	4	53	6419	2	re_es
reges	6	56	2878	2	reges
relet	5	47	4982	2	relet
relets	6	40	2567	2	relets
relies	6	50	3642	2	relies
rexes	12	45	2695	2	rexes
riles	5	53	4364	2	riles
roles	5	67	4798	2	roles
rules	5	52	3425	2	rules
sales	5	60	5559	2	sales
seels	5	56	3282	2	seels
sees	4	53	6105	2	se_es
selfs	8	52	2024	2	selfs
selles	6	44	2698	2	selles
sells	5	51	3443	2	sells
sels	4	63	4598	2	sel_s
selves	9	41	1961	2	selves
semes	7	57	3158	2	semes
seres	5	54	4889	2	seres
sexes	12	61	2622	2	sexes
soles	5	55	4792	2	soles
steles	6	37	2566	2	steles
tales	5	54	5137	2	tales
teels	5	57	2637	2	teels
tees	4	53	5358	2	te_es
tele	4	50	4087	2	tele_
telex	12	52	1482	2	telex
tells	5	58	2894	2	tells
telos	5	54	2452	2	telos
tels	4	68	4169	2	tel_s
tiles	5	55	4210	2	tiles
toles	5	51	4713	2	toles
tules	5	45	3279	2	tules
vales	8	54	3426	2	vales
vees	7	54	3943	2	ve_es
veges	9	41	1886	2	veges
velds	9	56	1558	2	velds
vexes	15	57	1912	2	vexes
voles	8	62	3404	2	voles
wales	8	61	4283	2	wales
wees	7	62	4912	2	we_es
welds	9	47	1916	2	welds
wells	8	54	2619	2	wells
welts	8	52	2519	2	welts
wiles	8	54	3787	2	wiles
wyles	11	46	1532	2	wyles
yelks	12	64	1362	2	yelks
yells	8	58	2194	2	yells
yelps	10	57	1299	2	yelps
yeses	8	51	1932	2	yeses
yules	8	45	2158	2	yules
zees	13	63	3189	2	ze_es

Search took 2 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	53800	0.080	2233637.5
2	DLD Change Limit	53800	351	1.530	35163.4
3	Display Results	351	351	0.110	3190.9
	(SQL Overall)	178691	351	1.720	103890.1