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

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

370 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
fades	9	49	3286	(None)
cades	8	54	4073	1	cades
faces	10	64	3943	1	faces
fade	8	57	3634	1	fade_
faded	10	50	2524	1	faded
fader	9	44	2151	1	fader
faders	10	51	1746	1	faders
fadges	11	48	1403	1	fadges
fados	9	56	2073	1	fados
fads	8	69	3987	1	fad_s
fakes	12	60	3248	1	fakes
fames	10	57	3592	1	fames
fanes	8	46	3989	1	fanes
fares	8	58	5287	1	fares
fates	8	51	3923	1	fates
faves	11	53	3142	1	faves
faxes	15	57	2665	1	faxes
fazes	17	55	2721	1	fazes
hades	9	60	3511	1	hades
jades	13	52	2211	1	jades
lades	6	51	4127	1	lades
sades	6	52	3989	1	sades
wades	9	56	3414	1	wades
aces	6	76	4509	2	_aces
adds	6	76	2245	2	_adds
ados	5	76	3351	2	_ados
ads	4	97	5573	2	_ad_s
adzes	15	59	1380	2	_adzes
aedes	6	46	2515	2	aedes
ages	5	58	4459	2	_ages
aides	6	53	3660	2	aides
ales	4	70	6710	2	_ales
anes	4	52	5593	2	_anes
apes	6	60	4743	2	_apes
ares	4	58	7102	2	_ares
ates	4	50	4792	2	_ates
aves	7	61	4260	2	_aves
awes	7	60	3755	2	_awes
axes	11	73	3785	2	_axes
ayes	7	65	4351	2	_ayes
babes	9	58	3411	2	babes
bade	7	51	4088	2	bade_
badges	10	39	1737	2	badges
bads	7	70	4886	2	bad_s
bakes	11	70	3537	2	bakes
bales	7	62	5008	2	bales
banes	7	49	4558	2	banes
bardes	9	50	2693	2	bardes
bares	7	54	5713	2	bares
bases	7	56	4435	2	bases
bates	7	58	4634	2	bates
bides	8	55	3677	2	bides
blades	9	52	2125	2	blades
bodes	8	49	3510	2	bodes
cade	7	64	4391	2	cade_
cadet	8	53	3934	2	cadet
cadets	9	63	1651	2	cadets
cadges	10	47	1671	2	cadges
cadis	8	44	2850	2	cadis
cadres	9	40	1793	2	cadres
cads	7	61	4452	2	cad_s
cafes	10	64	2692	2	cafes
cages	8	59	3601	2	cages
cakes	11	60	3767	2	cakes
cames	9	70	4731	2	cames
canes	7	53	5037	2	canes
capes	9	54	4192	2	capes
cares	7	73	6918	2	cares
cases	7	50	4838	2	cases
cates	7	59	5189	2	cates
caves	10	56	3970	2	caves
cedes	8	49	2733	2	cedes
clades	9	49	2046	2	clades
codes	8	62	4729	2	codes
daces	8	50	3068	2	daces
dadas	7	58	1986	2	dadas
dadoes	8	56	1653	2	dadoes
dados	7	55	2243	2	dados
dads	6	74	4277	2	dad_s
dales	6	64	3974	2	dales
dames	8	54	3585	2	dames
dares	6	61	4670	2	dares
dates	6	56	3915	2	dates
dazes	15	50	2414	2	dazes
dudes	7	54	2437	2	dudes
eases	5	60	4161	2	eases
eaves	8	52	3199	2	eaves
evades	10	3	902	2	evades
fables	11	49	2167	2	fables
fabs	9	86	3586	2	fa_bs
facades	13	3	903	2	facades
face	9	61	4012	2	face_
faced	11	77	2765	2	faced
facer	10	55	2505	2	facer
facers	11	55	1944	2	facers
facet	10	60	3852	2	facet
facets	11	63	1665	2	facets
facies	11	39	2159	2	facies
facts	10	70	2189	2	facts
fad	7	74	5241	2	fad__
faddy	13	55	1162	2	faddy
fadein	10	6	884	2	fadein
fadeins	11	6	850	2	fadeins
fadge	10	48	1700	2	fadge
fadged	12	47	1236	2	fadged
fado	8	72	2646	2	fad_o
faeces	11	47	1312	2	faeces
fags	8	69	3912	2	fa_gs
fails	8	56	3148	2	fails
fairs	8	58	2544	2	fairs
fake	11	55	3494	2	fake_
faked	13	52	2548	2	faked
faker	12	48	2459	2	faker
fakers	13	42	1953	2	fakers
fakey	15	55	1542	2	fakey
falces	11	52	1600	2	falces
falls	8	57	2765	2	falls
false	8	48	1812	2	false
fame	9	56	3939	2	fame_
famed	11	59	2834	2	famed
fane	7	53	4357	2	fane_
fangs	9	62	2408	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fa_ns
farces	11	52	2332	2	farces
farded	11	45	1895	2	farded
fardel	10	47	1259	2	fardel
fardels	11	38	989	2	fardels
fards	9	66	2984	2	fards
fare	7	63	5446	2	fare_
fared	9	58	4234	2	fared
farer	8	67	3314	2	farer
farers	9	59	2405	2	farers
farles	9	60	2578	2	farles
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
fas	6	82	6293	2	fa__s
fasces	11	49	1454	2	fasces
fashes	12	45	2402	2	fashes
fasts	8	64	2968	2	fasts
fate	7	54	4428	2	fate_
fated	9	56	3213	2	fated
fats	7	62	5250	2	fa_ts
fauces	11	49	1615	2	fauces
fauns	8	45	1675	2	fauns
fauves	12	56	1042	2	fauves
favas	11	56	1859	2	favas
fave	10	55	3296	2	fave_
favus	11	43	1173	2	favus
fawns	11	59	1426	2	fawns
faxed	16	62	2053	2	faxed
fayed	12	64	2215	2	fayed
fays	10	85	3536	2	fa_ys
faze	16	56	3004	2	faze_
fazed	18	62	2296	2	fazed
feases	9	54	2292	2	feases
feazes	18	45	1417	2	feazes
feces	10	56	2536	2	feces
fedex	16	9	960	2	fedex
feds	8	52	3431	2	fed_s
feeds	9	49	2114	2	feeds
fees	7	64	5060	2	f_ees
femes	10	56	2622	2	femes
feres	8	60	3818	2	feres
fes	6	65	5167	2	f__es
fetes	8	56	3014	2	fetes
fezes	17	52	2002	2	fezes
fices	10	60	3116	2	fices
fidges	11	41	1439	2	fidges
fidos	9	58	1905	2	fidos
fids	8	70	3474	2	fid_s
fifes	11	48	2239	2	fifes
files	8	54	4127	2	files
fines	8	66	4426	2	fines
fires	8	57	4075	2	fires
fives	11	60	2736	2	fives
fixes	15	47	2359	2	fixes
flakes	13	41	1887	2	flakes
flames	11	47	2369	2	flames
flanes	9	45	2242	2	flanes
flares	9	45	2170	2	flares
flaxes	16	50	1535	2	flaxes
flees	8	58	2875	2	flees
flies	8	56	3071	2	flies
floes	8	55	2814	2	floes
flues	8	46	2692	2	flues
foes	7	65	4344	2	f_oes
fores	8	58	4710	2	fores
foxes	15	63	2109	2	foxes
frames	11	51	1986	2	frames
frees	8	61	3139	2	frees
fries	8	55	3560	2	fries
froes	8	61	2669	2	froes
fudges	11	43	1450	2	fudges
fuds	8	65	2856	2	fud_s
fumes	10	52	2470	2	fumes
fuses	8	56	2842	2	fuses
fuzes	17	51	2022	2	fuzes
fyces	13	98	1364	2	fyces
fykes	15	63	1269	2	fykes
gadis	7	48	2529	2	gadis
gads	6	78	4338	2	gad_s
gaes	5	63	4803	2	ga_es
gages	7	45	2997	2	gages
gales	6	54	4248	2	gales
games	8	62	3855	2	games
gapes	8	60	3082	2	gapes
gases	6	56	3399	2	gases
gates	6	59	3951	2	gates
gazes	15	54	2591	2	gazes
glades	8	48	2034	2	glades
grades	8	49	2631	2	grades
gudes	7	45	2081	2	gudes
hade	8	54	4019	2	hade_
haded	10	52	2762	2	haded
hadjes	17	52	1040	2	hadjes
haes	7	76	5102	2	ha_es
hajes	15	54	2094	2	hajes
hakes	12	60	3430	2	hakes
hales	8	54	4984	2	hales
hames	10	61	3870	2	hames
hares	8	62	5554	2	hares
hates	8	67	4257	2	hates
haves	11	60	3487	2	haves
hazes	17	49	2832	2	hazes
hides	9	51	2942	2	hides
ides	5	77	3423	2	_ides
irades	7	45	1739	2	irades
jade	12	53	2544	2	jade_
jaded	14	44	1703	2	jaded
jakes	16	50	2364	2	jakes
janes	12	49	2812	2	janes
japes	14	63	2282	2	japes
kadis	10	59	2106	2	kadis
kaes	8	57	3406	2	ka_es
kales	9	57	3098	2	kales
kames	11	50	2469	2	kames
kanes	9	55	2937	2	kanes
laces	7	61	4176	2	laces
lade	5	63	4598	2	lade_
laded	7	42	3261	2	laded
laden	6	50	2219	2	laden
ladens	7	45	1623	2	ladens
lader	6	56	3372	2	lader
laders	7	49	2776	2	laders
ladies	7	51	2488	2	ladies
ladles	7	46	1954	2	ladles
lads	5	65	4913	2	lad_s
lakes	9	57	3765	2	lakes
lames	7	54	4554	2	lames
lanes	5	49	4679	2	lanes
lares	5	48	5263	2	lares
lases	5	49	4476	2	lases
laves	8	60	3915	2	laves
laxes	12	54	3009	2	laxes
lazes	14	51	2957	2	lazes
lodes	6	64	3691	2	lodes
ludes	6	57	2885	2	ludes
mabes	9	63	3153	2	mabes
maces	9	71	3996	2	maces
made	7	54	4024	2	made_
madres	9	37	1818	2	madres
mads	7	68	4537	2	mad_s
maes	6	69	4840	2	ma_es
mages	8	50	3602	2	mages
makes	11	53	3685	2	makes
males	7	50	4979	2	males
manes	7	66	4896	2	manes
mares	7	64	5763	2	mares
mates	7	52	5136	2	mates
maxes	14	56	2953	2	maxes
mazes	16	56	3217	2	mazes
modes	8	55	3741	2	modes
nabes	7	54	2709	2	nabes
nadas	6	63	2081	2	nadas
names	7	48	3336	2	names
napes	7	48	2846	2	napes
nares	5	55	4415	2	nares
nates	5	52	3833	2	nates
naves	8	70	3038	2	naves
nides	6	52	2913	2	nides
nodes	6	46	3349	2	nodes
nudes	6	47	2329	2	nudes
oases	5	53	3098	2	oases
oaves	8	49	2561	2	oaves
odes	5	72	4324	2	_odes
paces	9	67	4111	2	paces
padis	8	62	2714	2	padis
padles	9	52	2112	2	padles
padres	9	50	1698	2	padres
pads	7	67	4295	2	pad_s
pages	8	52	3507	2	pages
pales	7	57	5380	2	pales
panes	7	61	4869	2	panes
pares	7	71	6448	2	pares
pases	7	53	4650	2	pases
pates	7	60	4789	2	pates
paves	10	48	3392	2	paves
paxes	14	49	2842	2	paxes
pedes	8	53	2729	2	pedes
qadis	15	59	1785	2	qadis
races	7	49	4324	2	races
rads	5	60	4660	2	rad_s
rages	6	45	3944	2	rages
rajes	12	50	2278	2	rajes
rakes	9	44	4035	2	rakes
rales	5	49	4749	2	rales
rapes	7	57	4072	2	rapes
rares	5	52	4744	2	rares
rases	5	54	4721	2	rases
rates	5	53	5201	2	rates
raves	8	54	4197	2	raves
raxes	12	47	2939	2	raxes
razes	14	50	3270	2	razes
redes	6	51	3913	2	redes
rides	6	61	4081	2	rides
rodes	6	140	3908	2	rodes
sabes	7	64	3746	2	sabes
sade	5	55	4447	2	sade_
sadhes	10	47	1537	2	sadhes
sadis	6	49	3085	2	sadis
safes	8	52	2672	2	safes
sages	6	53	3906	2	sages
sakes	9	55	4075	2	sakes
sales	5	60	5559	2	sales
sanes	5	56	4907	2	sanes
sates	5	49	4932	2	sates
saves	8	58	3863	2	saves
saxes	12	52	2934	2	saxes
shades	10	59	2453	2	shades
sides	6	58	3836	2	sides
spades	9	42	2258	2	spades
stades	7	46	2624	2	stades
tabes	7	60	3392	2	tabes
taces	7	62	3780	2	taces
tads	5	71	4394	2	tad_s
tajes	12	49	2069	2	tajes
takes	9	44	3779	2	takes
tales	5	54	5137	2	tales
tames	7	52	4201	2	tames
tapes	7	58	3860	2	tapes
tares	5	74	5656	2	tares
tates	5	54	4498	2	tates
taxes	12	47	3082	2	taxes
tides	6	48	3015	2	tides
trades	7	57	2450	2	trades
tsades	7	43	1099	2	tsades
vales	8	54	3426	2	vales
vanes	8	51	3097	2	vanes
vases	8	46	2626	2	vases
wade	8	52	3706	2	wade_
waded	10	60	2475	2	waded
wader	9	53	2536	2	wader
waders	10	91	2064	2	waders
wadies	10	51	2120	2	wadies
wadis	9	52	2396	2	wadis
wads	8	73	4314	2	wad_s
waes	7	60	4860	2	wa_es
wages	9	53	3093	2	wages
wakes	12	66	3365	2	wakes
wales	8	61	4283	2	wales
wames	10	64	3280	2	wames
wanes	8	50	4088	2	wanes
wares	8	82	5058	2	wares
waves	11	56	3392	2	waves
waxes	15	58	2550	2	waxes
wides	9	48	3282	2	wides
zaxes	21	51	1382	2	zaxes

Search took 3 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	53800	0.546	327272.9
2	DLD Change Limit	53800	370	1.720	31279.1
3	Display Results	370	370	0.110	3363.6
	(SQL Overall)	178691	370	2.376	75206.6