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

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

467 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
lade	5	63	4598	(None)
bade	7	51	4088	1	bade
blade	8	59	2333	1	blade
cade	7	64	4391	1	cade
clade	8	58	2101	1	clade
fade	8	57	3634	1	fade
glade	7	51	2196	1	glade
hade	8	54	4019	1	hade
jade	12	53	2544	1	jade
lace	6	68	4847	1	lace
lad	4	81	6570	1	lad_
laded	7	42	3261	1	laded
laden	6	50	2219	1	laden
lader	6	56	3372	1	lader
lades	6	51	4127	1	lades
ladle	6	63	2044	1	ladle
lads	5	65	4913	1	lads
lady	8	65	2715	1	lady
lake	8	57	4160	1	lake
lame	6	68	4929	1	lame
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
lode	5	62	4011	1	lode
lude	5	53	3164	1	lude
made	7	54	4024	1	made
sade	5	55	4447	1	sade
wade	8	52	3706	1	wade
ace	5	96	5683	2	_ace
ad	3	119	7503	2	_ad_
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
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
aide	5	60	4500	2	aide
alae	4	56	4375	2	alae
alane	5	61	3561	2	alane
alate	5	53	4033	2	alate
alcade	9	11	1151	2	alcade
alder	6	54	2191	2	alder
ale	3	65	7234	2	_ale
alee	4	66	5232	2	alee
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
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
bad	6	77	6315	2	bad_
badge	9	48	1969	2	badge
bads	7	70	4886	2	bads
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
barde	8	53	3077	2	barde
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
bide	7	60	4150	2	bide
bladed	10	47	1776	2	bladed
blader	9	36	1858	2	blader
blades	9	52	2125	2	blades
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
bode	7	58	3875	2	bode
cad	6	74	5636	2	cad_
cades	8	54	4073	2	cades
cadet	8	53	3934	2	cadet
cadge	9	40	1879	2	cadge
cadi	7	57	3218	2	cadi
cadre	8	54	1902	2	cadre
cads	7	61	4452	2	cads
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
cede	7	49	2877	2	cede
clad	7	62	2582	2	clad_
clades	9	49	2046	2	clades
clads	8	57	2273	2	clads
clave	10	54	2015	2	clave
code	7	73	4773	2	code
dace	7	69	3492	2	dace
dad	5	84	5616	2	dad_
dada	6	64	2244	2	dada
dado	6	71	2633	2	dado
dads	6	74	4277	2	dads
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
de	3	70	4954	2	__de
dude	6	56	2966	2	dude
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eide	5	58	3224	2	eide
elate	5	53	3588	2	elate
elide	6	49	2264	2	elide
elude	6	45	1762	2	elude
evade	9	3	818	2	evade
face	9	61	4012	2	face
fad	7	74	5241	2	fad_
faded	10	50	2524	2	faded
fader	9	44	2151	2	fader
fades	9	49	3286	2	fades
fadge	10	48	1700	2	fadge
fado	8	72	2646	2	fado
fads	8	69	3987	2	fads
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
flake	12	51	1997	2	flake
flame	10	51	2444	2	flame
flare	8	48	2363	2	flare
gad	5	75	5665	2	gad_
gadi	6	63	2972	2	gadi
gadje	14	5	774	2	gadje
gads	6	78	4338	2	gads
gae	4	64	5770	2	ga_e
gaed	6	60	3151	2	gaed
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
glace	8	74	2016	2	glace
glad	6	56	2401	2	glad_
glades	8	48	2034	2	glades
glads	7	56	2061	2	glads
glady	10	54	1394	2	glady
glare	6	52	2296	2	glare
glaze	15	54	1816	2	glaze
glede	7	55	1783	2	glede
glide	7	45	2159	2	glide
grade	7	51	2609	2	grade
gude	6	54	2333	2	gude
had	7	76	5876	2	had_
haded	10	52	2762	2	haded
hades	9	60	3511	2	hades
hadj	15	58	1867	2	hadj
hae	6	73	6400	2	ha_e
haed	8	63	3858	2	haed
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
hide	8	51	3464	2	hide
irade	6	56	1815	2	irade
jaded	14	44	1703	2	jaded
jades	13	52	2211	2	jades
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
kadi	9	62	2483	2	kadi
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
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
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
ladder	8	46	1762	2	ladder
laddie	8	37	1317	2	laddie
ladens	7	45	1623	2	ladens
laders	7	49	2776	2	laders
ladies	7	51	2488	2	ladies
ladled	8	50	1348	2	ladled
ladler	7	43	1493	2	ladler
ladles	7	46	1954	2	ladles
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
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
lance	7	51	2672	2	lance
land	5	63	3731	2	land
landed	8	46	1924	2	landed
lander	7	40	2848	2	lander
lands	6	54	2690	2	lands
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
lard	5	67	4200	2	lard
larded	8	43	1909	2	larded
larder	7	37	2097	2	larder
lards	6	53	3186	2	lards
lardy	9	61	1927	2	lardy
laree	5	60	3630	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
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
lauded	8	38	1215	2	lauded
lauder	7	38	1501	2	lauder
lauds	6	56	1848	2	lauds
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
lead	5	60	3885	2	lead_
leaded	8	42	2154	2	leaded
leaden	7	45	1522	2	leaden
leader	7	48	2465	2	leader
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
lease	5	52	3026	2	lease
leave	8	47	2372	2	leave
led	4	62	5455	2	led_
ledge	7	65	1949	2	ledge
lee	3	60	6814	2	l_ee
leke	8	55	2740	2	leke
liane	5	47	2066	2	liane
lice	6	60	4506	2	lice
lid	4	74	5352	2	lid_
lido	5	60	2816	2	lido
lids	5	63	3646	2	lids
lie	3	82	6452	2	l_ie
lied	5	58	3809	2	lied
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
load	5	67	3060	2	load_
loaded	8	46	1687	2	loaded
loader	7	43	1631	2	loader
loads	6	53	2337	2	loads
lobe	6	55	3536	2	lobe
loden	6	66	2114	2	loden
lodes	6	64	3691	2	lodes
lodge	7	65	2009	2	lodge
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
ludes	6	57	2885	2	ludes
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	3336	2	mabe
mace	8	73	4579	2	mace
mad	6	89	5871	2	mad_
madre	8	57	2017	2	madre
mads	7	68	4537	2	mads
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
mode	7	58	4030	2	mode
nabe	6	60	2949	2	nabe
nada	5	80	2290	2	nada
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nide	5	55	3579	2	nide
node	5	130	3688	2	node
nude	5	66	2627	2	nude
ode	4	74	4658	2	_ode
pace	8	63	4577	2	pace
pad	6	80	5732	2	pad_
padi	7	63	3178	2	padi
padle	8	45	2234	2	padle
padre	8	60	1816	2	padre
pads	7	67	4295	2	pads
page	7	60	3610	2	page
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
place	9	48	2461	2	place
plage	8	45	2040	2	plage
plane	7	49	2914	2	plane
plate	7	46	3511	2	plate
qadi	14	56	2110	2	qadi
race	6	67	4626	2	race
rad	4	76	6200	2	rad_
rads	5	60	4660	2	rads
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
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
rede	5	50	3767	2	rede
ride	5	59	4513	2	ride
rode	5	58	4430	2	rode
rude	5	56	3278	2	rude
sabe	6	61	4057	2	sabe
sad	4	74	5920	2	sad_
sades	6	52	3989	2	sades
sadhe	9	48	1513	2	sadhe
sadi	5	58	3464	2	sadi
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
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
shade	9	51	2558	2	shade
side	5	54	4449	2	side
slake	9	37	2405	2	slake
slate	5	54	3828	2	slate
slave	8	42	2403	2	slave
slide	6	47	2541	2	slide
spade	8	44	2332	2	spade
stade	6	48	2530	2	stade
tace	6	53	4251	2	tace
tad	4	79	5982	2	tad_
tads	5	71	4394	2	tads
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
tide	5	52	3738	2	tide
trade	6	50	2604	2	trade
tsade	6	43	1112	2	tsade
unde	5	58	2548	2	unde
unlade	7	27	1415	2	unlade
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vide	8	54	3276	2	vide
wad	7	70	5389	2	wad_
waded	10	60	2475	2	waded
wader	9	53	2536	2	wader
wades	9	56	3414	2	wades
wadi	8	62	2817	2	wadi
wads	8	73	4314	2	wads
wady	11	53	2499	2	wady
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
wide	8	52	3541	2	wide
yare	7	56	3694	2	yare

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.330	541487.9
2	DLD Change Limit	29872	467	1.390	21490.6
3	Display Results	467	467	0.123	3796.7
	(SQL Overall)	178691	467	1.843	96956.6