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

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

448 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
came	8	76	4875	(None)
acme	8	69	2432	1	acme
cade	7	64	4391	1	cade
cafe	9	52	3032	1	cafe
cage	7	53	3906	1	cage
cake	10	54	3996	1	cake
cam	7	80	5898	1	cam_
camel	9	68	2280	1	camel
cameo	9	59	2499	1	cameo
cames	9	70	4731	1	cames
camo	8	57	3175	1	camo
camp	10	63	3645	1	camp
cams	8	70	4728	1	cams
cane	6	66	5311	1	cane
cape	8	72	4278	1	cape
care	6	69	6837	1	care
case	6	58	4808	1	case
cate	6	62	5459	1	cate
cave	9	59	4126	1	cave
come	8	75	4770	1	come
cyme	11	94	2037	1	cyme
dame	7	71	4031	1	dame
fame	9	56	3939	1	fame
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
ache	9	68	2982	2	ache
acmes	9	60	2065	2	acmes
acne	6	66	2587	2	acne
acre	6	73	3077	2	acre
ae	2	125	9029	2	_a_e
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
became	12	32	1316	2	became
blame	9	56	2549	2	blame
cab	7	83	5540	2	ca_b
caber	9	51	2683	2	caber
cable	9	53	2991	2	cable
cabmen	12	36	1065	2	cabmen
cabs	8	67	3942	2	cabs
caca	8	55	2808	2	caca
cache	12	51	2248	2	cache
cad	6	74	5636	2	ca_d
cades	8	54	4073	2	cades
cadet	8	53	3933	2	cadet
cadge	9	40	1878	2	cadge
cadi	7	57	3217	2	cadi
cadre	8	54	1901	2	cadre
cads	7	61	4452	2	cads
cafes	10	64	2692	2	cafes
caff	12	56	3167	2	caff
caged	9	54	2636	2	caged
cager	8	52	2922	2	cager
cages	8	59	3601	2	cages
cagey	11	59	1782	2	cagey
cagy	10	63	2199	2	cagy
caid	7	78	3753	2	caid
cain	6	56	4391	2	cain
caked	12	61	2862	2	caked
cakes	11	60	3767	2	cakes
cakey	14	55	1727	2	cakey
caky	13	62	2244	2	caky
calf	9	63	3956	2	calf
calk	10	55	2766	2	calk
call	6	68	3867	2	call
calm	8	50	3236	2	calm
calmed	11	48	1638	2	calmed
calmer	10	52	1693	2	calmer
calms	9	52	2235	2	calms
calo	6	49	3644	2	calo
calve	10	59	1992	2	calve
calx	13	57	2279	2	calx
camas	9	63	3352	2	camas
camber	12	44	1847	2	camber
camels	10	52	1708	2	camels
cameos	10	58	1800	2	cameos
camera	10	3	1367	2	camera
camise	10	33	1963	2	camise
camlet	10	44	2658	2	camlet
cammie	12	46	1529	2	cammie
camos	9	59	2761	2	camos
camped	13	47	2023	2	camped
camper	12	47	2221	2	camper
campi	11	62	1778	2	campi
campo	11	52	1976	2	campo
camps	11	63	3026	2	camps
campy	14	51	1618	2	campy
can	5	77	6013	2	ca_n
caned	8	58	3809	2	caned
caner	7	53	3477	2	caner
canes	7	53	5037	2	canes
canoe	7	56	2725	2	canoe
cans	6	50	5084	2	cans
cant	6	63	6202	2	cant
cap	7	67	5898	2	ca_p
caped	10	49	3180	2	caped
caper	9	48	3162	2	caper
capes	9	54	4192	2	capes
caph	11	66	2329	2	caph
capo	8	58	2921	2	capo
caps	8	71	4789	2	caps
car	5	91	6556	2	ca_r
carb	8	51	4316	2	carb
card	7	102	4587	2	card
cared	8	60	5009	2	cared
carer	7	49	4233	2	carer
cares	7	73	6918	2	cares
caret	7	53	6056	2	caret
carex	14	48	2229	2	carex
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carle	7	45	3570	2	carle
carmen	10	40	1934	2	carmen
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
carse	7	49	3433	2	carse
cart	6	65	7034	2	cart
carte	7	59	4042	2	carte
carve	10	62	2775	2	carve
casa	6	56	3086	2	casa
cased	8	60	3241	2	cased
cases	7	50	4838	2	cases
cash	9	66	3628	2	cash
cask	10	56	2643	2	cask
cast	6	71	5990	2	cast
caste	7	59	3236	2	caste
cat	5	82	8234	2	ca_t
cater	7	48	4070	2	cater
cates	7	59	5187	2	cates
cats	6	63	5634	2	cats
caul	6	56	3000	2	caul
cause	7	52	2535	2	cause
caved	11	62	2756	2	caved
caver	10	56	2906	2	caver
caves	10	56	3970	2	caves
cavie	10	46	2159	2	cavie
cavy	12	59	2000	2	cavy
caw	8	66	4793	2	ca_w
cawed	11	66	2706	2	cawed
caws	9	60	3610	2	caws
cay	8	71	5598	2	ca_y
cays	9	54	3767	2	cays
cease	7	52	2765	2	cease
cede	7	49	2876	2	cede
cee	5	59	5270	2	c_ee
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
chafe	13	51	1735	2	chafe
cham	11	55	3231	2	cham_
champ	14	50	1796	2	champ
chams	12	60	2850	2	chams
chape	12	52	2114	2	chape
chare	10	52	3198	2	chare
chase	10	51	2712	2	chase
chime	12	53	2259	2	chime
chyme	15	65	1250	2	chyme
cimex	16	11	913	2	cimex
cine	6	62	4294	2	cine
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
clade	8	58	2101	2	clade
clam	8	63	3229	2	clam_
clamp	11	55	1765	2	clamp
clams	9	51	2767	2	clams
clave	10	54	2015	2	clave
clime	9	57	2089	2	clime
clue	6	53	2453	2	clue
code	7	73	4773	2	code
coke	10	70	3838	2	coke
cole	6	69	5611	2	cole
coma	8	71	3485	2	coma
comae	9	71	2842	2	comae
comb	10	66	3211	2	comb
combe	11	62	2354	2	combe
comer	9	58	3269	2	comer
comes	9	72	4699	2	comes
comet	9	59	4607	2	comet
comp	10	67	3125	2	comp
comte	9	61	2547	2	comte
cone	6	72	5696	2	cone
cope	8	68	4738	2	cope
core	6	72	6311	2	core
cote	6	66	4873	2	cote
cove	9	58	3707	2	cove
crake	11	48	2352	2	crake
cram	8	56	3549	2	cram_
crambe	12	3	907	2	crambe
cramp	11	51	2069	2	cramp
crams	9	62	2915	2	crams
crane	7	53	3160	2	crane
crape	9	61	2844	2	crape
crate	7	65	3740	2	crate
crave	10	56	2631	2	crave
craze	16	52	2146	2	craze
creme	9	43	1932	2	creme
crime	9	48	2269	2	crime
cube	8	58	3021	2	cube
cue	5	75	4418	2	c_ue
cuke	10	58	2498	2	cuke
cum	7	64	4016	2	cum_
cure	6	61	4912	2	cure
cute	6	64	4045	2	cute
cwm	10	68	1508	2	cwm_
cwms	11	43	957	2	cwms
cyma	11	67	1584	2	cyma
cymae	12	67	1301	2	cymae
cymes	12	101	1892	2	cymes
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
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
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
famed	11	59	2834	2	famed
fames	10	57	3592	2	fames
fane	7	53	4356	2	fane
fare	7	63	5446	2	fare
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
feme	9	61	3054	2	feme
flame	10	51	2444	2	flame
frame	10	58	2180	2	frame
fume	9	67	2763	2	fume
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
scale	7	46	2914	2	scale
scam	8	59	3235	2	scam_
scamp	11	57	1731	2	scamp
scams	9	44	2397	2	scams
scape	9	69	2184	2	scape
scare	7	53	3446	2	scare
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 4 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.250	714764.0
2	DLD Change Limit	29872	448	2.733	10930.1
3	Display Results	448	448	0.266	1684.2
	(SQL Overall)	178691	448	3.249	54998.8