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

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

373 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
fade	8	57	3634	(None)
bade	7	51	4088	1	bade
cade	7	64	4391	1	cade
face	9	61	4012	1	face
fad	7	74	5241	1	fad_
faded	10	50	2524	1	faded
fader	9	44	2151	1	fader
fades	9	49	3286	1	fades
fadge	10	48	1700	1	fadge
fado	8	72	2646	1	fado
fads	8	69	3987	1	fads
fake	11	55	3494	1	fake
fame	9	56	3939	1	fame
fane	7	53	4357	1	fane
fare	7	63	5446	1	fare
fate	7	54	4428	1	fate
fave	10	55	3296	1	fave
faze	16	56	3004	1	faze
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
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
ale	3	65	7234	2	_ale
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
blade	8	59	2333	2	blade
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
clade	8	58	2101	2	clade
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
evade	9	3	818	2	evade
fa	5	101	4845	2	fa__
fab	8	74	5313	2	fa_b
fable	10	58	2475	2	fable
fabs	9	86	3586	2	fabs
facade	12	3	880	2	facade
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
faddy	13	55	1162	2	faddy
fadein	10	6	884	2	fadein
faders	10	51	1746	2	faders
fadged	12	47	1236	2	fadged
fadges	11	48	1403	2	fadges
fados	9	56	2073	2	fados
fag	7	68	5236	2	fa_g
fags	8	69	3912	2	fags
fail	7	48	4024	2	fail
fain	7	58	4056	2	fain
fair	7	63	3252	2	fair
faked	13	52	2548	2	faked
faker	12	48	2459	2	faker
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
fall	7	55	3531	2	fall
false	8	48	1812	2	false
falx	14	71	2078	2	falx
famed	11	59	2834	2	famed
fames	10	57	3592	2	fames
fan	6	71	5886	2	fa_n
fanes	8	46	3989	2	fanes
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
far	6	77	6260	2	fa_r
farce	10	49	2532	2	farce
fard	8	56	3906	2	fard
farded	11	45	1895	2	farded
fardel	10	47	1259	2	fardel
fards	9	66	2984	2	fards
fared	9	58	4234	2	fared
farer	8	67	3314	2	farer
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl
farle	8	69	2924	2	farle
farm	9	59	3453	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fas	6	82	6293	2	fa_s
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fat	6	81	7808	2	fa_t
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
faun	7	62	2662	2	faun
fauve	11	47	1207	2	fauve
faux	14	65	1907	2	faux
fava	10	68	2026	2	fava
faves	11	53	3142	2	faves
fawn	10	53	2195	2	fawn
fax	13	81	4331	2	fa_x
faxed	16	62	2053	2	faxed
faxes	15	57	2665	2	faxes
fay	9	74	5486	2	fa_y
fayed	12	64	2215	2	fayed
fays	10	85	3536	2	fays
fazed	18	62	2296	2	fazed
fazes	17	55	2721	2	fazes
fe	5	79	4474	2	f__e
fease	8	48	2487	2	fease
feaze	17	52	1631	2	feaze
fed	7	65	4835	2	fed_
fedex	16	9	960	2	fedex
feds	8	52	3431	2	feds
fee	6	68	6201	2	f_ee
feed	8	45	3890	2	feed
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fice	9	57	3711	2	fice
fid	7	68	4769	2	fid_
fidge	10	45	1606	2	fidge
fido	8	77	2640	2	fido
fids	8	70	3474	2	fids
fie	6	71	5244	2	f_ie
fife	10	60	2770	2	fife
file	7	54	4664	2	file
fine	7	51	4795	2	fine
fire	7	62	4559	2	fire
five	10	76	2974	2	five
flake	12	51	1997	2	flake
flame	10	51	2444	2	flame
flare	8	48	2363	2	flare
fled	8	54	2977	2	fled
flee	7	62	3879	2	flee
floe	7	61	2977	2	floe
flue	7	53	2985	2	flue
foe	6	63	5081	2	f_oe
fore	7	83	5147	2	fore
frae	7	53	3047	2	frae
frame	10	58	2180	2	frame
free	7	59	4018	2	free
froe	7	53	2999	2	froe
fud	7	63	3515	2	fud_
fudge	10	53	1553	2	fudge
fuds	8	65	2856	2	fuds
fume	9	67	2763	2	fume
fuse	7	64	2999	2	fuse
fuze	16	64	2237	2	fuze
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
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
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	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
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 4 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.610	292936.1
2	DLD Change Limit	29872	373	2.283	13084.5
3	Display Results	373	373	0.093	4010.8
	(SQL Overall)	178691	373	2.986	59842.9