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

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

430 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
hade	8	54	4019	(None)
bade	7	51	4088	1	bade
cade	7	64	4391	1	cade
fade	8	57	3634	1	fade
had	7	76	5876	1	had_
haded	10	52	2762	1	haded
hades	9	60	3511	1	hades
hadj	15	58	1867	1	hadj
hae	6	73	6400	1	ha_e
haed	8	63	3858	1	haed
hake	11	56	3784	1	hake
hale	7	60	5283	1	hale
hame	9	70	4313	1	hame
hare	7	62	5573	1	hare
hate	7	84	5017	1	hate
have	10	61	3707	1	have
haze	16	48	3339	1	haze
hide	8	51	3464	1	hide
jade	12	53	2544	1	jade
lade	5	63	4598	1	lade
made	7	54	4024	1	made
sade	5	55	4447	1	sade
shade	9	51	2558	1	shade
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
ahed	8	95	3625	2	ahed
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
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
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
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
ha	5	102	5994	2	ha__
haaf	10	62	2773	2	haaf
haar	7	73	2349	2	haar
habu	9	73	2548	2	habu
hacek	14	54	1184	2	hacek
hack	13	51	3454	2	hack
hadal	9	55	1812	2	hadal
hadjee	17	41	1182	2	hadjee
hadjes	17	52	1040	2	hadjes
hadji	16	83	989	2	hadji
hadst	9	32	2022	2	hadst
haem	9	57	3098	2	haem
haen	7	62	2945	2	haen
haes	7	76	5102	2	haes
haet	7	56	5950	2	haet
haft	10	59	4184	2	haft
hag	7	72	5574	2	ha_g
hags	8	67	4084	2	hags
hah	9	106	5522	2	ha_h
haha	10	78	2106	2	haha
hahs	10	83	3336	2	hahs
haik	11	55	2698	2	haik
hail	7	48	3906	2	hail
hair	7	63	3014	2	hair
haj	13	81	4060	2	ha_j
hajes	15	54	2094	2	hajes
haji	14	85	2019	2	haji
hajj	13	83	1247	2	hajj
hakes	12	60	3430	2	hakes
haku	11	69	2389	2	haku
haled	9	53	3582	2	haled
haler	8	50	3352	2	haler
hales	8	54	4984	2	hales
half	10	62	3845	2	half
halide	10	34	1799	2	halide
hall	7	57	4116	2	hall
halm	9	58	3497	2	halm
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
halve	11	48	1892	2	halve
ham	8	63	6328	2	ha_m
hames	10	61	3870	2	hames
hams	9	64	4613	2	hams
hance	10	54	2415	2	hance
hand	8	68	3371	2	hand
handed	11	49	1998	2	handed
hander	10	45	2643	2	hander
handle	10	42	1929	2	handle
hands	9	53	2738	2	hands
handy	12	55	2087	2	handy
hang	8	55	3556	2	hang
hank	11	51	3414	2	hank
hanse	8	57	2279	2	hanse
hant	7	54	6159	2	hant
hao	6	72	5112	2	ha_o
haole	8	48	2008	2	haole
hap	8	73	6005	2	ha_p
haps	9	64	4346	2	haps
hard	8	54	4350	2	hard
harden	10	57	1853	2	harden
harder	10	50	2240	2	harder
hards	9	64	3565	2	hards
hardy	12	56	2206	2	hardy
hared	9	57	4218	2	hared
harem	10	49	2445	2	harem
hares	8	62	5554	2	hares
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3779	2	harm
harp	9	61	3429	2	harp
hart	7	68	6577	2	hart
has	6	73	7265	2	ha_s
hash	10	69	3650	2	hash
hasp	9	66	2729	2	hasp
hast	7	62	5948	2	hast
haste	8	59	2786	2	haste
hat	6	72	8996	2	ha_t
hated	9	57	3402	2	hated
hater	8	50	3475	2	hater
hates	8	67	4257	2	hates
hath	10	59	3391	2	hath
hats	7	68	5825	2	hats
haul	7	55	3045	2	haul
haut	7	59	4973	2	haut
haute	8	95	2161	2	haute
haven	11	47	1853	2	haven
haver	11	51	2446	2	haver
haves	11	60	3487	2	haves
haw	9	71	5327	2	ha_w
hawed	12	60	2542	2	hawed
hawk	14	55	2115	2	hawk
haws	10	64	3944	2	haws
hawse	11	60	1512	2	hawse
hay	9	73	5877	2	ha_y
hayed	12	58	2201	2	hayed
hayer	11	46	2024	2	hayer
hayey	14	48	1253	2	hayey
hays	10	61	3807	2	hays
hazed	18	52	2220	2	hazed
hazel	17	64	1481	2	hazel
hazer	17	48	2023	2	hazer
hazes	17	49	2832	2	hazes
hazy	19	181	1919	2	hazy
he	5	81	5195	2	h__e
head	8	71	3717	2	head_
headed	11	40	2047	2	headed
header	10	44	2254	2	header
heads	9	51	2711	2	heads
heady	12	51	1726	2	heady
heave	11	45	2181	2	heave
hebe	9	64	2470	2	hebe
heder	9	56	2364	2	heder
hedge	10	53	1735	2	hedge
heed	8	64	3760	2	heed
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hexade	17	43	890	2	hexade
hid	7	62	4838	2	hid_
hided	10	52	2244	2	hided
hider	9	50	2408	2	hider
hides	9	51	2942	2	hides
hie	6	76	5270	2	h_ie
hied	8	54	3404	2	hied
hike	11	68	3039	2	hike
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
hod	7	68	5246	2	hod_
hods	8	72	3986	2	hods
hoe	6	75	6272	2	h_oe
hoed	8	78	3798	2	hoed
hoke	11	59	3593	2	hoke
hole	7	75	5339	2	hole
home	9	80	4244	2	home
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
horde	9	46	2305	2	horde
hose	7	65	4724	2	hose
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hue	6	66	4230	2	h_ue
hued	8	69	2585	2	hued
huge	8	63	2165	2	huge
hype	12	55	1981	2	hype
hyte	10	90	1894	2	hyte
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
khadi	13	6	760	2	khadi
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
phage	11	51	1367	2	phage
phase	10	46	1721	2	phase
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
shad	8	62	3091	2	shad_
shaded	11	45	1887	2	shaded
shader	10	42	1876	2	shader
shades	10	59	2453	2	shades
shads	9	51	2448	2	shads
shady	12	54	1651	2	shady
shake	12	47	2640	2	shake
shale	8	53	3283	2	shale
shame	10	57	2670	2	shame
shape	10	51	2511	2	shape
share	8	64	3708	2	share
shave	11	44	2589	2	shave
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
thae	7	68	2556	2	tha_e
thane	8	61	2253	2	thane
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
whale	11	55	1743	2	whale
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.266	671770.7
2	DLD Change Limit	29872	430	0.923	32364.0
3	Display Results	430	430	0.106	4056.6
	(SQL Overall)	178691	430	1.295	137985.3