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

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

367 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
dere	5	68	4590	(None)
cere	6	67	4147	1	cere
dare	5	58	4886	1	dare
dee	4	76	6582	1	de_e
deer	5	67	3902	1	deer
deke	9	52	2876	1	deke
dele	5	68	4308	1	dele
deme	7	65	3628	1	deme
dene	5	66	4341	1	dene
derm	7	60	3189	1	derm
dire	5	66	4414	1	dire
dore	5	63	5330	1	dore
dree	5	66	3832	1	dree
dure	5	63	4181	1	dure
ere	3	63	5277	1	_ere
fere	7	63	4223	1	fere
here	7	64	4710	1	here
mere	6	72	4444	1	mere
pere	6	64	5026	1	pere
sere	4	61	5347	1	sere
were	7	62	3833	1	were
acre	6	73	3077	2	acre
adhere	10	3	1033	2	adhere
adore	6	57	2367	2	adore
aerie	5	46	3460	2	aerie
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
are	3	78	7457	2	_are
bare	6	54	6052	2	bare
bee	5	62	6240	2	be_e
beer	6	56	3599	2	beer
bene	6	64	3949	2	bene
beret	7	49	4636	2	beret
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
berme	9	60	2294	2	berme
bore	6	60	5133	2	bore
bree	6	72	4126	2	bree
byre	9	50	2385	2	byre
care	6	69	6837	2	care
cede	7	49	2876	2	cede
cee	5	59	5270	2	ce_e
cepe	8	49	2665	2	cepe
cered	8	52	2744	2	cered
ceres	7	55	4001	2	ceres
cero	6	63	2945	2	cero
cete	6	49	3478	2	cete
cire	6	58	3637	2	cire
core	6	72	6311	2	core
cure	6	61	4912	2	cure
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
darb	7	60	3353	2	darb
dared	7	59	3501	2	dared
darer	6	52	3079	2	darer
dares	6	61	4670	2	dares
dark	9	51	3321	2	dark
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
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
dear	5	53	4360	2	dear
dearer	7	48	2280	2	dearer
dearie	7	33	1981	2	dearie
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
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
decare	9	39	1915	2	decare
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
decree	9	31	1778	2	decree
decry	11	55	1435	2	decry
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deers	6	49	3052	2	deers
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
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degree	8	28	1485	2	degree
deice	8	43	2003	2	deice
deil	5	62	3162	2	deil
dekare	11	28	1156	2	dekare
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
demure	9	3	1153	2	demure
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
derat	6	50	4408	2	derat
derate	7	45	3123	2	derate
deray	9	50	2418	2	deray
derby	11	47	1534	2	derby
deride	8	44	2003	2	deride
derive	10	38	1704	2	derive
derma	8	49	1851	2	derma
derms	8	50	2289	2	derms
derry	9	47	2137	2	derry
desex	13	3	1198	2	desex
desire	7	4	1530	2	desire
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
diene	6	57	2013	2	diene
dike	9	59	3576	2	dike
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
direr	6	49	2707	2	direr
dirge	7	51	1707	2	dirge
dirk	9	63	2683	2	dirk
dirl	5	74	3002	2	dirl
dirt	5	55	5038	2	dirt
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
doe	4	73	6195	2	d_oe
doer	5	77	3470	2	doer_
doers	6	52	2571	2	doers
doge	6	62	3380	2	doge
dole	5	65	5000	2	dole
dome	7	72	4073	2	dome
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dor	4	72	5392	2	dor_
dork	9	65	3146	2	dork
dorm	7	68	3463	2	dorm
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dory	8	58	3623	2	dory
dose	5	64	4243	2	dose
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
dreed	7	52	2284	2	dreed
drees	6	56	2852	2	drees
dreg	6	68	2165	2	dreg
drek	9	63	2109	2	drek
drew	8	62	2167	2	drew
dry	7	65	2603	2	d_ry
duce	7	69	3350	2	duce
dude	6	56	2966	2	dude
due	4	52	4986	2	d_ue
duke	9	56	2810	2	duke
dune	5	61	3758	2	dune
dupe	7	66	3060	2	dupe
dura	5	52	3211	2	dura
dured	7	50	2540	2	dured
dures	6	56	3592	2	dures
durn	5	61	2762	2	durn
duro	5	62	2802	2	duro
durr	5	56	2435	2	durr
dye	7	53	3484	2	d_ye
dyer	8	55	2211	2	dyer_
dyers	9	66	1713	2	dyers
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
edge	6	57	1966	2	edge
eerie	5	52	2853	2	eerie
eery	7	61	2962	2	eery
eke	7	56	3009	2	_eke
eme	5	58	3718	2	_eme
er	2	83	4514	2	_er_
era	3	57	4150	2	_era
erg	4	55	3107	2	_erg
ern	3	57	3835	2	_ern
erne	4	67	2742	2	_erne
err	3	56	2653	2	_err
ers	3	60	4628	2	_ers
eve	6	63	3116	2	_eve
ewe	6	66	3098	2	_ewe
eye	6	55	3977	2	_eye
eyre	7	55	2525	2	eyre
fare	7	63	5446	2	fare
fee	6	68	6201	2	fe_e
feme	9	61	3054	2	feme
fer	6	66	4612	2	fer_
feres	8	60	3818	2	feres
fern	7	61	2932	2	fern
fete	7	57	3492	2	fete
fire	7	62	4559	2	fire
fore	7	83	5147	2	fore
free	7	59	4018	2	free
frere	8	56	1772	2	frere
gee	4	53	5920	2	ge_e
gene	5	62	3722	2	gene
genre	6	60	1680	2	genre
germ	7	54	2896	2	germ
gore	5	57	4496	2	gore
gree	5	66	4156	2	gree
gyre	8	47	2276	2	gyre
hare	7	62	5573	2	hare
hebe	9	64	2470	2	hebe
heme	9	50	3441	2	heme
her	6	65	4781	2	her_
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
heres	8	62	4590	2	heres
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
hern	7	61	3489	2	hern
hero	7	46	3578	2	hero
hers	7	58	4487	2	hers
hire	7	55	3896	2	hire
ire	3	69	4317	2	_ire
jee	10	66	4864	2	je_e
jeer	11	54	2646	2	jeer
jefe	14	65	1688	2	jefe
jerk	15	49	2013	2	jerk
jete	11	59	2725	2	jete
kerb	10	43	2271	2	kerb
kerf	11	58	2746	2	kerf
kern	8	53	2621	2	kern
kerne	9	47	1821	2	kerne
kore	8	58	3416	2	kore
lee	3	60	6814	2	le_e
leer	4	62	3935	2	leer
leke	8	55	2740	2	leke
lire	4	78	4529	2	lire
lore	4	58	5035	2	lore
lure	4	51	4246	2	lure
lyre	7	56	2379	2	lyre
mare	6	47	5933	2	mare
meme	8	53	3055	2	meme
merc	8	72	2562	2	merc
merde	8	43	2012	2	merde
merer	7	51	2623	2	merer
meres	7	51	4357	2	meres
merge	8	45	2368	2	merge
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
merle	7	58	2437	2	merle
mete	6	44	3813	2	mete
metre	7	48	2130	2	metre
meze	15	44	2090	2	meze
mire	6	67	4823	2	mire
more	6	71	5452	2	more
mure	6	59	4133	2	mure
nee	3	66	5778	2	ne_e
nene	4	59	3206	2	nene
nerd	5	66	2494	2	nerd
nerve	8	66	1737	2	nerve
neve	7	62	2483	2	neve
ogre	5	63	2074	2	ogre
ore	3	66	6183	2	_ore
pare	6	67	6084	2	pare
pee	5	60	6651	2	pe_e
peer	6	62	3835	2	peer
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
per	5	63	5309	2	per_
perea	7	50	2644	2	perea
peres	7	62	4664	2	peres
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
perse	7	54	2952	2	perse
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pore	6	64	5126	2	pore
pree	6	70	4473	2	pree
pure	6	55	4333	2	pure
pyre	9	49	2555	2	pyre
rare	4	53	4843	2	rare
re	2	61	5374	2	__re
rede	5	50	3766	2	rede
ree	3	79	7407	2	re_e
rete	4	49	4413	2	rete
see	3	57	7226	2	se_e
seer	4	55	4704	2	seer
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
ser	3	67	5240	2	ser_
sera	4	61	4139	2	sera
sered	6	57	3729	2	sered
serer	5	59	3550	2	serer
seres	5	54	4889	2	seres
serf	7	63	4011	2	serf
serge	6	47	2746	2	serge
sers	4	57	4665	2	sers
serve	8	54	2596	2	serve
sire	4	61	5041	2	sire
sore	4	70	5953	2	sore
stere	5	53	2854	2	stere
sure	4	54	4741	2	sure
tare	4	59	5762	2	tare
tee	3	83	6687	2	te_e
tele	4	50	4087	2	tele
terce	7	57	2184	2	terce
term	6	62	3315	2	term
tern	4	61	3480	2	tern
terne	5	64	2615	2	terne
terse	5	50	2682	2	terse
there	8	75	2739	2	there
tire	4	61	4335	2	tire
tore	4	73	5932	2	tore
tree	4	77	4581	2	tree
tyre	7	54	2825	2	tyre
vee	6	57	5018	2	ve_e
veer	7	62	2957	2	veer
vera	7	68	2884	2	vera
verb	9	62	2487	2	verb
verge	9	34	1983	2	verge
verse	8	47	2358	2	verse
vert	7	72	4937	2	vert
verve	11	54	1772	2	verve
very	10	80	2564	2	very
ware	7	62	5472	2	ware
wee	6	67	6081	2	we_e
weer	7	55	3509	2	weer
wert	7	97	4982	2	wert
where	11	70	1942	2	where
wire	7	58	3981	2	wire
wore	7	71	4467	2	wore
yare	7	56	3694	2	yare
yerk	11	62	2208	2	yerk
yore	7	63	3594	2	yore
zee	12	61	4323	2	ze_e
zerk	17	53	1925	2	zerk
zero	13	48	2247	2	zero

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.063	2836365.1
2	DLD Change Limit	29872	367	0.860	34734.9
3	Display Results	367	367	0.076	4828.9
	(SQL Overall)	178691	367	0.999	178869.9