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

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

310 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
hear	7	61	4388	(None)
bear	6	68	4464	1	bear
dear	5	53	4360	1	dear
ear	3	68	6788	1	_ear
fear	7	53	3779	1	fear
gear	5	59	3497	1	gear
haar	7	73	2349	1	haar
head	8	71	3717	1	head
heal	7	56	4569	1	heal
heap	9	64	3289	1	heap
heard	9	52	2275	1	heard
hears	8	67	3737	1	hears
heart	8	54	4074	1	heart
heat	7	70	6142	1	heat
heir	7	75	2380	1	heir
her	6	65	4781	1	he_r
hoar	7	67	2916	1	hoar
lear	4	70	4595	1	lear
near	4	52	3650	1	near
pear	6	97	4523	1	pear
rear	4	56	4455	1	rear
sear	4	73	5384	1	sear
shear	8	54	2483	1	shear
tear	4	52	4288	1	tear
wear	7	58	3672	1	wear
year	7	65	3425	1	year
afar	7	67	2078	2	afar
agar	5	87	2641	2	agar
ahead	9	68	1705	2	ahead
ajar	11	62	1770	2	ajar
alar	4	63	4007	2	alar
anear	5	54	2032	2	anear
ar	2	113	7938	2	__ar
bar	5	80	7055	2	_bar
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
beer	6	56	3599	2	beer
blear	7	59	1868	2	blear
boar	6	61	3429	2	boar
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
cheap	12	69	1594	2	cheap
cheat	10	57	3245	2	cheat
cheer	10	54	2038	2	cheer
clear	7	62	1905	2	clear
czar	15	60	1313	2	czar
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
debar	8	55	1786	2	debar
deer	5	67	3902	2	deer
denar	6	52	2329	2	denar
dewar	9	58	1773	2	dewar
drear	6	50	1690	2	drear
earl	4	58	3814	2	_earl
earn	4	67	3755	2	_earn
ears	4	63	5659	2	_ears
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
er	2	83	4514	2	_e_r
era	3	57	4150	2	_era
err	3	56	2653	2	_err
far	6	77	6260	2	_far
feal	7	139	4042	2	feal
fears	8	48	2939	2	fears
feat	7	64	5822	2	feat
fer	6	66	4612	2	fe_r
feuar	8	3	1024	2	feuar
fiar	7	64	2733	2	fiar
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
gnar	5	60	2138	2	gnar
guar	5	69	2329	2	guar
ha	5	102	5994	2	h_a_
haaf	10	62	2773	2	haaf
haars	8	56	2047	2	haars
had	7	76	5876	2	h_ad
hae	6	73	6400	2	h_ae
haed	8	63	3858	2	haed
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
hair	7	63	3014	2	hair
haj	13	81	4060	2	h_aj
ham	8	63	6328	2	h_am
hao	6	72	5112	2	h_ao
hap	8	73	6005	2	h_ap
hard	8	54	4350	2	h_ard
hare	7	62	5573	2	h_are
hark	11	52	3739	2	h_ark
harl	7	57	4000	2	h_arl
harm	9	56	3779	2	h_arm
harp	9	61	3429	2	h_arp
hart	7	68	6577	2	h_art
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__
header	10	44	2254	2	header
heads	9	51	2711	2	heads
heady	12	51	1726	2	heady
healer	9	42	2180	2	healer
heals	8	57	3345	2	heals
heaper	11	41	1952	2	heaper
heaps	10	52	2322	2	heaps
heapy	13	59	1498	2	heapy
hearer	9	43	2364	2	hearer
hearse	9	41	1427	2	hearse
hearth	12	53	1521	2	hearth
hearts	9	62	1894	2	hearts
hearty	12	63	1363	2	hearty
heater	9	48	2830	2	heater
heath	11	57	2428	2	heath
heats	8	58	3840	2	heats
heave	11	45	2181	2	heave
heaver	12	48	1967	2	heaver
heavy	14	48	1418	2	heavy
hebe	9	64	2470	2	hebe
heck	13	58	2649	2	heck
heder	9	56	2364	2	heder
heed	8	64	3760	2	heed
heel	7	50	3422	2	heel
heft	10	67	3629	2	heft
hegari	10	3	952	2	hegari
heh	9	60	3962	2	he_h
hehs	10	67	2396	2	hehs
heil	7	63	2893	2	heil
heirs	8	56	1856	2	heirs
held	8	53	3040	2	held
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
henry	11	40	1447	2	henry
hens	7	56	4257	2	hens
hent	7	66	5638	2	hent
hep	8	66	4414	2	he_p
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
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
herry	11	49	2247	2	herry
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
hewer	11	57	1993	2	hewer
hewn	10	67	1985	2	hewn
hews	10	56	3157	2	hews
hex	13	74	3617	2	he_x
hexad	16	49	1062	2	hexad
hexer	15	51	1668	2	hexer
hey	9	67	4106	2	he_y
hilar	8	54	1814	2	hilar
hoard	9	49	1831	2	hoard
hoars	8	59	2555	2	hoars
hoary	11	45	1676	2	hoary
hoax	14	77	1829	2	hoax
hoer	7	65	3398	2	hoer
hora	7	61	3656	2	hora
hour	7	58	2731	2	hour
hwan	10	57	1689	2	hwan
izar	13	66	1601	2	izar
jar	10	76	4615	2	_jar
jean	11	66	2928	2	jean
jeer	11	54	2646	2	jeer
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
kebar	11	51	1353	2	kebar
keir	8	62	1787	2	keir
knar	8	58	1872	2	knar
kyar	11	69	1684	2	kyar
lar	3	79	6753	2	_lar
lea	3	76	6018	2	lea_
lead	5	60	3885	2	lead
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
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leas	4	59	5418	2	leas
leer	4	62	3935	2	leer
lehr	7	55	1494	2	lehr
liar	4	72	2968	2	liar
maar	6	60	2506	2	maar
mar	5	79	6595	2	_mar
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
neap	6	69	2701	2	neap
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat
oar	3	70	5795	2	_oar
osar	4	68	2095	2	osar
par	5	74	6702	2	_par
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
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
peer	6	62	3835	2	peer
per	5	63	5309	2	pe_r
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rearm	7	59	2357	2	rearm
rears	5	47	3965	2	rears
rebar	7	54	2019	2	rebar
rehear	9	37	1322	2	rehear
rhea	7	50	1743	2	rhea_
rheas	8	48	1695	2	rheas
roar	4	63	2857	2	roar
scar	6	64	3420	2	scar
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seer	4	55	4704	2	seer
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
sewar	8	54	2110	2	sewar
shea	7	60	3157	2	shea_
sheaf	11	54	2412	2	sheaf
sheal	8	49	2770	2	sheal
shears	9	38	2090	2	shears
sheas	8	63	3179	2	sheas
sheer	8	47	2689	2	sheer
shmear	11	7	693	2	shmear
smear	7	44	1639	2	smear
soar	4	68	3867	2	soar
spar	6	54	3330	2	spar
spear	7	58	2106	2	spear
star	4	80	3776	2	star
swear	8	53	1685	2	swear
tar	3	75	7069	2	_tar
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
their	8	55	1215	2	their
thenar	9	26	1000	2	thenar
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
var	6	61	4833	2	_var
veal	7	69	3681	2	veal
veer	7	62	2957	2	veer
velar	8	58	1763	2	velar
vera	7	68	2884	2	vera
war	6	72	6242	2	_war
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
wheal	11	57	1618	2	wheal
wheat	11	49	2457	2	wheat
yar	6	72	5383	2	_yar
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
yearn	8	63	1643	2	yearn
years	8	45	2767	2	years
yeas	7	86	3842	2	yeas
zeal	13	55	3033	2	zeal

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.280	638182.1
2	DLD Change Limit	29872	310	0.783	38150.7
3	Display Results	310	310	0.063	4920.6
	(SQL Overall)	178691	310	1.126	158695.4