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

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

387 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
fame	9	56	3939	(None)
came	8	76	4875	1	came
dame	7	71	4031	1	dame
face	9	61	4012	1	face
fade	8	57	3634	1	fade
fake	11	55	3494	1	fake
famed	11	59	2834	1	famed
fames	10	57	3592	1	fames
fane	7	53	4356	1	fane
fare	7	63	5446	1	fare
fate	7	54	4428	1	fate
fave	10	55	3296	1	fave
faze	16	56	3004	1	faze
feme	9	61	3054	1	feme
flame	10	51	2444	1	flame
frame	10	58	2180	1	frame
fume	9	67	2763	1	fume
game	7	66	4432	1	game
hame	9	70	4313	1	hame
kame	10	57	2823	1	kame
lame	6	68	4929	1	lame
name	6	56	3741	1	name
same	6	52	4564	1	same
tame	6	63	4366	1	tame
wame	9	50	3548	1	wame
ace	5	96	5683	2	_ace
acme	8	69	2432	2	acme
ae	2	125	9029	2	_a_e
aflame	11	3	872	2	aflame
age	4	71	5433	2	_age
ale	3	65	7234	2	_ale
alme	6	58	3216	2	alme
am	4	118	7556	2	_am_
ama	5	108	5330	2	_ama
amen	6	67	3315	2	_amen
ami	5	66	4680	2	_ami
amie	6	63	3984	2	_amie
amp	7	75	4102	2	_amp
amu	5	82	3732	2	_amu
ane	3	78	6694	2	_ane
ape	5	72	5118	2	_ape
arame	7	50	2662	2	arame
are	3	78	7457	2	_are
ate	3	70	5924	2	_ate
ave	6	77	4870	2	_ave
awe	6	77	4662	2	_awe
axe	10	82	3949	2	_axe
aye	6	71	5176	2	_aye
babe	8	68	3581	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bam	7	85	6014	2	bam_
bams	8	70	4445	2	bams
bane	6	52	5042	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
blame	9	56	2549	2	blame
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
cam	7	80	5898	2	cam_
camel	9	68	2280	2	camel
cameo	9	59	2499	2	cameo
cames	9	70	4731	2	cames
camo	8	57	3175	2	camo
camp	10	63	3645	2	camp
cams	8	70	4728	2	cams
cane	6	66	5311	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
case	6	58	4808	2	case
cate	6	62	5459	2	cate
cave	9	59	4126	2	cave
come	8	75	4770	2	come
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
defame	12	32	1243	2	defame
deme	7	65	3628	2	deme
dime	7	62	3764	2	dime
dome	7	72	4073	2	dome
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eme	5	58	3718	2	_eme
fa	5	101	4845	2	fa__
fab	8	74	5313	2	fa_b
fable	10	58	2475	2	fable
fabs	9	86	3586	2	fabs
faced	11	77	2765	2	faced
facer	10	55	2505	2	facer
faces	10	64	3943	2	faces
facet	10	60	3852	2	facet
fact	9	71	4254	2	fact
fad	7	74	5241	2	fa_d
faded	10	50	2524	2	faded
fader	9	44	2151	2	fader
fades	9	49	3286	2	fades
fadge	10	48	1699	2	fadge
fado	8	72	2646	2	fado
fads	8	69	3987	2	fads
fag	7	68	5236	2	fa_g
fags	8	69	3912	2	fags
fail	7	48	4024	2	fail
fain	7	58	4056	2	fain
fair	7	63	3252	2	fair
faked	13	52	2548	2	faked
faker	12	48	2459	2	faker
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
fall	7	55	3531	2	fall
false	8	48	1812	2	false
falx	14	71	2078	2	falx
famine	11	43	1819	2	famine
fan	6	71	5885	2	fa_n
fanes	8	46	3989	2	fanes
fang	8	54	3254	2	fang
fano	7	58	3168	2	fano
fans	7	62	4736	2	fans
far	6	77	6260	2	fa_r
farce	10	49	2532	2	farce
fard	8	56	3906	2	fard
fared	9	58	4234	2	fared
farer	8	67	3314	2	farer
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl
farle	8	69	2924	2	farle
farm	9	59	3453	2	farm
farmed	12	51	1765	2	farmed
farmer	11	50	1737	2	farmer
farms	10	63	2495	2	farms
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fas	6	82	6293	2	fa_s
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fat	6	81	7808	2	fa_t
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
faun	7	62	2662	2	faun
fauve	11	47	1207	2	fauve
faux	14	65	1907	2	faux
fava	10	68	2026	2	fava
faves	11	53	3142	2	faves
fawn	10	53	2195	2	fawn
fax	13	81	4331	2	fa_x
faxed	16	62	2053	2	faxed
faxes	15	57	2665	2	faxes
fay	9	74	5486	2	fa_y
fayed	12	64	2215	2	fayed
fays	10	85	3536	2	fays
fazed	18	62	2296	2	fazed
fazes	17	55	2721	2	fazes
fe	5	79	4474	2	f__e
fease	8	48	2487	2	fease
feaze	17	52	1631	2	feaze
fee	6	68	6201	2	f_ee
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
fice	9	57	3711	2	fice
fie	6	71	5244	2	f_ie
fife	10	60	2770	2	fife
file	7	54	4664	2	file
fine	7	51	4795	2	fine
fire	7	62	4559	2	fire
five	10	76	2974	2	five
flake	12	51	1997	2	flake
flam	9	63	3329	2	flam_
flambe	13	48	915	2	flambe
flamed	12	46	1897	2	flamed
flamen	11	52	1599	2	flamen
flamer	11	49	1912	2	flamer
flames	11	47	2369	2	flames
flams	10	51	2501	2	flams
flamy	13	52	1747	2	flamy
flare	8	48	2363	2	flare
flee	7	62	3879	2	flee
floe	7	61	2977	2	floe
flue	7	53	2985	2	flue
flume	10	60	2117	2	flume
foam	9	71	2717	2	foam_
foamed	12	60	1440	2	foamed
foamer	11	47	1431	2	foamer
foams	10	50	1795	2	foams
foamy	13	53	1320	2	foamy
foe	6	63	5081	2	f_oe
fore	7	83	5147	2	fore
forme	10	52	2599	2	forme
frae	7	53	3047	2	frae
framed	12	51	1652	2	framed
framer	11	48	1744	2	framer
frames	11	51	1986	2	frames
free	7	59	4018	2	free
froe	7	53	2999	2	froe
fumed	11	61	1882	2	fumed
fumer	10	59	1823	2	fumer
fumes	10	52	2470	2	fumes
fumet	10	56	3022	2	fumet
fumy	12	71	1858	2	fumy
fuse	7	64	2999	2	fuse
fuze	16	64	2237	2	fuze
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
gam	6	70	6006	2	gam_
gama	7	70	3551	2	gama
gamb	9	63	3184	2	gamb
gambe	10	62	1921	2	gambe
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gamp	9	88	3321	2	gamp
gams	7	66	4888	2	gams
gamy	10	54	2753	2	gamy
gane	5	51	4529	2	gane
gape	7	51	3451	2	gape
gate	5	57	4657	2	gate
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
haem	9	57	3098	2	haem
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
ham	8	63	6328	2	ham_
hames	10	61	3870	2	hames
hams	9	64	4613	2	hams
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
heme	9	50	3441	2	heme
home	9	80	4244	2	home
iamb	8	66	2372	2	iamb
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jam	12	69	4252	2	jam_
jamb	15	55	2385	2	jamb
jambe	16	53	1475	2	jambe
jams	13	52	3107	2	jams
jane	11	50	3147	2	jane
jape	13	49	2342	2	jape
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kames	11	50	2469	2	kames
kami	10	58	2364	2	kami
kane	8	51	3396	2	kane
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lam	5	76	6671	2	lam_
lama	6	66	3529	2	lama
lamb	8	68	3214	2	lamb
lamed	8	52	3529	2	lamed
lamer	7	52	3370	2	lamer
lames	7	54	4554	2	lames
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
lane	4	51	5332	2	lane
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lime	6	62	4493	2	lime
mabe	8	57	3334	2	mabe
mace	8	73	4578	2	mace
made	7	54	4023	2	made
mae	5	76	5910	2	ma_e
mage	7	57	3912	2	mage
make	10	55	3788	2	make
male	6	60	5229	2	male
mama	8	62	3158	2	mama
mamey	12	54	1883	2	mamey
mamie	9	58	2600	2	mamie
mane	6	50	5201	2	mane
mare	6	47	5932	2	mare
mate	6	51	5421	2	mate
maze	15	54	3497	2	maze
me	4	77	4833	2	__me
meme	8	53	3055	2	meme
mime	8	57	3639	2	mime
mome	8	52	3935	2	mome
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
nam	5	59	5339	2	nam_
named	8	52	2306	2	named
namer	7	56	2210	2	namer
names	7	48	3336	2	names
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nome	6	60	3842	2	nome
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pam	7	78	5839	2	pam_
pams	8	56	4176	2	pams
pane	6	49	5028	2	pane
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
pome	8	56	3669	2	pome
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
ram	5	68	6727	2	ram_
ramee	7	46	3385	2	ramee
ramen	7	56	2519	2	ramen
ramet	7	57	4314	2	ramet
rami	6	60	3409	2	rami
ramie	7	50	2782	2	ramie
ramp	8	59	3400	2	ramp
rams	6	59	5077	2	rams
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
rime	6	51	3888	2	rime
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
samek	11	49	1527	2	samek
samp	8	57	3359	2	samp
sane	4	59	5433	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
seme	6	58	3665	2	seme
shame	10	57	2670	2	shame
some	6	60	4038	2	some
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tam	5	86	6342	2	tam_
tamed	8	55	2851	2	tamed
tamer	7	52	3010	2	tamer
tames	7	52	4201	2	tames
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
time	6	62	3501	2	time
tome	6	75	4319	2	tome
vale	7	49	3734	2	vale
vamp	11	55	2154	2	vamp
vane	7	55	3468	2	vane
vase	7	56	2965	2	vase
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wames	10	64	3280	2	wames
wane	7	63	4471	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
yam	8	74	4899	2	yam_
yamen	10	41	1518	2	yamen
yams	9	53	3073	2	yams
yare	7	56	3694	2	yare
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	387	0.953	31345.2
3	Display Results	387	387	0.093	4161.3
	(SQL Overall)	178691	387	1.122	159261.1