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

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

430 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
mage	7	57	3913	(None)
age	4	71	5433	1	_age
cage	7	53	3906	1	cage
gage	6	59	3610	1	gage
image	8	14	1129	1	image
mabe	8	57	3336	1	mabe
mace	8	73	4579	1	mace
made	7	54	4024	1	made
mae	5	76	5911	1	ma_e
mag	6	79	5648	1	mag_
mages	8	50	3602	1	mages
magi	7	63	2953	1	magi
mags	7	54	4453	1	mags
make	10	55	3789	1	make
male	6	60	5230	1	male
mane	6	50	5203	1	mane
mange	8	49	3019	1	mange
mare	6	47	5933	1	mare
marge	8	53	2833	1	marge
mate	6	51	5422	1	mate
maze	15	54	3498	1	maze
page	7	60	3610	1	page
rage	5	57	4235	1	rage
sage	5	50	4459	1	sage
wage	8	48	3408	1	wage
ace	5	96	5683	2	_ace
adage	7	4	1405	2	adage
ae	2	125	9029	2	_a_e
ag	3	110	6746	2	_ag_
aga	4	104	4723	2	_aga
aged	6	73	3425	2	_aged
agee	5	62	4149	2	_agee
ager	5	59	3584	2	_ager
ages	5	58	4459	2	_ages
ago	4	88	4552	2	_ago
ags	4	75	5166	2	_ags
ague	5	57	2592	2	_ague
ale	3	65	7234	2	_ale
amaze	16	60	1660	2	amaze
ambage	11	5	1060	2	ambage
amie	6	63	3985	2	amie
ane	3	78	6695	2	_ane
ape	5	72	5118	2	_ape
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	3582	2	babe
bade	7	51	4088	2	bade
badge	9	48	1969	2	badge
bag	6	70	5922	2	bag_
bagel	8	51	1679	2	bagel
bags	7	66	4550	2	bags
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
barge	8	56	3102	2	barge
base	6	48	4702	2	base
bate	6	65	5242	2	bate
cade	7	64	4391	2	cade
cadge	9	40	1879	2	cadge
cafe	9	52	3032	2	cafe
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
cake	10	54	3996	2	cake
came	8	76	4875	2	came
cane	6	66	5312	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
case	6	58	4808	2	case
cate	6	62	5460	2	cate
cave	9	59	4126	2	cave
dace	7	69	3492	2	dace
dag	5	77	5301	2	dag_
dago	6	57	2509	2	dago
dags	6	66	4260	2	dags
dale	5	56	4398	2	dale
damage	10	4	1077	2	damage
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
doge	6	62	3380	2	doge
eager	6	55	2697	2	eager
eagle	6	42	1948	2	eagle
eagre	6	43	1532	2	eagre
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
edge	6	57	1968	2	edge
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fadge	10	48	1700	2	fadge
fag	7	68	5236	2	fag_
fags	8	69	3912	2	fags
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4357	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
gae	4	64	5770	2	ga_e
gag	5	77	5363	2	gag_
gaga	6	66	2555	2	gaga
gaged	8	55	2231	2	gaged
gager	7	47	2629	2	gager
gages	7	45	2997	2	gages
gags	6	64	4106	2	gags
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4530	2	gane
gape	7	51	3451	2	gape
gate	5	57	4657	2	gate
gauge	7	61	1790	2	gauge
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
hag	7	72	5574	2	hag_
hags	8	67	4084	2	hags
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
homage	12	12	1060	2	homage
huge	8	63	2165	2	huge
imaged	10	9	776	2	imaged
imager	9	10	812	2	imager
images	9	14	1146	2	images
imago	8	11	869	2	imago
jade	12	53	2544	2	jade
jag	11	65	4271	2	jag_
jager	13	43	1813	2	jager
jagg	13	61	1531	2	jagg
jags	12	61	3279	2	jags
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
kae	7	67	4454	2	ka_e
kagu	9	54	1811	2	kagu
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lag	4	78	6212	2	lag_
lager	6	51	3286	2	lager
lags	5	65	4622	2	lags
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5333	2	lane
large	6	53	2546	2	large
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
loge	5	68	3719	2	loge
luge	5	55	3164	2	luge
ma	4	100	6066	2	ma__
maar	6	60	2506	2	maar
mabes	9	63	3153	2	mabes
mac	7	80	5393	2	ma_c
maced	10	85	2869	2	maced
macer	9	121	2694	2	macer
maces	9	71	3996	2	maces
mach	11	61	3448	2	mach
mache	12	59	2530	2	mache
mack	12	57	3365	2	mack
macle	9	61	2700	2	macle
macs	8	67	4251	2	macs
mad	6	89	5871	2	ma_d
madre	8	57	2017	2	madre
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
magic	10	58	1865	2	magic
maglev	12	3	702	2	maglev
magma	10	45	1357	2	magma
magnet	9	3	2066	2	magnet
magot	8	3	2639	2	magot
magpie	11	3	909	2	magpie
maguey	12	3	683	2	maguey
magus	8	53	1875	2	magus
mahoe	10	3	1557	2	mahoe
maid	7	55	3766	2	maid
maigre	9	30	916	2	maigre
mail	6	55	4345	2	mail
maile	7	52	3222	2	maile
maim	8	58	3149	2	maim
main	6	53	4552	2	main
mair	6	61	3378	2	mair
maize	16	46	1856	2	maize
maker	11	41	2781	2	maker
makes	11	53	3685	2	makes
mako	10	56	2236	2	mako
males	7	50	4979	2	males
malgre	9	29	930	2	malgre
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
mama	8	62	3159	2	mama
mamey	12	54	1883	2	mamey
mamie	9	58	2600	2	mamie
man	5	74	6587	2	ma_n
mana	6	53	4196	2	mana
manage	9	38	1890	2	manage
maned	8	66	3410	2	maned
manege	9	41	1320	2	manege
manes	7	66	4896	2	manes
manga	8	50	2620	2	manga
mangel	9	40	1753	2	mangel
manger	9	43	2500	2	manger
manges	9	46	2894	2	manges
mangey	12	36	1452	2	mangey
mangle	9	39	2132	2	mangle
mango	8	57	2432	2	mango
mangy	11	50	2124	2	mangy
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
manse	7	55	2823	2	manse
many	9	57	3186	2	many
map	7	72	5512	2	ma_p
maple	9	55	2114	2	maple
maps	8	61	4105	2	maps
mar	5	79	6595	2	ma_r
mara	6	74	4457	2	mara
marc	8	70	3463	2	marc
mares	7	64	5763	2	mares
marges	9	45	2571	2	marges
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
marse	7	62	3115	2	marse
mart	6	68	6598	2	mart
mas	5	81	7582	2	ma_s
masa	6	50	3472	2	masa
maser	7	50	2997	2	maser
mash	9	60	3940	2	mash
mask	10	52	2736	2	mask
mass	6	60	4494	2	mass
masse	7	51	2529	2	masse
mast	6	59	5996	2	mast
mat	5	80	8394	2	ma_t
mated	8	55	3778	2	mated
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
math	9	54	3745	2	math
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
matte	7	56	2684	2	matte
maud	7	53	2540	2	maud
mauger	9	38	1348	2	mauger
maugre	9	30	897	2	maugre
maul	6	48	3072	2	maul
maun	6	57	2721	2	maun
maut	6	54	4845	2	maut
mauve	10	40	1327	2	mauve
maven	10	48	1689	2	maven
mavie	10	47	2256	2	mavie
maw	8	70	5010	2	ma_w
mawed	11	58	2474	2	mawed
mawn	9	44	2414	2	mawn
maws	9	64	3714	2	maws
max	12	90	4545	2	ma_x
maxed	15	58	2119	2	maxed
maxes	14	56	2953	2	maxes
maxi	13	70	2356	2	maxi
may	8	87	5763	2	ma_y
maya	9	58	2459	2	maya
maybe	12	3	1113	2	maybe
mayed	11	55	2240	2	mayed
mayo	9	65	2430	2	mayo
mays	9	69	4003	2	mays
mazed	17	55	2387	2	mazed
mazer	16	57	2242	2	mazer
mazes	16	56	3217	2	mazes
mazy	18	64	1970	2	mazy
me	4	77	4833	2	m__e
meager	9	45	1520	2	meager
meagre	9	34	932	2	meagre
meg	6	60	4095	2	meg_
mega	7	76	2087	2	mega
megs	7	55	3063	2	megs
meme	8	53	3055	2	meme
menage	9	32	1654	2	menage
mere	6	72	4444	2	mere
merge	8	45	2369	2	merge
metage	9	31	1445	2	metage
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mice	8	74	4223	2	mice
midge	9	50	1655	2	midge
mig	6	56	4608	2	mig_
migg	8	57	1680	2	migg
migs	7	69	3532	2	migs
mike	10	55	3529	2	mike
milage	9	34	1412	2	milage
mile	6	63	5257	2	mile
mime	8	57	3640	2	mime
mine	6	72	5617	2	mine
mirage	9	23	1365	2	mirage
mire	6	67	4823	2	mire
mise	6	60	4358	2	mise
mite	6	62	4941	2	mite
mode	7	58	4030	2	mode
mog	6	69	4967	2	mog_
mogs	7	54	3933	2	mogs
moke	10	62	3422	2	moke
mole	6	62	5183	2	mole
mome	8	52	3935	2	mome
mope	8	68	3804	2	mope
more	6	71	5452	2	more
mote	6	70	4808	2	mote
moue	6	58	3557	2	moue
move	9	66	3072	2	move
mug	6	58	3769	2	mug_
mugg	8	63	1601	2	mugg
mugs	7	62	3204	2	mugs
mule	6	52	3697	2	mule
mure	6	59	4133	2	mure
muse	6	71	3603	2	muse
mute	6	51	3687	2	mute
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
nag	4	64	5081	2	nag_
nags	5	54	3602	2	nags
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
ohmage	12	9	506	2	ohmage
pace	8	63	4577	2	pace
paged	9	59	2678	2	paged
pager	8	47	2820	2	pager
pages	8	52	3507	2	pages
pale	6	60	5501	2	pale
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
parge	8	58	3185	2	parge
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
peage	8	47	2357	2	peage
phage	11	51	1367	2	phage
plage	8	45	2040	2	plage
race	6	67	4626	2	race
rag	4	57	6132	2	rag_
raga	5	59	3081	2	raga
raged	7	48	2945	2	raged
ragee	6	54	3266	2	ragee
rages	6	45	3944	2	rages
ragg	6	56	2269	2	ragg
ragi	5	60	3228	2	ragi
rags	5	54	4837	2	rags
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
range	6	47	2841	2	range
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
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
sag	4	61	6340	2	sag_
saga	5	53	3117	2	saga
sager	6	54	3205	2	sager
sages	6	53	3906	2	sages
sago	5	63	3267	2	sago
sags	5	59	4840	2	sags
sagy	8	53	2708	2	sagy
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sarge	6	55	3113	2	sarge
sate	4	55	5610	2	sate
save	7	57	4136	2	save
smaze	16	50	1293	2	smaze
stage	6	53	3019	2	stage
swage	9	49	1956	2	swage
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
tag	4	72	5949	2	tag_
tags	5	55	4523	2	tags
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
targe	6	52	2709	2	targe
tate	4	47	4860	2	tate
urge	5	47	2242	2	urge
usage	6	4	1021	2	usage
vagi	8	67	1936	2	vagi
vague	9	65	1311	2	vague
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
wag	7	64	5175	2	wag_
waged	10	48	2278	2	waged
wager	9	59	2505	2	wager
wages	9	53	3093	2	wages
wags	8	61	4055	2	wags
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
yag	7	69	4773	2	yag_
yager	9	56	1675	2	yager
yagi	8	69	2224	2	yagi
yags	8	66	3229	2	yags
yare	7	56	3694	2	yare
zag	13	75	3947	2	zag_
zags	14	68	2668	2	zags

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.280	638182.1
2	DLD Change Limit	29872	430	0.783	38150.7
3	Display Results	430	430	0.093	4623.7
	(SQL Overall)	178691	430	1.156	154577.0