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

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

267 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
deme	7	65	3628	(None)
dame	7	71	4031	1	dame
dee	4	76	6582	1	de_e
deem	7	54	3289	1	deem
deke	9	52	2876	1	deke
dele	5	68	4308	1	dele
demes	8	60	3269	1	demes
demo	7	74	2755	1	demo
demy	10	54	2285	1	demy
dene	5	66	4341	1	dene
dere	5	68	4590	1	dere
dime	7	62	3764	1	dime
dome	7	72	4073	1	dome
eme	5	58	3718	1	_eme
feme	9	61	3054	1	feme
heme	9	50	3441	1	heme
meme	8	53	3055	1	meme
seme	6	58	3665	1	seme
acme	8	69	2432	2	acme
adeem	8	3	1180	2	adeem
alme	6	58	3216	2	alme
bee	5	62	6240	2	be_e
bema	8	58	2525	2	bema
bene	6	64	3949	2	bene
berme	9	60	2294	2	berme
came	8	76	4875	2	came
cede	7	49	2876	2	cede
cee	5	59	5270	2	ce_e
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
come	8	75	4770	2	come
creme	9	43	1932	2	creme
cyme	11	94	2037	2	cyme
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dam	6	74	5704	2	dam_
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn
damp	9	62	2884	2	damp
dams	7	74	4437	2	dams
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
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
deck	11	58	2775	2	deck
deco	7	61	2597	2	deco
deed	6	53	4090	2	deed
deemed	10	47	1306	2	deemed
deems	8	54	2177	2	deems
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
defame	12	32	1243	2	defame
defer	9	46	1975	2	defer
defi	8	63	2149	2	defi
deft	8	55	4022	2	deft
defy	11	49	2126	2	defy
degame	10	27	1318	2	degame
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
delime	9	3	1404	2	delime
dell	5	69	3820	2	dell
dels	5	67	4547	2	dels
delt	5	78	5527	2	delt
delve	9	60	1826	2	delve
demean	9	5	1056	2	demean
dement	9	38	2514	2	dement
demic	10	51	1919	2	demic
demies	9	48	2580	2	demies
demise	9	46	1832	2	demise
demit	8	48	3230	2	demit
demob	10	49	1350	2	demob
demode	10	40	1346	2	demode
demoed	10	37	1344	2	demoed
demon	8	65	2031	2	demon
demos	8	60	2299	2	demos
demote	9	48	1780	2	demote
demur	8	3	1116	2	demur
demure	9	3	1153	2	demure
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
derma	8	49	1851	2	derma
derms	8	50	2289	2	derms
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
diene	6	57	2013	2	diene
dike	9	59	3576	2	dike
dim	6	81	4649	2	dim_
dimer	8	56	2560	2	dimer
dimes	8	58	3304	2	dimes
dims	7	54	3502	2	dims
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
disme	8	57	1624	2	disme
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
dom	6	97	5244	2	dom_
domed	9	54	2326	2	domed
domes	8	57	3556	2	domes
doms	7	62	3957	2	doms
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
duke	9	56	2810	2	duke
duma	7	55	2445	2	duma
dumb	9	71	2410	2	dumb
dump	9	59	2709	2	dump
dune	5	61	3758	2	dune
dupe	7	66	3060	2	dupe
dure	5	63	4181	2	dure
dye	7	53	3484	2	d_ye
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
edema	8	6	1055	2	edema
edge	6	57	1966	2	edge
eke	7	56	3009	2	_eke
em	4	94	4515	2	_em_
emes	6	54	3466	2	_emes
emeu	6	67	2343	2	_emeu
ems	5	64	3549	2	_ems
emu	5	59	2998	2	_emu
ere	3	63	5277	2	_ere
eve	6	63	3116	2	_eve
ewe	6	66	3098	2	_ewe
eye	6	55	3977	2	_eye
fame	9	56	3939	2	fame
fee	6	68	6201	2	fe_e
fem	8	60	4073	2	fem_
femes	10	56	2622	2	femes
femme	12	50	1143	2	femme
fems	9	64	2870	2	fems
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fume	9	67	2763	2	fume
game	7	66	4432	2	game
gee	4	53	5920	2	ge_e
gem	6	68	4022	2	gem_
gems	7	53	2911	2	gems
gene	5	62	3722	2	gene
hame	9	70	4313	2	hame
hebe	9	64	2470	2	hebe
hem	8	61	4873	2	hem_
hemes	10	50	3108	2	hemes
hemp	11	57	2562	2	hemp
hems	9	55	3494	2	hems
here	7	64	4710	2	here
home	9	80	4244	2	home
idem	7	61	2106	2	idem_
jee	10	66	4864	2	je_e
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
kame	10	57	2823	2	kame
kemp	12	64	1876	2	kemp
lame	6	68	4929	2	lame
lee	3	60	6814	2	le_e
leke	8	55	2740	2	leke
lime	6	62	4493	2	lime
me	4	77	4833	2	__me
mem	7	79	4347	2	mem_
memes	9	49	2770	2	memes
memo	8	59	2479	2	memo
mems	8	59	3150	2	mems
mere	6	72	4444	2	mere
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mime	8	57	3640	2	mime
mome	8	52	3935	2	mome
name	6	56	3741	2	name
nee	3	66	5778	2	ne_e
neem	6	73	2808	2	neem
nema	6	55	2252	2	nema
nene	4	59	3206	2	nene
neume	7	44	1440	2	neume
neve	7	62	2483	2	neve
nome	6	60	3842	2	nome
pee	5	60	6651	2	pe_e
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pere	6	64	5026	2	pere
pome	8	56	3669	2	pome
rede	5	50	3766	2	rede
ree	3	79	7407	2	re_e
rem	5	61	5004	2	rem_
remet	7	48	4372	2	remet
remex	14	63	1579	2	remex
rems	6	62	3772	2	rems
rete	4	49	4413	2	rete
rheme	10	62	1405	2	rheme
rime	6	51	3888	2	rime
same	6	52	4564	2	same
see	3	57	7226	2	se_e
seem	6	54	3856	2	seem
semen	7	57	2410	2	semen
semes	7	57	3158	2	semes
semi	6	51	2722	2	semi
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
some	6	60	4038	2	some
tame	6	63	4366	2	tame
tee	3	83	6687	2	te_e
teem	6	61	3260	2	teem
tele	4	50	4087	2	tele
temp	8	53	2333	2	temp
theme	10	59	2173	2	theme
time	6	62	3501	2	time
tome	6	75	4319	2	tome
vee	6	57	5018	2	ve_e
wame	9	50	3548	2	wame
wee	6	67	6081	2	we_e
were	7	62	3833	2	were
zee	12	61	4323	2	ze_e
zyme	18	191	1494	2	zyme

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.076	2351197.4
2	DLD Change Limit	29872	267	0.843	35435.3
3	Display Results	267	267	0.063	4238.1
	(SQL Overall)	178691	267	0.982	181966.4