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

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

494 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
hate	7	84	5017	(None)
ate	3	70	5924	1	_ate
bate	6	65	5242	1	bate
cate	6	62	5459	1	cate
date	5	64	4332	1	date
fate	7	54	4428	1	fate
gate	5	57	4657	1	gate
hade	8	54	4019	1	hade
hae	6	73	6400	1	ha_e
haet	7	56	5950	1	haet
hake	11	56	3784	1	hake
hale	7	60	5283	1	hale
hame	9	70	4313	1	hame
hare	7	62	5573	1	hare
haste	8	59	2786	1	haste
hat	6	72	8996	1	hat_
hated	9	57	3402	1	hated
hater	8	50	3475	1	hater
hates	8	67	4257	1	hates
hath	10	59	3391	1	hath
hats	7	68	5825	1	hats
haute	8	95	2161	1	haute
have	10	61	3707	1	have
haze	16	48	3339	1	haze
hyte	10	90	1894	1	hyte
late	4	75	6048	1	late
mate	6	51	5421	1	mate
pate	6	53	5046	1	pate
rate	4	54	5876	1	rate
sate	4	55	5610	1	sate
tate	4	47	4860	1	tate
abate	7	66	2784	2	abate
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
agate	6	65	2514	2	agate
age	4	71	5433	2	_age
alate	5	53	4032	2	alate
ale	3	65	7234	2	_ale
ane	3	78	6694	2	_ane
ante	4	65	3890	2	ante
ape	5	72	5118	2	_ape
are	3	78	7457	2	_are
at	2	123	9340	2	_at_
ates	4	50	4792	2	_ates
att	3	54	5465	2	_att
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	3581	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5042	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
baste	7	48	2998	2	baste
bat	5	109	8895	2	bat_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bath	9	59	4008	2	bath
bathe	10	58	2288	2	bathe
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
bite	6	65	4699	2	bite
blate	7	59	3378	2	blate
bute	6	67	3967	2	bute
byte	9	65	2181	2	byte
cade	7	64	4391	2	cade
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	5311	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carte	7	59	4042	2	carte
case	6	58	4808	2	case
caste	7	59	3236	2	caste
cat	5	82	8234	2	cat_
cater	7	48	4070	2	cater
cates	7	59	5187	2	cates
cats	6	63	5634	2	cats
cave	9	59	4126	2	cave
cete	6	49	3478	2	cete
chafe	13	51	1735	2	chafe
chape	12	52	2114	2	chape
chare	10	52	3198	2	chare
chase	10	51	2712	2	chase
chaste	11	46	1739	2	chaste
chat	9	55	4613	2	chat_
chats	10	57	3009	2	chats
chute	10	43	1646	2	chute
cite	6	56	4034	2	cite
cote	6	66	4873	2	cote
crate	7	65	3740	2	crate
cute	6	64	4045	2	cute
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
data	5	60	2665	2	data
dated	7	55	3099	2	dated
dater	6	53	3231	2	dater
dates	6	56	3915	2	dates
dato	5	61	2994	2	dato
daze	14	73	2723	2	daze
dite	5	55	4755	2	dite
dote	5	54	4288	2	dote
ease	4	50	4233	2	ease
eat	3	69	8905	2	eat_
eaten	5	53	2305	2	eaten
eater	5	46	3984	2	eater
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eave	7	57	3358	2	eave
elate	5	53	3588	2	elate
enate	5	44	2814	2	enate
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4356	2	fane
fare	7	63	5446	2	fare
fat	6	81	7808	2	fat_
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fete	7	57	3492	2	fete
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4529	2	gane
gape	7	51	3451	2	gape
gat	4	68	8051	2	gat_
gated	7	53	2977	2	gated
gater	6	45	3364	2	gater
gates	6	59	3950	2	gates
gats	5	67	5344	2	gats
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
ghat	8	64	3528	2	ghat_
ghats	9	58	1861	2	ghats
gite	5	54	3861	2	gite
grate	6	49	3288	2	grate
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
had	7	76	5876	2	ha_d
haded	10	52	2762	2	haded
hades	9	60	3511	2	hades
hadj	15	58	1867	2	hadj
haed	8	63	3858	2	haed
haem	9	57	3098	2	haem
haen	7	62	2945	2	haen
haes	7	76	5102	2	haes
haets	8	65	2512	2	haets
haft	10	59	4184	2	haft
hafted	13	47	1383	2	hafted
hafter	12	48	1588	2	hafter
hafts	11	62	1946	2	hafts
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	2018	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
halite	9	36	2423	2	halite
hall	7	57	4116	2	hall
halm	9	58	3497	2	halm
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
halted	10	50	1960	2	halted
halter	9	44	2088	2	halter
halts	8	52	3010	2	halts
halve	11	48	1892	2	halve
ham	8	63	6328	2	ha_m
hamate	11	33	1982	2	hamate
hames	10	61	3870	2	hames
hams	9	64	4613	2	hams
hance	10	54	2415	2	hance
hand	8	68	3370	2	hand
hang	8	55	3554	2	hang
hank	11	51	3413	2	hank
hanse	8	57	2279	2	hanse
hant	7	54	6158	2	hant
hanted	10	41	2431	2	hanted
hantle	9	43	1820	2	hantle
hants	8	63	3540	2	hants
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
hapten	11	53	1298	2	hapten
hard	8	54	4350	2	hard
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	3428	2	harp
hart	7	68	6577	2	hart
harts	8	84	4159	2	harts
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
hasted	10	51	2528	2	hasted
hasten	9	57	1856	2	hasten
hastes	9	57	2707	2	hastes
hasty	11	57	1876	2	hasty
hatch	13	57	1959	2	hatch
haters	9	49	3039	2	haters
hatred	10	48	1433	2	hatred
hatted	10	49	2151	2	hatted
hatter	9	47	2487	2	hatter
haul	7	55	3045	2	haul
haut	7	59	4973	2	haut
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
heat	7	70	6142	2	heat_
heated	10	45	2559	2	heated
heater	9	48	2830	2	heater
heath	11	57	2428	2	heath
heats	8	58	3840	2	heats
heave	11	45	2181	2	heave
hebe	9	64	2470	2	hebe
heme	9	50	3441	2	heme
here	7	64	4710	2	here
het	6	76	7431	2	het_
heth	10	70	2802	2	heth
hets	7	55	4720	2	hets
hide	8	51	3462	2	hide
hie	6	76	5270	2	h_ie
hike	11	68	3039	2	hike
hire	7	55	3896	2	hire
hit	6	65	6919	2	hit_
hits	7	55	4513	2	hits
hive	10	60	2967	2	hive
hoe	6	75	6272	2	h_oe
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
hose	7	65	4724	2	hose
hot	6	77	7605	2	hot_
hotel	8	55	2074	2	hotel
hots	7	83	4932	2	hots
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hue	6	66	4230	2	h_ue
huge	8	63	2165	2	huge
humate	11	32	1444	2	humate
hut	6	64	5729	2	hut_
huts	7	67	3744	2	huts
hype	12	55	1981	2	hype
irate	5	56	2798	2	irate
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3147	2	jane
jape	13	49	2342	2	jape
jato	11	58	2268	2	jato
jete	11	59	2725	2	jete
jute	11	53	2789	2	jute
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3396	2	kane
kat	7	74	6829	2	kat_
kata	8	56	2602	2	kata
kats	8	59	4433	2	kats
khat	11	67	3072	2	khat_
khats	12	53	1601	2	khats
kite	8	53	3823	2	kite
kyte	11	70	1776	2	kyte
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5332	2	lane
lase	4	61	4851	2	lase
lat	3	75	9340	2	lat_
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	2671	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
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lite	4	70	5454	2	lite
lute	4	63	4101	2	lute
mabe	8	57	3334	2	mabe
mace	8	73	4578	2	mace
made	7	54	4023	2	made
mae	5	76	5910	2	ma_e
mage	7	57	3912	2	mage
make	10	55	3788	2	make
male	6	60	5229	2	male
mane	6	50	5201	2	mane
mare	6	47	5932	2	mare
mat	5	80	8393	2	mat_
mated	8	55	3778	2	mated
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
math	9	54	3744	2	math
mats	6	54	6028	2	mats
matt	6	57	5265	2	matt
matte	7	56	2684	2	matte
maze	15	54	3497	2	maze
mete	6	44	3813	2	mete
mite	6	62	4940	2	mite
mote	6	70	4808	2	mote
mute	6	51	3687	2	mute
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nates	5	52	3833	2	nates
nave	7	57	3231	2	nave
nite	4	59	4358	2	nite
note	4	62	3996	2	note
oat	3	98	8826	2	oat_
oaten	5	52	2240	2	oaten
oater	5	54	3373	2	oater
oath	7	61	3215	2	oath
oats	4	65	5421	2	oats
orate	5	51	3330	2	orate
ovate	8	42	1439	2	ovate
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pane	6	49	5028	2	pane
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
paste	7	49	3295	2	paste
pat	5	80	8946	2	pat_
pated	8	52	3784	2	pated
paten	7	48	2734	2	paten
pater	7	47	4072	2	pater
pates	7	60	4789	2	pates
path	9	91	3491	2	path
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
pave	9	61	3389	2	pave
phage	11	51	1367	2	phage
phase	10	46	1721	2	phase
phat	9	58	3786	2	phat_
plate	7	46	3511	2	plate
prate	7	51	3598	2	prate
qat	12	52	5333	2	qat_
qats	13	53	3134	2	qats
quate	14	45	2141	2	quate
race	6	67	4626	2	race
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
rat	3	78	9274	2	rat_
rated	6	54	4138	2	rated
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
rath	7	60	3766	2	rath
rathe	8	58	2192	2	rathe
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
rete	4	49	4413	2	rete
rite	4	58	4945	2	rite
rote	4	62	4902	2	rote
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
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	5433	2	sane
sat	3	62	8848	2	sat_
sated	6	62	3853	2	sated
satem	7	60	2145	2	satem
sates	5	49	4932	2	sates
sati	4	55	3932	2	sati
saute	5	50	2808	2	saute
save	7	57	4136	2	save
shade	9	51	2558	2	shade
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
shat	7	64	5659	2	shat_
shave	11	44	2589	2	shave
shote	8	55	2608	2	shote
shute	8	45	2034	2	shute
site	4	70	5241	2	site
skate	9	47	2154	2	skate
slate	5	54	3828	2	slate
spate	7	47	3158	2	spate
state	5	62	3733	2	state
tace	6	53	4251	2	tace
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
taste	5	51	2723	2	taste
tat	3	76	9029	2	tat_
tater	5	41	3861	2	tater
tates	5	54	4498	2	tates
tats	4	68	5813	2	tats
thae	7	68	2556	2	tha_e
thane	8	61	2253	2	thane
that	7	56	3932	2	that_
tote	4	66	4367	2	tote
urate	5	54	3216	2	urate
ute	3	53	3588	2	_ute
vale	7	49	3734	2	vale
vane	7	55	3468	2	vane
vase	7	56	2965	2	vase
vat	6	78	6345	2	vat_
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
vote	7	47	2862	2	vote
wade	8	52	3706	2	wade
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	4471	2	wane
ware	7	62	5472	2	ware
waste	8	61	2505	2	waste
wat	6	73	7892	2	wat_
water	8	47	3331	2	water
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wave	10	52	3473	2	wave
whale	11	55	1743	2	whale
what	10	54	3407	2	what_
whats	11	77	1899	2	whats
white	11	49	2030	2	white
wite	7	54	4327	2	wite
wyte	10	60	1864	2	wyte
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.076	2351197.4
2	DLD Change Limit	29872	494	1.190	25102.5
3	Display Results	494	494	0.123	4016.3
	(SQL Overall)	178691	494	1.389	128647.2