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

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

287 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
nene	4	59	3206	(None)
bene	6	64	3949	1	bene
dene	5	66	4341	1	dene
gene	5	62	3722	1	gene
nee	3	66	5778	1	ne_e
nenes	5	53	2967	1	nenes
neve	7	62	2483	1	neve
nine	4	58	4217	1	nine
none	4	57	4317	1	none
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	6694	2	_ane
anele	5	56	2883	2	anele
anent	5	49	3184	2	anent
arene	5	53	2941	2	arene
bane	6	52	5042	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	5085	2	bine
bone	6	59	4932	2	bone
cane	6	66	5311	2	cane
cede	7	49	2876	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
dee	4	76	6582	2	de_e
deke	9	52	2876	2	deke
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
den	4	75	5434	2	den_
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
dere	5	68	4590	2	dere
diene	6	57	2013	2	diene
dine	5	55	5533	2	dine
done	5	57	4791	2	done
dune	5	61	3758	2	dune
dyne	8	53	2093	2	dyne
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	4356	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	4529	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	1982	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
inane	5	28	2034	2	inane
indene	7	32	1537	2	indene
jane	11	50	3147	2	jane
jee	10	66	4864	2	je_e
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
kane	8	51	3396	2	kane
keen	8	48	3040	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	2106	2	kente
kerne	9	47	1821	2	kerne
kine	8	56	4342	2	kine
knee	8	53	2360	2	kne_e
kune	8	54	2457	2	kune
lane	4	51	5332	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	5201	2	mane
meme	8	53	3055	2	meme
men	5	92	5284	2	men_
mend	7	53	3402	2	mend
meno	6	60	3135	2	meno
mense	7	50	2563	2	mense
menu	6	51	3022	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	5615	2	mine
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	n_ae
name	6	56	3741	2	name
nan	3	78	5487	2	nan_
nana	4	66	3289	2	nana
nance	7	47	2184	2	nance
nans	4	61	3939	2	nans
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
ne	2	70	4510	2	__ne
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
neb	5	72	3862	2	ne_b
nebs	6	61	2498	2	nebs
neck	10	54	2366	2	neck
need	5	49	3415	2	need
neem	6	73	2808	2	neem
neep	6	57	2831	2	neep
neg	4	72	3734	2	ne_g
negs	5	57	2736	2	negs
neif	7	54	2948	2	neif
nema	6	55	2252	2	nema
neon	4	70	2642	2	neon
neoned	7	3	1148	2	neoned
neons	5	58	1868	2	neons
nerd	5	66	2494	2	nerd
nerve	8	66	1737	2	nerve
ness	4	55	2656	2	ness
nest	4	55	4873	2	nest
net	3	66	7029	2	ne_t
nets	4	59	4153	2	nets
nett	4	66	4323	2	nett
neuk	8	74	1660	2	neuk
neum	6	67	2308	2	neum
neume	7	44	1440	2	neume
never	8	62	1864	2	never
neves	8	70	2187	2	neves
nevi	7	51	1642	2	nevi
new	6	62	3709	2	ne_w
newel	8	61	1413	2	newel
newer	8	57	1746	2	newer
newie	8	18	1348	2	newie
news	7	61	2737	2	news
newt	7	69	3374	2	newt
next	11	66	3108	2	next
nice	6	55	3471	2	nice
nide	5	55	3578	2	nide
niece	7	48	1450	2	niece
nieve	8	56	1318	2	nieve
nines	5	59	3734	2	nines
nite	4	59	4358	2	nite
nixe	11	57	2202	2	nixe
node	5	130	3688	2	node
nome	6	60	3842	2	nome
nona	4	69	2906	2	nona
nonce	7	57	1982	2	nonce
nones	5	56	3913	2	nones
nonet	5	45	4084	2	nonet
nope	6	59	3419	2	nope
nose	4	67	3936	2	nose
note	4	62	3996	2	note
nude	5	66	2627	2	nude
nuke	8	59	2075	2	nuke
nun	3	55	3774	2	nun_
nuns	4	52	2823	2	nuns
one	3	70	5091	2	_one
pane	6	49	5028	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
pinene	8	29	1564	2	pinene
pone	6	57	4753	2	pone
rede	5	50	3766	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	5433	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	3287	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	2043	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	3468	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
venene	9	29	1252	2	venene
venge	9	51	1798	2	venge
vent	7	60	4905	2	vent
venue	8	49	1821	2	venue
vine	7	56	4368	2	vine
wane	7	63	4471	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.080	2233637.5
2	DLD Change Limit	29872	287	1.000	29872.0
3	Display Results	287	287	0.063	4555.6
	(SQL Overall)	178691	287	1.143	156335.1