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

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

500 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
ace	5	96	5683	(None)
aced	7	95	4088	1	aced
aces	6	76	4509	1	aces
ache	9	68	2982	1	ache
acme	8	69	2432	1	acme
acne	6	66	2587	1	acne
acre	6	73	3077	1	acre
act	5	95	5784	1	act
ae	2	125	9029	1	a_e
age	4	71	5433	1	age
ale	3	65	7234	1	ale
ane	3	78	6694	1	ane
ape	5	72	5118	1	ape
are	3	78	7457	1	are
ate	3	70	5924	1	ate
ave	6	77	4870	1	ave
awe	6	77	4662	1	awe
axe	10	82	3949	1	axe
aye	6	71	5176	1	aye
dace	7	69	3492	1	dace
face	9	61	4012	1	face
ice	5	67	3724	1	ice
lace	6	68	4847	1	lace
mace	8	73	4578	1	mace
pace	8	63	4577	1	pace
race	6	67	4626	1	race
tace	6	53	4251	1	tace
aa	2	191	7995	2	a_a
aah	6	162	5296	2	aah
aal	3	90	5867	2	aal
aas	3	109	7539	2	aas
ab	4	106	7476	2	a_b
aba	5	128	5095	2	aba
abbe	8	76	2718	2	abbe
abed	7	97	3413	2	abed
abet	6	105	4794	2	abet
able	6	63	4053	2	able
abo	5	90	4596	2	abo
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
abye	9	79	2100	2	abye
acerb	9	3	1276	2	acerb
aceta	7	40	1735	2	aceta
ached	11	92	2783	2	ached
aches	10	61	3229	2	aches
achy	12	63	1609	2	achy
acid	7	75	3339	2	acid
ackee	11	58	2536	2	ackee
acmes	9	60	2065	2	acmes
acned	8	75	2066	2	acned
acnes	7	59	2262	2	acnes
acred	8	71	2635	2	acred
acres	7	63	2776	2	acres
acta	6	95	2480	2	acta
acted	8	85	2173	2	acted
acts	6	69	2986	2	acts
acute	7	47	2036	2	acute
acyl	9	53	1429	2	acyl
ad	3	119	7503	2	a_d
add	5	101	3236	2	add
ado	4	91	4687	2	ado
ads	4	97	5573	2	ads
adz	13	123	3286	2	adz
adze	14	128	2057	2	adze
aff	9	55	3761	2	aff
aft	6	68	4901	2	aft
ag	3	110	6746	2	a_g
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
ah	5	138	6879	2	a_h
aha	6	112	4664	2	aha
ahed	8	95	3625	2	ahed
ahem	9	72	2536	2	ahem
ahi	6	80	4023	2	ahi
ahs	6	86	4482	2	ahs
ai	2	112	8839	2	a_i
aid	4	92	6907	2	aid
aide	5	60	4499	2	aide
ail	3	71	7104	2	ail
aim	5	78	5821	2	aim
ain	3	75	7909	2	ain
air	3	80	5839	2	air
ais	3	90	8357	2	ais
ait	3	80	9390	2	ait
ajee	11	59	2823	2	ajee
akee	8	59	3681	2	akee
al	2	106	7404	2	a_l
ala	3	124	6360	2	ala
alae	4	56	4375	2	alae
alb	5	73	4265	2	alb
alec	6	64	3006	2	alec
alee	4	66	5232	2	alee
alef	7	63	4069	2	alef
ales	4	70	6710	2	ales
all	3	61	4823	2	all
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
am	4	118	7556	2	a_m
ama	5	108	5330	2	ama
amen	6	67	3315	2	amen
ami	5	66	4680	2	ami
amice	9	61	2286	2	amice
amie	6	63	3984	2	amie
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
an	2	118	7907	2	a_n
ana	3	95	5982	2	ana
and	4	72	4416	2	and
anes	4	52	5593	2	anes
anew	7	66	2313	2	anew
ani	3	77	5117	2	ani
ant	3	72	7078	2	ant
ante	4	65	3890	2	ante
any	6	84	4048	2	any
apace	9	47	1838	2	apace
aped	7	85	3815	2	aped
aper	6	63	3623	2	aper
apes	6	60	4743	2	apes
apex	13	72	2021	2	apex
apo	5	111	4212	2	apo
app	7	68	2760	2	app
apse	6	77	2538	2	apse
apt	5	73	5254	2	apt
ar	2	113	7938	2	a_r
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
arced	8	82	2416	2	arced
arch	9	86	2844	2	arch
arco	6	83	3154	2	arco
arcs	6	78	3478	2	arcs
area	4	58	4339	2	area
ares	4	58	7102	2	ares
arf	6	74	5337	2	arf
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
arse	4	65	3927	2	arse
art	3	86	7914	2	art
as	2	110	8307	2	a_s
asci	6	65	1914	2	asci
asea	4	63	2718	2	asea
ash	6	79	4460	2	ash
ask	7	71	3070	2	ask
asp	5	72	3534	2	asp
ass	3	78	4406	2	ass
at	2	123	9340	2	a_t
ates	4	50	4792	2	ates
att	3	54	5465	2	att
auk	7	62	3414	2	auk
ava	6	101	3932	2	ava
aver	7	59	3188	2	aver
aves	7	61	4260	2	aves
avo	6	89	3623	2	avo
aw	5	125	6340	2	a_w
awa	6	119	3967	2	awa
awed	8	84	3603	2	awed
awee	7	63	3664	2	awee
awes	7	60	3755	2	awes
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
ax	9	110	5778	2	a_x
axed	12	88	2961	2	axed
axel	11	52	2207	2	axel
axes	11	73	3785	2	axes
axle	11	64	2460	2	axle
ay	5	117	7389	2	a_y
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
babe	8	68	3581	2	babe
bach	11	61	3139	2	bach
back	12	55	3576	2	back
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5042	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bice	8	62	3555	2	bice
brace	9	56	2927	2	brace
bye	8	61	3459	2	bye
cab	7	83	5540	2	cab
caca	8	55	2808	2	caca
cache	12	51	2248	2	cache
cad	6	74	5636	2	cad
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
came	8	76	4875	2	came
can	5	77	6013	2	can
cane	6	66	5311	2	cane
cap	7	67	5898	2	cap
cape	8	72	4278	2	cape
car	5	91	6556	2	car
care	6	69	6837	2	care
case	6	58	4808	2	case
cat	5	82	8234	2	cat
cate	6	62	5459	2	cate
cave	9	59	4126	2	cave
caw	8	66	4793	2	caw
cay	8	71	5598	2	cay
cee	5	59	5270	2	cee
cel	5	60	4055	2	_cel
cep	7	57	3633	2	_cep
cue	5	75	4418	2	cue
daces	8	50	3068	2	daces
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dance	8	52	2313	2	dance
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
dice	7	58	4189	2	dice
die	4	67	5965	2	die
doe	4	73	6195	2	doe
duce	7	69	3350	2	duce
due	4	52	4986	2	due
dye	7	53	3484	2	dye
each	9	55	3058	2	each
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eche	9	75	2028	2	eche
ecu	5	68	2823	2	ecu
eke	7	56	3009	2	eke
eme	5	58	3718	2	eme
ere	3	63	5277	2	ere
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
eye	6	55	3977	2	eye
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
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4356	2	fane
farce	10	49	2532	2	farce
fare	7	63	5446	2	fare
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fe	5	79	4474	2	_fe
fee	6	68	6201	2	fee
fice	9	57	3711	2	fice
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
fyce	12	63	1683	2	fyce
gae	4	64	5770	2	gae
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
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
gee	4	53	5920	2	gee
gie	4	71	4954	2	gie
glace	8	74	2015	2	glace
grace	8	51	2454	2	grace
hacek	14	54	1184	2	hacek
hack	13	51	3454	2	hack
hade	8	54	4019	2	hade
hae	6	73	6400	2	hae
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hance	10	54	2415	2	hance
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
he	5	81	5195	2	_he
hie	6	76	5270	2	hie
hoe	6	75	6272	2	hoe
hue	6	66	4230	2	hue
iced	7	87	2189	2	iced
ices	6	61	2964	2	ices
ich	8	62	2774	2	ich
ick	9	73	2932	2	ick
icy	8	63	2212	2	icy
ire	3	69	4317	2	ire
jack	17	52	2486	2	jack
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3147	2	jane
jape	13	49	2342	2	jape
jee	10	66	4864	2	jee
joe	10	66	4235	2	joe
kae	7	67	4454	2	kae
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3396	2	kane
kue	7	66	3186	2	kue
kye	10	73	2727	2	kye
lac	5	101	5582	2	lac_
laced	8	71	3264	2	laced
lacer	7	58	3375	2	lacer
laces	7	61	4176	2	laces
lacey	10	58	2091	2	lacey
lack	10	58	3768	2	lack
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lance	7	51	2672	2	lance
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
lee	3	60	6814	2	lee
lice	6	60	4506	2	lice
lie	3	82	6452	2	lie
luce	6	51	3257	2	luce
lye	6	65	3341	2	lye
mabe	8	57	3334	2	mabe
mac	7	80	5392	2	mac_
maced	10	85	2869	2	maced
macer	9	121	2694	2	macer
maces	9	71	3996	2	maces
mach	11	61	3447	2	mach
mache	12	59	2530	2	mache
mack	12	57	3364	2	mack
macle	9	61	2700	2	macle
macs	8	67	4250	2	macs
made	7	54	4023	2	made
mae	5	76	5910	2	mae
mage	7	57	3912	2	mage
make	10	55	3788	2	make
male	6	60	5229	2	male
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
mice	8	74	4222	2	mice
nabe	6	60	2949	2	nabe
nacre	7	57	1536	2	nacre
nae	3	59	5274	2	nae
name	6	56	3741	2	name
nance	7	47	2184	2	nance
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
nice	6	55	3471	2	nice
obe	5	66	3864	2	obe
oca	5	67	3173	2	oca
ode	4	74	4658	2	ode
oe	2	84	7306	2	_oe
oke	7	58	3948	2	oke
ole	3	71	5521	2	ole
once	6	54	2308	2	once
one	3	70	5091	2	one
ope	5	68	4524	2	ope
ore	3	66	6183	2	ore
ose	3	81	4734	2	ose
owe	6	70	4103	2	owe
pac	7	90	5408	2	pac_
paca	8	51	3224	2	paca
paced	10	69	3168	2	paced
pacer	9	61	3161	2	pacer
paces	9	67	4111	2	paces
pacey	12	67	2028	2	pacey
pack	12	55	3544	2	pack
pacs	8	58	4218	2	pacs
pact	8	66	4872	2	pact
pacy	11	53	2868	2	pacy
page	7	60	3610	2	page
pale	6	60	5501	2	pale
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
pe	4	76	4903	2	_pe
peace	9	50	2608	2	peace
pec	7	67	4441	2	pec
pee	5	60	6651	2	pee
pice	8	46	4109	2	pice
pie	5	54	5740	2	pie
place	9	48	2461	2	place
puce	8	51	2788	2	puce
pye	8	64	3250	2	pye
raced	8	76	3531	2	raced
racer	7	52	3302	2	racer
races	7	49	4324	2	races
rack	10	62	3488	2	rack
racy	9	58	2568	2	racy
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rance	7	50	2851	2	rance
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
re	2	61	5374	2	_re
rec	5	56	4546	2	rec
ree	3	79	7407	2	ree
rice	6	49	4291	2	rice
roe	3	68	6107	2	roe
rue	3	55	4926	2	rue
rye	6	60	3254	2	rye
sabe	6	61	4057	2	sabe
sac	5	74	5286	2	sac_
sack	10	53	3731	2	sack
sacs	6	57	3907	2	sacs
sade	5	55	4447	2	sade
sae	3	83	6518	2	sae
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
saice	7	54	2405	2	saice
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5433	2	sane
sate	4	55	5610	2	sate
sauce	7	51	2165	2	sauce
save	7	57	4136	2	save
sec	5	59	4532	2	sec
see	3	57	7226	2	see
she	6	68	3769	2	she
sice	6	55	4559	2	sice
space	9	53	2567	2	space
sue	3	56	5146	2	sue
syce	9	58	2028	2	syce
taces	7	62	3780	2	taces
tacet	7	58	4002	2	tacet
tach	9	61	3275	2	tach
tache	10	62	2237	2	tache
tack	10	65	3629	2	tack
taco	6	70	3135	2	taco
tact	6	73	4903	2	tact
tae	3	82	6705	2	tae
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
tate	4	47	4860	2	tate
tee	3	83	6687	2	tee
the	6	74	3605	2	the
tie	3	65	5753	2	tie
toe	3	101	6685	2	toe
trace	7	58	2961	2	trace
tye	6	58	3744	2	tye
uke	7	57	2729	2	uke
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vac	8	65	3714	2	vac_
vacs	9	62	2620	2	vacs
vale	7	49	3734	2	vale
vane	7	55	3468	2	vane
vase	7	56	2965	2	vase
vee	6	57	5018	2	vee
vice	9	57	3285	2	vice
vie	6	54	4763	2	vie
voe	6	77	3905	2	voe
wack	13	53	3091	2	wack
wacke	14	59	1862	2	wacke
wade	8	52	3706	2	wade
wae	6	75	5695	2	wae
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wane	7	63	4471	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
we	5	70	4345	2	_we
wee	6	67	6081	2	wee
woe	6	66	5124	2	woe
wye	9	63	3197	2	wye
yack	13	54	2597	2	yack
yare	7	56	3694	2	yare
ye	5	76	5006	2	_ye
zee	12	61	4323	2	zee

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	500	0.466	30223.2
3	Display Results	500	500	0.110	4545.5
	(SQL Overall)	178691	500	0.639	279641.6