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

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

439 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
hame	9	70	4313	(None)
came	8	76	4875	1	came
dame	7	71	4031	1	dame
fame	9	56	3939	1	fame
game	7	66	4432	1	game
hade	8	54	4019	1	hade
hae	6	73	6400	1	ha_e
haem	9	57	3098	1	haem
hake	11	56	3784	1	hake
hale	7	60	5283	1	hale
ham	8	63	6328	1	ham_
hames	10	61	3870	1	hames
hams	9	64	4613	1	hams
hare	7	62	5573	1	hare
hate	7	84	5017	1	hate
have	10	61	3707	1	have
haze	16	48	3339	1	haze
heme	9	50	3441	1	heme
home	9	80	4244	1	home
kame	10	57	2823	1	kame
lame	6	68	4929	1	lame
name	6	56	3741	1	name
same	6	52	4564	1	same
shame	10	57	2670	1	shame
tame	6	63	4366	1	tame
wame	9	50	3548	1	wame
ace	5	96	5683	2	_ace
acme	8	69	2432	2	acme
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
ahem	9	72	2536	2	ahem
ale	3	65	7234	2	_ale
alme	6	58	3216	2	alme
am	4	118	7556	2	_am_
ama	5	108	5330	2	_ama
amen	6	67	3315	2	_amen
ami	5	66	4681	2	_ami
amie	6	63	3985	2	_amie
amp	7	75	4102	2	_amp
amu	5	82	3732	2	_amu
ane	3	78	6695	2	_ane
ape	5	72	5118	2	_ape
arame	7	50	2662	2	arame
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
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bam	7	85	6014	2	bam_
bams	8	70	4445	2	bams
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
bate	6	65	5242	2	bate
blame	9	56	2549	2	blame
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
cam	7	80	5898	2	cam_
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
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
chafe	13	51	1735	2	chafe
cham	11	55	3231	2	cham_
champ	14	50	1796	2	champ
chams	12	60	2850	2	chams
chape	12	52	2114	2	chape
chare	10	52	3198	2	chare
chase	10	51	2712	2	chase
chime	12	53	2259	2	chime
chyme	15	65	1250	2	chyme
come	8	75	4770	2	come
cyme	11	94	2037	2	cyme
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dam	6	74	5704	2	dam_
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn
damp	9	62	2884	2	damp
dams	7	74	4437	2	dams
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
deme	7	65	3628	2	deme
dime	7	62	3764	2	dime
dome	7	72	4073	2	dome
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
eme	5	58	3718	2	_eme
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
famed	11	59	2834	2	famed
fames	10	57	3592	2	fames
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
feme	9	61	3054	2	feme
flame	10	51	2444	2	flame
frame	10	58	2180	2	frame
fume	9	67	2763	2	fume
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
gam	6	70	6006	2	gam_
gama	7	70	3552	2	gama
gamb	9	63	3184	2	gamb
gambe	10	62	1921	2	gambe
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gamp	9	88	3321	2	gamp
gams	7	66	4888	2	gams
gamy	10	54	2753	2	gamy
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
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
haems	10	55	1701	2	haems
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
hall	7	57	4116	2	hall
halm	9	58	3497	2	halm
halma	10	82	1925	2	halma
halms	10	52	2521	2	halms
halo	7	64	3732	2	halo
halt	7	60	5630	2	halt
halve	11	48	1892	2	halve
hamal	10	46	2311	2	hamal
hamate	11	33	1983	2	hamate
hamlet	11	37	2279	2	hamlet
hammed	14	41	1697	2	hammed
hammer	13	81	2003	2	hammer
hammy	15	51	1343	2	hammy
hamper	13	45	1865	2	hamper
hamza	19	13	977	2	hamza
hance	10	54	2415	2	hance
hand	8	68	3371	2	hand
hang	8	55	3555	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
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
harmed	12	52	1883	2	harmed
harmer	11	47	1955	2	harmer
harms	10	68	2901	2	harms
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
heaume	11	3	754	2	heaume
heave	11	45	2181	2	heave
hebe	9	64	2470	2	hebe
hem	8	61	4873	2	hem_
hemes	10	50	3108	2	hemes
hemp	11	57	2562	2	hemp
hems	9	55	3494	2	hems
here	7	64	4710	2	here
hide	8	51	3463	2	hide
hie	6	76	5270	2	h_ie
hike	11	68	3039	2	hike
him	8	62	4766	2	him_
hims	9	52	3097	2	hims
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
hm	7	81	2673	2	h_m_
hmm	10	62	1899	2	h_mm
hoe	6	75	6272	2	h_oe
hoke	11	59	3593	2	hoke
hole	7	75	5339	2	hole
homed	11	54	2542	2	homed
homer	10	58	2845	2	homer
homes	10	69	3881	2	homes
homey	13	59	2484	2	homey
homie	10	46	2253	2	homie
homo	9	61	2647	2	homo
homy	12	66	2322	2	homy
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
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
huge	8	63	2165	2	huge
hum	8	55	4293	2	hum_
hump	11	62	2872	2	hump
hums	9	68	3142	2	hums
hymen	13	3	1104	2	hymen
hymn	12	3	1131	2	hymn
hype	12	55	1981	2	hype
hyte	10	90	1894	2	hyte
iamb	8	66	2373	2	iamb
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jam	12	69	4252	2	jam_
jamb	15	55	2385	2	jamb
jambe	16	53	1475	2	jambe
jams	13	52	3107	2	jams
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kames	11	50	2469	2	kames
kami	10	58	2364	2	kami
kane	8	51	3397	2	kane
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lam	5	76	6671	2	lam_
lama	6	66	3529	2	lama
lamb	8	68	3214	2	lamb
lamed	8	52	3529	2	lamed
lamer	7	52	3370	2	lamer
lames	7	54	4554	2	lames
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
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
lime	6	62	4493	2	lime
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
made	7	54	4024	2	made
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
mama	8	62	3159	2	mama
mamey	12	54	1883	2	mamey
mamie	9	58	2600	2	mamie
mane	6	50	5203	2	mane
mare	6	47	5933	2	mare
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
me	4	77	4833	2	__me
meme	8	53	3055	2	meme
mime	8	57	3640	2	mime
mome	8	52	3935	2	mome
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
nam	5	59	5339	2	nam_
named	8	52	2306	2	named
namer	7	56	2210	2	namer
names	7	48	3336	2	names
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nome	6	60	3842	2	nome
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pam	7	78	5839	2	pam_
pams	8	56	4176	2	pams
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
pome	8	56	3669	2	pome
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
ram	5	68	6727	2	ram_
ramee	7	46	3385	2	ramee
ramen	7	56	2519	2	ramen
ramet	7	57	4314	2	ramet
rami	6	60	3409	2	rami
ramie	7	50	2782	2	ramie
ramp	8	59	3400	2	ramp
rams	6	59	5077	2	rams
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
rheme	10	62	1405	2	rheme
rhyme	13	47	955	2	rhyme
rime	6	51	3888	2	rime
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
samek	11	49	1527	2	samek
samp	8	57	3359	2	samp
sane	4	59	5434	2	sane
sate	4	55	5610	2	sate
save	7	57	4136	2	save
seme	6	58	3665	2	seme
shade	9	51	2558	2	shade
shake	12	47	2640	2	shake
shale	8	53	3283	2	shale
sham	9	64	3636	2	sham_
shamed	12	51	2021	2	shamed
shames	11	47	2622	2	shames
shams	10	58	2941	2	shams
shape	10	51	2511	2	shape
share	8	64	3708	2	share
shave	11	44	2589	2	shave
some	6	60	4038	2	some
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
tam	5	86	6342	2	tam_
tamed	8	55	2851	2	tamed
tamer	7	52	3010	2	tamer
tames	7	52	4201	2	tames
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tape	6	45	3814	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
theme	10	59	2173	2	theme
thyme	13	46	1247	2	thyme
time	6	62	3501	2	time
tome	6	75	4319	2	tome
vale	7	49	3734	2	vale
vamp	11	55	2154	2	vamp
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
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
wames	10	64	3280	2	wames
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
whale	11	55	1743	2	whale
wham	12	53	2169	2	wham_
whamo	13	55	1126	2	whamo
whams	13	55	1564	2	whams
yam	8	74	4899	2	yam_
yamen	10	41	1518	2	yamen
yams	9	53	3073	2	yams
yare	7	56	3694	2	yare
zyme	18	191	1494	2	zyme

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	439	0.860	34734.9
3	Display Results	439	439	0.093	4720.4
	(SQL Overall)	178691	439	1.029	173655.0