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

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

305 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
head	8	71	3717	(None)
ahead	9	68	1705	1	ahead
bead	7	59	3792	1	bead
dead	6	54	3424	1	dead
had	7	76	5876	1	h_ad
haed	8	63	3858	1	haed
heads	9	51	2711	1	heads
heady	12	51	1726	1	heady
heal	7	56	4569	1	heal
heap	9	64	3289	1	heap
hear	7	61	4388	1	hear
heard	9	52	2275	1	heard
heat	7	70	6142	1	heat
heed	8	64	3760	1	heed
held	8	53	3040	1	held
herd	8	49	3306	1	herd
hexad	16	49	1062	1	hexad
lead	5	60	3885	1	lead
mead	7	55	3160	1	mead
read	5	59	4253	1	read
ad	3	119	7503	2	__ad
ahed	8	95	3625	2	ahe_d
bad	6	77	6315	2	_bad
beads	8	54	2950	2	beads
beady	11	47	1992	2	beady
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beard	8	60	2496	2	beard
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
bed	6	79	5062	2	be_d
behead	12	3	992	2	behead
bend	7	64	3526	2	bend
brad	7	52	3434	2	brad
bread	8	55	2311	2	bread
cad	6	74	5636	2	_cad
chad	10	55	2550	2	chad
cheap	12	69	1594	2	cheap
cheat	10	57	3245	2	cheat
clad	7	62	2582	2	clad
cohead	12	38	1112	2	cohead
dad	5	84	5616	2	_dad
deads	7	57	2691	2	deads
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deed	6	53	4090	2	deed
dread	7	44	1902	2	dread
duad	6	65	2141	2	duad
dyad	9	64	1545	2	dyad
ear	3	68	6788	2	_ear
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
ed	3	86	4518	2	_e_d
egad	6	42	1541	2	egad
eld	4	67	3379	2	_eld
end	4	68	3435	2	_end
fad	7	74	5241	2	_fad
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fed	7	65	4835	2	fe_d
feed	8	45	3890	2	feed
fend	8	48	3297	2	fend
feod	8	155	2300	2	feod
feud	8	65	2302	2	feud
gad	5	75	5665	2	_gad
gaed	6	60	3151	2	gaed
gear	5	59	3497	2	gear
ged	5	70	4453	2	ge_d
geed	6	54	3550	2	geed
geld	6	58	2843	2	geld
glad	6	56	2401	2	glad
goad	6	68	3098	2	goad
grad	6	68	2986	2	grad
ha	5	102	5994	2	h_a_
haaf	10	62	2773	2	haaf
haar	7	73	2349	2	haar
hade	8	54	4019	2	h_ade
hadj	15	58	1867	2	h_adj
hae	6	73	6400	2	h_ae
haem	9	57	3098	2	haem
haen	7	62	2945	2	haen
haes	7	76	5102	2	haes
haet	7	56	5950	2	haet
hag	7	72	5574	2	h_ag
hah	9	106	5522	2	h_ah
haj	13	81	4060	2	h_aj
ham	8	63	6328	2	h_am
hand	8	68	3370	2	hand
hao	6	72	5112	2	h_ao
hap	8	73	6005	2	h_ap
hard	8	54	4350	2	hard
has	6	73	7265	2	h_as
hat	6	72	8996	2	h_at
haw	9	71	5327	2	h_aw
hay	9	73	5877	2	h_ay
he	5	81	5195	2	he__
headed	11	40	2047	2	headed
header	10	44	2254	2	header
healed	10	51	2144	2	healed
heals	8	57	3345	2	heals
heaped	12	45	1690	2	heaped
heaps	10	52	2322	2	heaps
heapy	13	59	1498	2	heapy
hears	8	67	3737	2	hears
heart	8	54	4074	2	heart
heated	10	45	2559	2	heated
heath	11	57	2428	2	heath
heats	8	58	3840	2	heats
heave	11	45	2181	2	heave
heaved	13	47	1786	2	heaved
heavy	14	48	1418	2	heavy
hebe	9	64	2470	2	hebe
heck	13	58	2649	2	heck
heeds	9	54	2042	2	heeds
heel	7	50	3422	2	heel
heft	10	67	3629	2	heft
heh	9	60	3962	2	he_h
hehs	10	67	2396	2	hehs
heil	7	63	2893	2	heil
heir	7	75	2380	2	heir
hell	7	56	3789	2	hell
helm	9	55	3002	2	helm
helo	7	53	3285	2	helo
help	9	53	2892	2	help
hem	8	61	4873	2	he_m
hemal	10	44	1980	2	hemal
heme	9	50	3441	2	heme
hemp	11	57	2562	2	hemp
hems	9	55	3494	2	hems
hen	6	75	5527	2	he_n
hens	7	56	4257	2	hens
hent	7	66	5638	2	hent
hep	8	66	4414	2	he_p
heptad	12	3	727	2	heptad
her	6	65	4781	2	he_r
herald	10	3	1134	2	herald
herb	9	47	3096	2	herb
herds	9	64	2468	2	herds
here	7	64	4710	2	here
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
hern	7	61	3489	2	hern
hero	7	46	3578	2	hero
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hest	7	59	5077	2	hest
het	6	76	7431	2	he_t
heth	10	70	2802	2	heth
hets	7	55	4720	2	hets
hew	9	76	4272	2	he_w
hewed	12	56	1943	2	hewed
hewn	10	67	1985	2	hewn
hews	10	56	3157	2	hews
hex	13	74	3617	2	he_x
hexade	17	43	890	2	hexade
hexads	17	46	819	2	hexads
hexed	16	56	1576	2	hexed
hey	9	67	4106	2	he_y
hid	7	62	4836	2	h_id
hied	8	54	3404	2	hied
hind	8	55	2975	2	hind
hoar	7	67	2916	2	hoar
hoard	9	49	1831	2	hoard
hoax	14	77	1829	2	hoax
hod	7	68	5246	2	h_od
hodad	10	3	1135	2	hodad
hoed	8	78	3798	2	hoed
hold	8	62	3506	2	hold
hood	8	51	3233	2	hood
hued	8	69	2585	2	hued
hwan	10	57	1689	2	hwan
jean	11	66	2928	2	jean
jeed	12	54	2850	2	jeed
jehad	16	3	768	2	jehad
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
kheda	13	4	653	2	kheda
knead	10	42	966	2	knead
lad	4	81	6570	2	_lad
lea	3	76	6018	2	lea_
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
lean	4	63	4524	2	lean
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
leas	4	59	5418	2	leas
led	4	62	5455	2	le_d
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
load	5	67	3060	2	load
mad	6	89	5870	2	_mad
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal
mean	6	55	3808	2	mean
meat	6	63	5960	2	meat
med	6	61	4674	2	me_d
meed	7	49	3470	2	meed
meld	7	58	3047	2	meld
menad	8	59	1898	2	menad
mend	7	53	3402	2	mend
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
need	5	49	3415	2	need
nerd	5	66	2494	2	nerd
ohed	8	78	2518	2	ohe_d
orad	5	60	3169	2	orad
oread	6	46	1960	2	oread
pad	6	80	5732	2	_pad
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
ped	6	67	5152	2	pe_d
peed	7	62	3918	2	peed
pend	7	59	3453	2	pend
plead	8	58	1846	2	plead
quad	14	46	1870	2	quad
rad	4	76	6200	2	_rad
readd	7	46	1713	2	readd
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
red	4	67	5580	2	re_d
redd	6	63	2317	2	redd
reed	5	55	4962	2	reed
rend	5	61	3657	2	rend
rhea	7	50	1743	2	rhea_
rheas	8	48	1695	2	rheas
road	5	63	3211	2	road
sad	4	74	5920	2	_sad
scad	7	57	2576	2	scad
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seed	5	55	4948	2	seed
send	5	52	3729	2	send
shad	8	62	3091	2	shad
shea	7	60	3157	2	shea_
sheaf	11	54	2412	2	sheaf
sheal	8	49	2770	2	sheal
shear	8	54	2483	2	shear
sheas	8	63	3179	2	sheas
shed	8	65	3615	2	she_d
shend	9	47	1997	2	shend
sherd	9	63	2115	2	sherd
stead	6	55	2027	2	stead
tad	4	79	5982	2	_tad
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
ted	4	64	4656	2	te_d
teed	5	54	3926	2	teed
tend	5	64	3377	2	tend
thread	10	50	1109	2	thread
toad	5	58	3018	2	toad
trad	5	56	3091	2	trad
tread	6	48	2170	2	tread
veal	7	69	3681	2	veal
veld	8	53	2320	2	veld
vend	8	66	2642	2	vend
wad	7	70	5389	2	_wad
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weald	9	56	1502	2	weald
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
wed	7	58	4362	2	we_d
weed	8	56	3751	2	weed
weld	8	47	2773	2	weld
wend	8	53	3045	2	wend
wheal	11	57	1618	2	wheal
wheat	11	49	2457	2	wheat
woad	8	55	2394	2	woad
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
year	7	65	3425	2	year
yeas	7	86	3842	2	yeas
yeld	8	114	2387	2	yeld
zeal	13	55	3033	2	zeal
zed	13	54	3117	2	ze_d

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	29872	0.140	1276364.3
2	DLD Change Limit	29872	305	2.063	14479.9
3	Display Results	305	305	0.156	1955.1
	(SQL Overall)	178691	305	2.359	75748.6