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

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

445 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
cade	7	64	4391	(None)
bade	7	51	4088	1	bade
cad	6	74	5636	1	cad_
cades	8	54	4073	1	cades
cadet	8	53	3934	1	cadet
cadge	9	40	1879	1	cadge
cadi	7	57	3218	1	cadi
cadre	8	54	1902	1	cadre
cads	7	61	4452	1	cads
cafe	9	52	3032	1	cafe
cage	7	53	3906	1	cage
cake	10	54	3996	1	cake
came	8	76	4875	1	came
cane	6	66	5312	1	cane
cape	8	72	4278	1	cape
care	6	69	6837	1	care
case	6	58	4808	1	case
cate	6	62	5460	1	cate
cave	9	59	4126	1	cave
cede	7	49	2877	1	cede
clade	8	58	2101	1	clade
code	7	73	4773	1	code
fade	8	57	3634	1	fade
hade	8	54	4019	1	hade
jade	12	53	2544	1	jade
lade	5	63	4598	1	lade
made	7	54	4024	1	made
sade	5	55	4447	1	sade
wade	8	52	3706	1	wade
ace	5	96	5683	2	_ace
aced	7	95	4088	2	aced
ache	9	68	2982	2	ache
acme	8	69	2432	2	acme
acne	6	66	2587	2	acne
acre	6	73	3077	2	acre
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
alcade	9	11	1151	2	alcade
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
ape	5	72	5118	2	_ape
arcade	9	10	1364	2	arcade
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
blade	8	59	2333	2	blade
bode	7	58	3875	2	bode
cab	7	83	5540	2	ca_b
caber	9	51	2683	2	caber
cable	9	53	2991	2	cable
cabs	8	67	3942	2	cabs
caca	8	55	2808	2	caca
cache	12	51	2248	2	cache
caddie	10	43	1645	2	caddie
caddy	12	54	1402	2	caddy
cadent	9	41	2036	2	cadent
cadets	9	63	1651	2	cadets
cadged	11	48	1234	2	cadged
cadger	10	50	1391	2	cadger
cadges	10	47	1671	2	cadges
cadgy	12	52	1078	2	cadgy
cadis	8	44	2850	2	cadis
cadres	9	40	1793	2	cadres
cafes	10	64	2692	2	cafes
caff	12	56	3167	2	caff
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
caid	7	78	3753	2	caid
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain
caked	12	61	2862	2	caked
cakes	11	60	3767	2	cakes
cakey	14	55	1727	2	cakey
caky	13	62	2244	2	caky
calf	9	63	3956	2	calf
calk	10	55	2766	2	calk
call	6	68	3867	2	call
calm	8	50	3236	2	calm
calo	6	49	3644	2	calo
calve	10	59	1992	2	calve
calx	13	57	2279	2	calx
cam	7	80	5898	2	ca_m
camel	9	68	2280	2	camel
cameo	9	59	2499	2	cameo
cames	9	70	4731	2	cames
camo	8	57	3175	2	camo
camp	10	63	3645	2	camp
cams	8	70	4728	2	cams
can	5	77	6014	2	ca_n
candle	9	43	2148	2	candle
candy	11	51	1982	2	candy
caned	8	58	3809	2	caned
caner	7	53	3477	2	caner
canes	7	53	5037	2	canes
canoe	7	56	2725	2	canoe
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
cap	7	67	5898	2	ca_p
caped	10	49	3180	2	caped
caper	9	48	3162	2	caper
capes	9	54	4192	2	capes
caph	11	66	2329	2	caph
capo	8	58	2921	2	capo
caps	8	71	4789	2	caps
car	5	91	6556	2	ca_r
carb	8	51	4316	2	carb
card	7	102	4587	2	card
carded	10	54	2490	2	carded
carder	9	45	2418	2	carder
cards	8	51	3793	2	cards
cared	8	60	5009	2	cared
carer	7	49	4233	2	carer
cares	7	73	6918	2	cares
caret	7	53	6056	2	caret
carex	14	48	2230	2	carex
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carle	7	45	3570	2	carle
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
carse	7	49	3433	2	carse
cart	6	65	7034	2	cart
carte	7	59	4042	2	carte
carve	10	62	2775	2	carve
casa	6	56	3086	2	casa
cased	8	60	3241	2	cased
cases	7	50	4838	2	cases
cash	9	66	3628	2	cash
cask	10	56	2643	2	cask
cast	6	71	5990	2	cast
caste	7	59	3236	2	caste
cat	5	82	8234	2	ca_t
cater	7	48	4072	2	cater
cates	7	59	5189	2	cates
cats	6	63	5634	2	cats
caudex	16	3	640	2	caudex
caudle	9	39	1291	2	caudle
caul	6	56	3000	2	caul
cause	7	52	2535	2	cause
caved	11	62	2756	2	caved
caver	10	56	2906	2	caver
caves	10	56	3970	2	caves
cavie	10	46	2159	2	cavie
cavy	12	59	2000	2	cavy
caw	8	66	4793	2	ca_w
cawed	11	66	2706	2	cawed
caws	9	60	3611	2	caws
cay	8	71	5598	2	ca_y
cays	9	54	3767	2	cays
cease	7	52	2765	2	cease
ceded	9	61	1856	2	ceded
ceder	8	53	2224	2	ceder
cedes	8	49	2733	2	cedes
cedi	7	49	1927	2	cedi
cee	5	59	5270	2	c_ee
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
chad	10	55	2550	2	chad_
chads	11	61	2223	2	chads
chafe	13	51	1735	2	chafe
chape	12	52	2114	2	chape
chare	10	52	3198	2	chare
chase	10	51	2712	2	chase
chide	11	53	2101	2	chide
cider	8	47	2331	2	cider
cine	6	62	4294	2	cine
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
clad	7	62	2582	2	clad_
clades	9	49	2046	2	clades
clads	8	57	2273	2	clads
clave	10	54	2015	2	clave
clue	6	53	2453	2	clue
cod	6	96	6012	2	cod_
coda	7	70	2934	2	coda
codec	10	71	2034	2	codec
coded	9	54	3318	2	coded
coden	8	61	2854	2	coden
coder	8	61	3422	2	coder
codes	8	62	4729	2	codes
codex	15	58	1758	2	codex
cods	7	68	4810	2	cods
coed	7	71	4054	2	coed
coke	10	70	3838	2	coke
cole	6	69	5611	2	cole
comade	11	44	1532	2	comade
come	8	75	4770	2	come
cone	6	72	5696	2	cone
cope	8	68	4738	2	cope
core	6	72	6311	2	core
cote	6	66	4873	2	cote
coude	8	50	2263	2	coude
cove	9	58	3707	2	cove
cradle	9	33	1316	2	cradle
crake	11	48	2352	2	crake
crane	7	53	3160	2	crane
crape	9	61	2844	2	crape
crate	7	65	3740	2	crate
crave	10	56	2631	2	crave
craze	16	52	2146	2	craze
cred	7	65	3088	2	cred
crude	8	60	1857	2	crude
cube	8	58	3021	2	cube
cud	6	79	3745	2	cud_
cuds	7	67	3047	2	cuds
cue	5	75	4418	2	c_ue
cued	7	63	2956	2	cued
cuke	10	58	2498	2	cuke
cure	6	61	4912	2	cure
cute	6	64	4045	2	cute
cyder	11	46	1113	2	cyder
cyme	11	94	2037	2	cyme
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
decade	10	42	1616	2	decade
dude	6	56	2966	2	dude
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eide	5	58	3224	2	eide
evade	9	3	818	2	evade
facade	12	3	880	2	facade
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
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
glade	7	51	2196	2	glade
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
lace	6	68	4847	2	lace
lad	4	81	6570	2	lad_
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
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5333	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
lode	5	62	4011	2	lode
lude	5	53	3164	2	lude
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
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
scad	7	57	2577	2	scad_
scads	8	54	1996	2	scads
scale	7	46	2914	2	scale
scape	9	69	2184	2	scape
scare	7	53	3446	2	scare
shade	9	51	2558	2	shade
side	5	54	4449	2	side
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	3814	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
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.296	603685.8
2	DLD Change Limit	29872	445	0.813	36742.9
3	Display Results	445	445	0.106	4198.1
	(SQL Overall)	178691	445	1.215	147070.8