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

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

443 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
lake	8	57	4160	(None)
bake	10	56	3751	1	bake
cake	10	54	3996	1	cake
fake	11	55	3494	1	fake
flake	12	51	1997	1	flake
hake	11	56	3784	1	hake
jake	15	59	2577	1	jake
lace	6	68	4847	1	lace
lade	5	63	4598	1	lade
laked	10	57	3112	1	laked
laker	9	54	3287	1	laker
lakes	9	57	3765	1	lakes
lakh	11	49	1995	1	lakh
laky	11	67	2582	1	laky
lame	6	68	4929	1	lame
lane	4	51	5332	1	lane
lase	4	61	4851	1	lase
late	4	75	6048	1	late
latke	9	48	1709	1	latke
lave	7	56	4214	1	lave
laze	13	62	3505	1	laze
leke	8	55	2740	1	leke
like	8	60	4084	1	like
make	10	55	3788	1	make
rake	8	48	4157	1	rake
sake	8	52	4496	1	sake
slake	9	37	2405	1	slake
take	8	47	3926	1	take
wake	11	49	3570	1	wake
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
akee	8	59	3681	2	_akee
alae	4	56	4375	2	alae
alane	5	61	3561	2	alane
alate	5	53	4032	2	alate
ale	3	65	7234	2	_ale
alee	4	66	5232	2	alee
alike	9	55	2396	2	alike
alkie	9	55	2003	2	alkie
alky	11	59	2034	2	alky
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
ane	3	78	6694	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
awake	12	50	1478	2	awake
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
baked	12	61	3077	2	baked
baker	11	56	2954	2	baker
bakes	11	70	3537	2	bakes
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
bike	10	65	3259	2	bike
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
bloke	11	43	1663	2	bloke
brake	11	60	2534	2	brake
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
caked	12	61	2862	2	caked
cakes	11	60	3767	2	cakes
cakey	14	55	1727	2	cakey
caky	13	62	2244	2	caky
came	8	76	4875	2	came
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
clade	8	58	2101	2	clade
clave	10	54	2015	2	clave
coke	10	70	3838	2	coke
crake	11	48	2352	2	crake
cuke	10	58	2498	2	cuke
dace	7	69	3492	2	dace
dak	8	63	4069	2	dak_
daks	9	71	3060	2	daks
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
deke	9	52	2876	2	deke
dike	9	59	3576	2	dike
drake	10	49	1830	2	drake
duke	9	56	2810	2	duke
dyke	12	64	1818	2	dyke
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eke	7	56	3009	2	_eke
elate	5	53	3588	2	elate
face	9	61	4012	2	face
fade	8	57	3634	2	fade
faked	13	52	2548	2	faked
faker	12	48	2459	2	faker
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
fame	9	56	3939	2	fame
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
flak	11	60	2617	2	flak_
flaked	14	47	1565	2	flaked
flaker	13	49	1617	2	flaker
flakes	13	41	1887	2	flakes
flakey	16	44	1051	2	flakey
flaky	15	57	1558	2	flaky
flame	10	51	2444	2	flame
flare	8	48	2363	2	flare
fluke	12	50	1689	2	fluke
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
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
glace	8	74	2015	2	glace
glade	7	51	2196	2	glade
glare	6	52	2295	2	glare
glaze	15	54	1816	2	glaze
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
hakes	12	60	3430	2	hakes
haku	11	69	2389	2	haku
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
hike	11	68	3039	2	hike
hoke	11	59	3593	2	hoke
jade	12	53	2544	2	jade
jakes	16	50	2364	2	jakes
jane	11	50	3147	2	jane
jape	13	49	2342	2	jape
joke	15	59	2616	2	joke
juke	15	47	2166	2	juke
kae	7	67	4454	2	ka_e
kaka	7	65	1868	2	kaka
kaki	7	65	2091	2	kaki
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3396	2	kane
kike	7	65	2478	2	kike
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
lac	5	101	5582	2	la_c
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
lacked	13	53	2465	2	lacked
lacker	12	53	2562	2	lacker
lackey	15	48	1335	2	lackey
lacks	11	61	2920	2	lacks
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
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
laid	5	64	3914	2	laid
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
lakers	10	52	2515	2	lakers
lakhs	12	52	1034	2	lakhs
lakier	10	47	1627	2	lakier
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
lance	7	51	2672	2	lance
land	5	63	3730	2	land
lanes	5	49	4679	2	lanes
lang	5	66	3737	2	lang
lank	8	47	3444	2	lank
lanker	10	41	2300	2	lanker
lanky	12	55	1748	2	lanky
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
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
larked	11	45	1947	2	larked
larker	10	45	1924	2	larker
larks	9	52	2781	2	larks
larky	12	52	1887	2	larky
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
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	2671	2	lathe
lati	4	64	3827	2	lati
latkes	10	47	1587	2	latkes
lats	4	59	6270	2	lats
latte	5	54	2630	2	latte
latu	4	79	3418	2	latu
laud	5	65	2772	2	laud
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
leak	8	62	3371	2	leak_
leaked	11	42	1770	2	leaked
leaker	10	46	2007	2	leaker
leaks	9	59	2391	2	leaks
leaky	12	52	1772	2	leaky
lease	5	52	3026	2	lease
leave	8	47	2372	2	leave
lee	3	60	6814	2	l_ee
leek	8	53	3173	2	leek
lek	7	56	4030	2	lek_
leks	8	54	2760	2	leks
leku	8	65	1991	2	leku
liane	5	47	2066	2	liane
lice	6	60	4506	2	lice
lie	3	82	6452	2	l_ie
life	7	54	3373	2	life
liked	10	45	2381	2	liked
liken	9	118	1884	2	liken
liker	9	56	2706	2	liker
likes	9	62	3190	2	likes
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
lobe	6	55	3536	2	lobe
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
luce	6	51	3257	2	luce
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
lye	6	65	3341	2	l_ye
lyre	7	56	2379	2	lyre
lyse	7	63	2059	2	lyse
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
maker	11	41	2781	2	maker
makes	11	53	3685	2	makes
mako	10	56	2235	2	mako
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
mike	10	55	3528	2	mike
moke	10	62	3422	2	moke
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
naked	10	53	2085	2	naked
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nuke	8	59	2075	2	nuke
oak	7	62	3865	2	oak_
oaken	9	58	1438	2	oaken
oaks	8	65	2790	2	oaks
oaky	11	64	1995	2	oaky
oke	7	58	3948	2	_oke
pace	8	63	4577	2	pace
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
peke	10	59	2620	2	peke
pike	10	63	3521	2	pike
place	9	48	2461	2	place
plage	8	45	2040	2	plage
plane	7	49	2914	2	plane
plate	7	46	3511	2	plate
poke	10	53	3536	2	poke
puke	10	50	2546	2	puke
quake	18	41	1464	2	quake
race	6	67	4626	2	race
rage	5	57	4235	2	rage
raked	10	58	3142	2	raked
rakee	9	60	3117	2	rakee
raker	9	45	2979	2	raker
rakes	9	44	4035	2	rakes
raki	8	71	2783	2	raki
raku	8	54	2377	2	raku
rale	4	50	5056	2	rale
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
ryke	11	56	1640	2	ryke
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
saker	9	51	3202	2	saker
sakes	9	55	4075	2	sakes
saki	8	56	2847	2	saki
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5433	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
shake	12	47	2640	2	shake
sike	8	71	3878	2	sike
slaked	11	43	1827	2	slaked
slaker	10	42	1927	2	slaker
slakes	10	40	2188	2	slakes
slate	5	54	3828	2	slate
slave	8	42	2403	2	slave
snake	9	48	2111	2	snake
soke	8	54	3626	2	soke
spake	11	43	2274	2	spake
splake	12	5	978	2	splake
stake	9	59	2753	2	stake
syke	11	54	2056	2	syke
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
taka	8	76	2359	2	taka
taken	9	48	1914	2	taken
taker	9	52	2900	2	taker
takes	9	44	3779	2	takes
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
tike	8	55	3448	2	tike
toke	8	67	3849	2	toke
tyke	11	57	2050	2	tyke
uke	7	57	2729	2	_uke
vale	7	49	3734	2	vale
vane	7	55	3468	2	vane
vase	7	56	2965	2	vase
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
waked	13	56	2675	2	waked
waken	12	48	1847	2	waken
waker	12	55	2659	2	waker
wakes	12	66	3365	2	wakes
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
woke	11	55	2796	2	woke
yak	10	70	3856	2	yak_
yaks	11	60	2520	2	yaks
yare	7	56	3694	2	yare
yoke	11	56	2639	2	yoke

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.063	2836365.1
2	DLD Change Limit	29872	443	1.046	28558.3
3	Display Results	443	443	0.110	4027.3
	(SQL Overall)	178691	443	1.219	146588.2