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

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

342 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
dele	5	68	4308	(None)
dale	5	56	4398	1	dale
dee	4	76	6582	1	de_e
deke	9	52	2876	1	deke
del	4	67	5275	1	del_
deled	7	53	2654	1	deled
deles	6	51	3925	1	deles
delf	8	54	3657	1	delf
deli	5	56	3129	1	deli
dell	5	69	3820	1	dell
dels	5	67	4547	1	dels
delt	5	78	5527	1	delt
delve	9	60	1826	1	delve
deme	7	65	3628	1	deme
dene	5	66	4341	1	dene
dere	5	68	4590	1	dere
dole	5	65	5000	1	dole
pele	6	55	3955	1	pele
tele	4	50	4087	1	tele
abele	7	63	2325	2	abele
able	6	63	4053	2	able
addle	7	43	1835	2	addle
ale	3	65	7234	2	_ale
alee	4	66	5232	2	alee
anele	5	56	2883	2	anele
axle	11	64	2460	2	axle
bale	6	63	5384	2	bale
bee	5	62	6240	2	be_e
bel	5	71	4846	2	bel_
belie	7	56	3038	2	belie
bell	6	62	3718	2	bell
belle	7	58	2783	2	belle
bels	6	61	4249	2	bels
belt	6	57	5403	2	belt
bene	6	64	3949	2	bene
bile	6	61	4718	2	bile
bole	6	64	4869	2	bole
cede	7	49	2877	2	cede
cee	5	59	5270	2	ce_e
cel	5	60	4055	2	cel_
celeb	9	3	1487	2	celeb
cell	6	50	3172	2	cell
cels	6	55	3497	2	cels
celt	6	56	4671	2	celt
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
cole	6	69	5611	2	cole
dace	7	69	3492	2	dace
dal	4	75	5495	2	dal_
dales	6	64	3974	2	dales
dals	5	71	4512	2	dals
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
de	3	70	4954	2	d__e
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dealer	7	41	2214	2	dealer
deals	6	54	3534	2	deals
dealt	6	52	3428	2	dealt
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deave	9	50	2233	2	deave
deb	6	63	4269	2	de_b
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
debye	11	3	890	2	debye
decile	9	46	1921	2	decile
deck	11	58	2775	2	deck
deckle	13	120	1245	2	deckle
deco	7	61	2597	2	deco
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
def	7	65	4672	2	de_f
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
defile	10	52	1666	2	defile
deflea	10	3	744	2	deflea
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
deice	8	43	2003	2	deice
deil	5	62	3162	2	deil
deils	6	57	2286	2	deils
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
delate	7	38	2775	2	delate
delay	9	48	2063	2	delay
delead	8	41	1234	2	delead
delete	7	36	2070	2	delete
delfs	9	49	1867	2	delfs
delft	9	56	2332	2	delft
delime	9	3	1404	2	delime
delis	6	49	2854	2	delis
dells	6	66	3094	2	dells
delly	9	60	2387	2	delly
delta	6	61	1777	2	delta
delts	6	57	3179	2	delts
delude	8	19	1067	2	delude
deluge	8	18	940	2	deluge
deluxe	14	19	730	2	deluxe
delved	11	41	1275	2	delved
delver	10	49	1349	2	delver
delves	10	49	1708	2	delves
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
den	4	75	5434	2	de_n
denes	6	56	3972	2	denes
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dense	6	59	2350	2	dense
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
derm	7	60	3189	2	derm
desex	13	3	1198	2	desex
desk	9	56	1890	2	desk
deter	6	50	2804	2	deter
deuce	8	45	1749	2	deuce
dev	7	60	3377	2	de_v
deva	8	57	2098	2	deva
devel	9	42	1712	2	devel
devs	8	64	2403	2	devs
dew	7	71	3992	2	de_w
dewed	10	50	2030	2	dewed
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
dex	11	69	3688	2	de_x
dexes	13	52	2451	2	dexes
dexie	13	47	1689	2	dexie
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	de_y
deys	8	50	2747	2	deys
dhole	9	52	1536	2	dhole
dice	7	58	4189	2	dice
die	4	67	5965	2	d_ie
diel	5	90	3460	2	diel_
diene	6	57	2013	2	diene
dike	9	59	3576	2	dike
dill	5	52	3997	2	dill
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
doe	4	73	6195	2	d_oe
doge	6	62	3380	2	doge
dol	4	71	5065	2	dol_
dolce	8	58	1668	2	dolce
doled	7	54	3091	2	doled
doles	6	78	4375	2	doles
doll	5	66	3249	2	doll
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
dome	7	72	4073	2	dome
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dore	5	63	5330	2	dore
dose	5	64	4243	2	dose
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
dree	5	66	3832	2	dree
duce	7	69	3350	2	duce
dude	6	56	2966	2	dude
due	4	52	4986	2	d_ue
duel	5	67	2970	2	duel_
dueled	8	48	1366	2	dueled
dueler	7	42	1368	2	dueler
duels	6	56	1923	2	duels
duke	9	56	2810	2	duke
dull	5	64	3044	2	dull
dulse	6	54	1504	2	dulse
duly	8	53	2303	2	duly
dune	5	61	3758	2	dune
dupe	7	66	3060	2	dupe
duple	8	53	1586	2	duple
dure	5	63	4181	2	dure
dwell	9	51	985	2	dwell
dwelt	9	43	1652	2	dwelt
dye	7	53	3484	2	d_ye
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
edge	6	57	1968	2	edge
edile	6	48	1949	2	edile
eel	3	79	4684	2	eel_
eels	4	65	3674	2	eels
eely	7	77	2521	2	eely
eke	7	56	3009	2	_eke
el	2	67	4529	2	_el_
eld	4	67	3379	2	_eld
elf	6	61	3852	2	_elf
elk	7	67	2612	2	_elk
ell	3	67	3568	2	_ell
elm	5	75	3174	2	_elm
els	3	76	4572	2	_els
else	4	59	2308	2	_else
eme	5	58	3718	2	_eme
ere	3	63	5277	2	_ere
eve	6	63	3116	2	_eve
ewe	6	66	3098	2	_ewe
eye	6	55	3977	2	_eye
fee	6	68	6201	2	fe_e
feel	7	52	3384	2	feel
fell	7	68	3307	2	fell
felt	7	51	4693	2	felt
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
file	7	54	4664	2	file
flee	7	62	3879	2	flee
gale	5	63	4732	2	gale
gee	4	53	5920	2	ge_e
gel	4	56	4243	2	gel_
geld	6	58	2843	2	geld
gelee	6	36	2698	2	gelee
gels	5	68	3610	2	gels
gelt	5	64	4801	2	gelt
gene	5	62	3722	2	gene
glee	5	52	3906	2	glee
hale	7	60	5283	2	hale
hebe	9	64	2470	2	hebe
heel	7	50	3422	2	heel
held	8	53	3040	2	held
hell	7	56	3789	2	hell
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
help	9	53	2892	2	help
helve	11	50	1809	2	helve
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hole	7	75	5339	2	hole
idle	5	54	2376	2	idle
isle	4	51	2170	2	isle
jee	10	66	4864	2	je_e
jefe	14	65	1688	2	jefe
jell	11	71	2587	2	jell
jete	11	59	2725	2	jete
jole	11	72	3382	2	jole
kale	8	65	3375	2	kale
keel	8	57	2947	2	keel
kelep	11	60	1456	2	kelep
kelp	10	53	2280	2	kelp
kelt	8	53	4319	2	kelt
lee	3	60	6814	2	le_e
leke	8	55	2740	2	leke
male	6	60	5230	2	male
mel	5	60	4748	2	mel_
meld	7	58	3047	2	meld
melee	7	37	2910	2	melee
mell	6	49	3561	2	mell
mels	6	59	4153	2	mels
melt	6	57	5289	2	melt
meme	8	53	3055	2	meme
mere	6	72	4444	2	mere
merle	7	58	2437	2	merle
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mile	6	63	5257	2	mile
mole	6	62	5183	2	mole
mule	6	52	3697	2	mule
nee	3	66	5778	2	ne_e
nene	4	59	3206	2	nene
neve	7	62	2483	2	neve
odyle	9	34	959	2	odyle
ogle	5	63	2505	2	ogle
ole	3	71	5521	2	_ole
orle	4	56	3046	2	orle
pale	6	60	5501	2	pale
pee	5	60	6651	2	pe_e
peel	6	55	3561	2	peel
peke	10	59	2620	2	peke
peles	7	57	3808	2	peles
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
pere	6	64	5026	2	pere
pile	6	56	4969	2	pile
pole	6	59	5130	2	pole
pule	6	50	4095	2	pule
rale	4	50	5056	2	rale
rede	5	50	3767	2	rede
ree	3	79	7407	2	re_e
reel	4	52	4053	2	reel
relet	5	47	4982	2	relet
rely	7	54	2895	2	rely
rete	4	49	4413	2	rete
rile	4	56	5053	2	rile
role	4	58	5182	2	role
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
see	3	57	7226	2	se_e
seel	4	50	4298	2	seel
sel	3	82	5332	2	sel_
self	7	51	3829	2	self
sell	4	58	4061	2	sell
selle	5	44	2831	2	selle
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
sole	4	60	5367	2	sole
stele	5	50	2684	2	stele
tale	4	61	5416	2	tale
tee	3	83	6687	2	te_e
teel	4	63	3580	2	teel
tel	3	56	4790	2	tel_
tela	4	55	3297	2	tela
telae	5	43	2329	2	telae
teles	5	45	3600	2	teles
telex	12	52	1482	2	telex
tell	4	49	3470	2	tell
tels	4	68	4169	2	tels
tile	4	54	5144	2	tile
tole	4	60	5290	2	tole
tule	4	57	3587	2	tule
vale	7	49	3734	2	vale
vee	6	57	5018	2	ve_e
vela	7	57	2554	2	vela
veld	8	53	2320	2	veld
vile	7	61	3980	2	vile
vole	7	52	3698	2	vole
wale	7	45	4643	2	wale
wee	6	67	6081	2	we_e
weel	7	58	3408	2	weel
weld	8	47	2773	2	weld
well	7	58	3204	2	well
welt	7	55	4786	2	welt
were	7	62	3833	2	were
wile	7	59	4437	2	wile
wyle	10	55	1938	2	wyle
yeld	8	114	2387	2	yeld
yelk	11	53	2000	2	yelk
yell	7	60	2832	2	yell
yelp	9	56	2135	2	yelp
yule	7	57	2514	2	yule
zee	12	61	4323	2	ze_e

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	29872	0.263	679433.5
2	DLD Change Limit	29872	342	0.766	38997.4
3	Display Results	342	342	0.076	4500.0
	(SQL Overall)	178691	342	1.105	161711.3