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

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

458 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
lace	6	68	4847	(None)
ace	5	96	5683	1	_ace
dace	7	69	3492	1	dace
face	9	61	4012	1	face
glace	8	74	2016	1	glace
lac	5	101	5582	1	lac_
laced	8	71	3264	1	laced
lacer	7	58	3375	1	lacer
laces	7	61	4176	1	laces
lacey	10	58	2091	1	lacey
lack	10	58	3768	1	lack
lacs	6	69	4248	1	lacs
lacy	9	58	2963	1	lacy
lade	5	63	4598	1	lade
lake	8	57	4160	1	lake
lame	6	68	4929	1	lame
lance	7	51	2672	1	lance
lane	4	51	5333	1	lane
lase	4	61	4851	1	lase
late	4	75	6048	1	late
lave	7	56	4214	1	lave
laze	13	62	3505	1	laze
lice	6	60	4506	1	lice
luce	6	51	3257	1	luce
mace	8	73	4579	1	mace
pace	8	63	4577	1	pace
place	9	48	2461	1	place
race	6	67	4626	1	race
tace	6	53	4251	1	tace
aced	7	95	4088	2	_aced
aces	6	76	4509	2	_aces
ache	9	68	2982	2	_ache
acme	8	69	2432	2	_acme
acne	6	66	2587	2	_acne
acre	6	73	3077	2	_acre
act	5	95	5784	2	_act
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
alack	11	48	2006	2	alack
alae	4	56	4375	2	alae
alane	5	61	3561	2	alane
alate	5	53	4033	2	alate
ale	3	65	7234	2	_ale
alec	6	64	3006	2	alec
alee	4	66	5232	2	alee
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
ane	3	78	6695	2	_ane
anlace	8	25	1392	2	anlace
apace	9	47	1838	2	apace
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
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	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
bice	8	62	3556	2	bice
black	13	47	1907	2	black
blade	8	59	2333	2	blade
blae	6	61	3464	2	bla_e
blame	9	56	2549	2	blame
blare	7	58	2623	2	blare
blase	7	55	2423	2	blase
blate	7	59	3378	2	blate
blaze	16	55	2083	2	blaze
brace	9	56	2927	2	brace
caca	8	55	2808	2	caca
cache	12	51	2248	2	cache
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
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
clach	12	46	1782	2	clach
clack	13	47	2017	2	clack
clade	8	58	2101	2	clade
clave	10	54	2015	2	clave
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
dice	7	58	4189	2	dice
duce	7	69	3350	2	duce
each	9	55	3058	2	each
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
elate	5	53	3588	2	elate
enlace	8	22	1323	2	enlace
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	4357	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
fice	9	57	3711	2	fice
flack	14	45	1941	2	flack
flake	12	51	1997	2	flake
flame	10	51	2444	2	flame
flare	8	48	2363	2	flare
fyce	12	63	1683	2	fyce
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
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
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
glaces	9	42	1803	2	glaces
glade	7	51	2196	2	glade
glance	9	43	1231	2	glance
glare	6	52	2296	2	glare
glaze	15	54	1816	2	glaze
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	ha_e
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
ice	5	67	3724	2	_ice
inlace	8	25	1304	2	inlace
jack	17	52	2486	2	jack
jade	12	53	2544	2	jade
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
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
la	2	192	6163	2	la__
lab	5	88	6478	2	la_b
label	7	50	1938	2	label
labs	6	71	4512	2	labs
lacers	8	52	2525	2	lacers
laches	11	65	2835	2	laches
lacier	8	40	2009	2	lacier
lacked	13	53	2465	2	lacked
lacker	12	53	2562	2	lacker
lackey	15	48	1335	2	lackey
lacks	11	61	2920	2	lacks
lacune	8	16	967	2	lacune
lad	4	81	6570	2	la_d
laded	7	42	3261	2	laded
laden	6	50	2219	2	laden
lader	6	56	3372	2	lader
lades	6	51	4127	2	lades
ladle	6	63	2044	2	ladle
lads	5	65	4913	2	lads
lady	8	65	2715	2	lady
lag	4	78	6212	2	la_g
lager	6	51	3286	2	lager
lags	5	65	4622	2	lags
laic	6	59	3156	2	laic
laich	10	59	2071	2	laich
laics	7	64	1925	2	laics
laid	5	64	3914	2	laid
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
laked	10	57	3112	2	laked
laker	9	54	3287	2	laker
lakes	9	57	3765	2	lakes
lakh	11	49	1995	2	lakh
laky	11	67	2582	2	laky
lall	4	55	3131	2	lall
lam	5	76	6671	2	la_m
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
lanced	9	37	1772	2	lanced
lancer	8	43	1997	2	lancer
lances	8	48	2410	2	lances
lancet	8	42	2357	2	lancet
land	5	63	3731	2	land
lanes	5	49	4679	2	lanes
lang	5	66	3739	2	lang
lank	8	47	3445	2	lank
lap	5	85	6527	2	la_p
lapel	7	37	1668	2	lapel
laps	6	68	4887	2	laps
lapse	7	49	1768	2	lapse
lar	3	79	6753	2	la_r
larch	10	59	1979	2	larch
lard	5	67	4200	2	lard
laree	5	60	3629	2	laree
lares	5	48	5263	2	lares
large	6	53	2546	2	large
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lased	6	51	3234	2	lased
laser	5	46	3332	2	laser
lases	5	49	4476	2	lases
lash	7	65	3965	2	lash
lass	4	74	4454	2	lass
last	4	62	6032	2	last
lat	3	75	9340	2	la_t
latch	10	46	2046	2	latch
lated	6	52	4067	2	lated
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lath	7	66	4038	2	lath
lathe	8	56	2672	2	lathe
lati	4	64	3827	2	lati
latke	9	48	1709	2	latke
lats	4	59	6270	2	lats
latte	5	54	2630	2	latte
latu	4	79	3418	2	latu
laud	5	65	2772	2	laud
launce	8	46	918	2	launce
lav	6	68	4734	2	la_v
lava	7	67	2542	2	lava
laved	9	50	2859	2	laved
laver	8	50	3179	2	laver
laves	8	60	3915	2	laves
lavs	7	67	3415	2	lavs
law	6	86	5664	2	la_w
lawed	9	60	2832	2	lawed
lawn	7	59	2563	2	lawn
laws	7	64	4168	2	laws
lax	10	76	5152	2	la_x
laxer	12	54	2033	2	laxer
laxes	12	54	3009	2	laxes
lay	6	88	6535	2	la_y
layed	9	51	2738	2	layed
layer	8	46	2647	2	layer
lays	7	60	4325	2	lays
lazed	15	49	2584	2	lazed
lazes	14	51	2957	2	lazes
lazy	16	64	2307	2	lazy
leach	10	54	2252	2	leach
lease	5	52	3026	2	lease
leave	8	47	2372	2	leave
lech	9	68	2544	2	lech
lee	3	60	6814	2	l_ee
leke	8	55	2740	2	leke
liane	5	47	2066	2	liane
lich	9	62	3084	2	lich
lick	10	69	3507	2	lick
lie	3	82	6452	2	l_ie
life	7	54	3373	2	life
like	8	60	4084	2	like
lime	6	62	4493	2	lime
line	4	69	6557	2	line
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lite	4	70	5454	2	lite
live	7	65	4099	2	live
loach	10	51	1636	2	loach
lobe	6	55	3536	2	lobe
loca	6	55	2768	2	loca
loch	9	55	2713	2	loch
loci	6	61	2628	2	loci
lock	10	61	3436	2	lock
loco	6	70	3074	2	loco
lode	5	62	4011	2	lode
loge	5	68	3719	2	loge
lone	4	58	4913	2	lone
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
love	7	52	3476	2	love
lowe	7	54	3531	2	lowe
lube	6	47	3156	2	lube
luces	7	55	2843	2	luces
luck	10	53	2982	2	luck
lucre	7	64	1552	2	lucre
lude	5	53	3164	2	lude
luge	5	55	3164	2	luge
lune	4	71	4049	2	lune
lure	4	51	4246	2	lure
lute	4	63	4101	2	lute
luxe	11	52	2269	2	luxe
lyase	8	55	1241	2	lyase
lycea	10	41	894	2	lycea
lycee	10	47	1674	2	lycee
lych	12	60	1576	2	lych
lye	6	65	3341	2	l_ye
lyre	7	56	2379	2	lyre
lyse	7	63	2059	2	lyse
mabe	8	57	3336	2	mabe
mac	7	80	5393	2	mac_
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
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
mage	7	57	3913	2	mage
make	10	55	3789	2	make
male	6	60	5230	2	male
mane	6	50	5203	2	mane
mare	6	47	5933	2	mare
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
mice	8	74	4223	2	mice
nabe	6	60	2949	2	nabe
nacre	7	57	1536	2	nacre
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nance	7	47	2184	2	nance
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nice	6	55	3471	2	nice
once	6	54	2308	2	once
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
palace	10	45	1692	2	palace
pale	6	60	5501	2	pale
pane	6	49	5029	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
peace	9	50	2608	2	peace
pice	8	46	4109	2	pice
placed	11	43	1800	2	placed
placer	10	51	1774	2	placer
places	10	43	2370	2	places
placet	10	39	2367	2	placet
plack	13	50	1784	2	plack
plage	8	45	2040	2	plage
plaice	10	3	1155	2	plaice
plane	7	49	2914	2	plane
plate	7	46	3511	2	plate
puce	8	51	2788	2	puce
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
relace	8	31	2215	2	relace
rice	6	49	4291	2	rice
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	sa_e
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	5434	2	sane
sate	4	55	5610	2	sate
sauce	7	51	2165	2	sauce
save	7	57	4136	2	save
sice	6	55	4559	2	sice
slack	11	50	2176	2	slack
slake	9	37	2405	2	slake
slate	5	54	3828	2	slate
slave	8	42	2403	2	slave
slice	7	49	2582	2	slice
solace	8	34	1582	2	solace
space	9	53	2567	2	space
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	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3815	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
trace	7	58	2961	2	trace
unlace	8	22	1517	2	unlace
vac	8	65	3714	2	vac_
vacs	9	62	2620	2	vacs
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vice	9	57	3285	2	vice
wack	13	53	3091	2	wack
wacke	14	59	1862	2	wacke
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
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
yack	13	54	2597	2	yack
yare	7	56	3694	2	yare

Search took 7 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	1.033	172982.6
2	DLD Change Limit	29872	458	4.890	6108.8
3	Display Results	458	458	0.780	587.2
	(SQL Overall)	178691	458	6.703	26658.4