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

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

361 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
dene	5	66	4341	(None)
bene	6	64	3949	1	bene
dee	4	76	6582	1	de_e
deke	9	52	2876	1	deke
dele	5	68	4308	1	dele
deme	7	65	3628	1	deme
den	4	75	5434	1	den_
denes	6	56	3972	1	denes
deni	5	69	2939	1	deni
dens	5	59	4507	1	dens
dense	6	59	2350	1	dense
dent	5	71	5841	1	dent
deny	8	60	2712	1	deny
dere	5	68	4590	1	dere
diene	6	57	2013	1	diene
dine	5	55	5533	1	dine
done	5	57	4791	1	done
dune	5	61	3758	1	dune
dyne	8	53	2093	1	dyne
gene	5	62	3722	1	gene
nene	4	59	3206	1	nene
sene	4	68	4805	1	sene
acne	6	66	2587	2	acne
agene	6	56	2158	2	agene
akene	9	58	1866	2	akene
ane	3	78	6695	2	_ane
arene	5	53	2941	2	arene
bane	6	52	5043	2	bane
bee	5	62	6240	2	be_e
been	6	53	3578	2	been
ben	5	65	5492	2	ben_
bend	7	64	3526	2	bend
benes	7	55	3623	2	benes
benne	7	65	2112	2	benne
bens	6	59	4570	2	bens
bent	6	77	5991	2	bent
bine	6	66	5086	2	bine
bone	6	59	4932	2	bone
cane	6	66	5312	2	cane
cede	7	49	2877	2	cede
cee	5	59	5270	2	ce_e
cense	7	51	2140	2	cense
cent	6	74	5101	2	cent
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
cine	6	62	4294	2	cine
cone	6	72	5696	2	cone
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dan	4	68	5967	2	dan_
dance	8	52	2313	2	dance
dang	6	51	3154	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
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
dean	5	60	3948	2	dean
deaned	8	46	2045	2	deaned
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear
deave	9	50	2233	2	deave
deb	6	63	4269	2	de_b
debone	9	37	1478	2	debone
debs	7	65	3024	2	debs
debt	7	71	3902	2	debt
debye	11	3	890	2	debye
decane	9	38	1887	2	decane
deck	11	58	2775	2	deck
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
define	10	47	1814	2	define
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
deice	8	43	2003	2	deice
deil	5	62	3162	2	deil
deked	11	57	1853	2	deked
dekes	10	52	2445	2	dekes
del	4	67	5275	2	de_l
deled	7	53	2654	2	deled
deles	6	51	3925	2	deles
delf	8	54	3657	2	delf
deli	5	56	3129	2	deli
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delt	5	78	5527	2	delt
delve	9	60	1826	2	delve
demes	8	60	3269	2	demes
demo	7	74	2755	2	demo
demy	10	54	2285	2	demy
denar	6	52	2329	2	denar
dengue	8	3	825	2	dengue
denied	8	43	1863	2	denied
denier	7	44	2069	2	denier
denies	7	47	2964	2	denies
denim	8	55	1884	2	denim
denned	8	42	1563	2	denned
denote	7	41	1804	2	denote
denser	7	41	1519	2	denser
dented	8	41	2051	2	dented
dents	6	50	3180	2	dents
denude	8	16	935	2	denude
depone	9	36	1655	2	depone
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
dice	7	58	4189	2	dice
die	4	67	5965	2	d_ie
dienes	7	57	1990	2	dienes
dike	9	59	3576	2	dike
dime	7	62	3764	2	dime
din	4	64	5946	2	din_
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
ding	6	69	4095	2	ding
dinge	7	56	2730	2	dinge
dink	9	71	3780	2	dink
dino	5	60	3675	2	dino
dins	5	66	5204	2	dins
dint	5	67	5905	2	dint
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
dole	5	65	5000	2	dole
dome	7	72	4073	2	dome
don	4	67	5765	2	don_
dona	5	55	2963	2	dona
donee	6	69	3101	2	donee
dong	6	60	3165	2	dong
donne	6	55	2046	2	donne
dons	5	60	4870	2	dons
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
drone	6	53	2498	2	drone
duce	7	69	3350	2	duce
dude	6	56	2966	2	dude
due	4	52	4986	2	d_ue
duende	8	3	692	2	duende
duke	9	56	2810	2	duke
dun	4	65	4558	2	dun_
dunce	8	63	1926	2	dunce
dunes	6	53	3217	2	dunes
dung	6	63	2843	2	dung
dunk	9	62	2857	2	dunk
duns	5	51	4043	2	duns
dunt	5	57	4687	2	dunt
dupe	7	66	3060	2	dupe
dure	5	63	4181	2	dure
dwine	9	56	1614	2	dwine
dye	7	53	3484	2	d_ye
dyke	12	64	1818	2	dyke
dynel	9	56	985	2	dynel
dynes	9	59	1758	2	dynes
edge	6	57	1968	2	edge
eke	7	56	3009	2	_eke
eme	5	58	3718	2	_eme
en	2	80	5239	2	_en_
end	4	68	3435	2	_end
eng	4	67	2678	2	_eng
ens	3	72	4592	2	_ens
ere	3	63	5277	2	_ere
erne	4	67	2742	2	erne
esne	4	70	1879	2	esne
eve	6	63	3116	2	_eve
ewe	6	66	3098	2	_ewe
eye	6	55	3977	2	_eye
eyne	7	63	2246	2	eyne
fane	7	53	4357	2	fane
fee	6	68	6201	2	fe_e
feme	9	61	3054	2	feme
fen	6	68	5135	2	fen_
fence	10	53	1991	2	fence
fend	8	48	3297	2	fend
fens	7	61	3976	2	fens
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fine	7	51	4795	2	fine
gane	5	51	4530	2	gane
gee	4	53	5920	2	ge_e
gen	4	59	5051	2	gen_
genes	6	51	3309	2	genes
genet	6	60	3868	2	genet
genie	6	61	2492	2	genie
genre	6	60	1680	2	genre
gens	5	57	4007	2	gens
gent	5	69	5439	2	gent
genu	5	59	2907	2	genu
gone	5	56	3904	2	gone
hebe	9	64	2470	2	hebe
heme	9	50	3441	2	heme
hen	6	75	5527	2	hen_
hence	10	49	2004	2	hence
henge	9	48	1983	2	henge
hens	7	56	4257	2	hens
hent	7	66	5638	2	hent
here	7	64	4710	2	here
hone	7	75	4932	2	hone
indene	7	32	1537	2	indene
jane	11	50	3148	2	jane
jee	10	66	4864	2	je_e
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
kane	8	51	3397	2	kane
keen	8	48	3041	2	keen
ken	7	63	4398	2	ken_
keno	8	79	2643	2	keno
kens	8	54	3523	2	kens
kent	8	68	4696	2	kent
kente	9	58	2107	2	kente
kerne	9	47	1822	2	kerne
kine	8	56	4343	2	kine
knee	8	53	2360	2	knee
kune	8	54	2457	2	kune
lane	4	51	5333	2	lane
lee	3	60	6814	2	le_e
leke	8	55	2740	2	leke
lend	5	62	3367	2	lend
lenes	5	47	3852	2	lenes
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lense	5	45	2343	2	lense
lent	4	63	6053	2	lent
leone	5	50	1882	2	leone
line	4	69	6557	2	line
lone	4	58	4913	2	lone
lune	4	71	4049	2	lune
mane	6	50	5203	2	mane
meme	8	53	3055	2	meme
men	5	92	5285	2	men_
mend	7	53	3403	2	mend
meno	6	60	3136	2	meno
mense	7	50	2563	2	mense
menu	6	51	3023	2	menu
mere	6	72	4444	2	mere
mesne	7	51	1629	2	mesne
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mine	6	72	5617	2	mine
ne	2	70	4510	2	__ne
nee	3	66	5778	2	ne_e
nenes	5	53	2967	2	nenes
neve	7	62	2483	2	neve
nine	4	58	4217	2	nine
none	4	57	4317	2	none
one	3	70	5091	2	_one
pane	6	49	5029	2	pane
pee	5	60	6651	2	pe_e
peen	6	59	3808	2	peen
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pen	5	65	5884	2	pen_
pence	9	49	2445	2	pence
pend	7	59	3453	2	pend
penes	7	58	3922	2	penes
penne	7	54	2385	2	penne
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
pere	6	64	5026	2	pere
pine	6	77	5571	2	pine
pone	6	57	4753	2	pone
rede	5	50	3767	2	rede
ree	3	79	7407	2	re_e
rend	5	61	3657	2	rend
renew	8	39	1751	2	renew
rent	4	66	6124	2	rent
rente	5	47	3378	2	rente
rete	4	49	4413	2	rete
rune	4	52	3629	2	rune
sane	4	59	5434	2	sane
scene	7	72	2057	2	scene
see	3	57	7226	2	se_e
seen	4	69	4312	2	seen
seine	5	57	3287	2	seine
seme	6	58	3665	2	seme
sen	3	60	5852	2	sen_
send	5	52	3729	2	send
sense	5	55	2682	2	sense
sent	4	69	6301	2	sent
sente	5	64	3288	2	sente
sere	4	61	5347	2	sere
sine	4	65	6062	2	sine
skene	9	61	1812	2	skene
sone	4	66	4998	2	sone
syne	7	57	2576	2	syne
tee	3	83	6687	2	te_e
teen	4	59	3820	2	teen
tele	4	50	4087	2	tele
ten	3	58	5611	2	ten_
tend	5	64	3377	2	tend
tenet	5	55	4221	2	tenet
tenge	6	57	2044	2	tenge
tens	4	56	4741	2	tens
tense	5	52	2584	2	tense
tent	4	61	5986	2	tent
terne	5	64	2615	2	terne
tine	4	58	5513	2	tine
tone	4	69	5374	2	tone
tune	4	56	3586	2	tune
tyne	7	63	2505	2	tyne
vane	7	55	3469	2	vane
vee	6	57	5018	2	ve_e
vena	7	61	2629	2	vena
venae	8	59	2098	2	venae
vend	8	66	2642	2	vend
venge	9	51	1799	2	venge
vent	7	60	4905	2	vent
venue	8	49	1821	2	venue
vine	7	56	4368	2	vine
wane	7	63	4472	2	wane
wee	6	67	6081	2	we_e
ween	7	58	3546	2	ween
wen	6	62	4960	2	wen_
wend	8	53	3045	2	wend
wens	7	63	3793	2	wens
went	7	60	5187	2	went
were	7	62	3833	2	were
wine	7	49	5342	2	wine
yen	6	68	4738	2	yen_
yens	7	58	3226	2	yens
yente	8	62	2004	2	yente
zee	12	61	4323	2	ze_e
zine	13	70	3615	2	zine
zone	13	52	3108	2	zone

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.283	631417.0
2	DLD Change Limit	29872	361	0.780	38297.4
3	Display Results	361	361	0.093	3881.7
	(SQL Overall)	178691	361	1.156	154577.0