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

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

299 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
hears	8	67	3737	(None)
bears	7	57	3904	1	bears
dears	6	57	3688	1	dears
ears	4	63	5659	1	_ears
fears	8	48	2939	1	fears
gears	6	46	2869	1	gears
haars	8	56	2047	1	haars
heads	9	51	2711	1	heads
heals	8	57	3346	1	heals
heaps	10	52	2322	1	heaps
hear	7	61	4388	1	hear_
heard	9	52	2275	1	heard
hearse	9	41	1427	1	hearse
heart	8	54	4074	1	heart
hearts	9	62	1894	1	hearts
heats	8	58	3840	1	heats
heirs	8	56	1856	1	heirs
hers	7	58	4487	1	he_rs
hoars	8	59	2555	1	hoars
lears	5	59	3873	1	lears
nears	5	55	2942	1	nears
pears	7	51	3861	1	pears
rears	5	47	3965	1	rears
sears	5	47	4491	1	sears
shears	9	38	2090	1	shears
tears	5	54	3646	1	tears
wears	8	60	3030	1	wears
years	8	45	2767	1	years
afars	8	57	1651	2	afars
agars	6	61	2064	2	agars
anears	6	37	1718	2	anears
ars	3	76	7093	2	__ars
bars	6	65	6409	2	_bars
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bear	6	68	4464	2	bear_
beard	8	60	2496	2	beard
beards	9	41	1667	2	beards
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beers	7	56	2839	2	beers
blears	8	51	1645	2	blears
boars	7	52	2960	2	boars
cars	6	73	6476	2	_cars
cedars	9	33	1283	2	cedars
chars	10	59	3664	2	chars
cheaps	13	46	1368	2	cheaps
cheats	11	45	1954	2	cheats
cheers	11	45	1891	2	cheers
clears	8	41	1656	2	clears
czars	16	48	1291	2	czars
deads	7	57	2691	2	deads
deairs	7	40	1378	2	deairs
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear_
deary	9	58	2684	2	deary
debars	9	42	1804	2	debars
deers	6	49	3052	2	deers
denars	7	46	2143	2	denars
dewars	10	51	1707	2	dewars
drears	7	46	1425	2	drears
ear	3	68	6788	2	_ear_
earl	4	58	3814	2	_earl
earls	5	61	2751	2	_earls
earn	4	67	3755	2	_earn
earns	5	59	2756	2	_earns
eats	4	70	5487	2	_eats
eras	4	54	4150	2	_eras
errs	4	56	2253	2	_errs
ers	3	60	4628	2	_e_rs
fear	7	53	3779	2	fear_
feats	8	64	3275	2	feats
feuars	9	3	865	2	feuars
fiars	8	67	2083	2	fiars
gars	5	57	5074	2	_gars
gear	5	59	3497	2	gear_
gnars	6	67	1885	2	gnars
guars	6	50	2105	2	guars
haafs	11	57	1116	2	haafs
haar	7	73	2349	2	haar_
haems	10	55	1701	2	haems
haeres	9	40	1703	2	haeres
haes	7	76	5102	2	h_aes
haets	8	65	2512	2	haets
hags	8	67	4084	2	h_ags
hahs	10	83	3336	2	h_ahs
hairs	8	62	2517	2	hairs
hams	9	64	4613	2	h_ams
haps	9	64	4346	2	h_aps
hard	8	54	4350	2	h_ard
hards	9	64	3565	2	h_ards
hare	7	62	5573	2	h_are
hares	8	62	5554	2	h_ares
hark	11	52	3739	2	h_ark
harks	12	63	3343	2	h_arks
harl	7	57	4000	2	h_arl
harls	8	56	3450	2	h_arls
harm	9	56	3779	2	h_arm
harms	10	68	2901	2	h_arms
harp	9	61	3429	2	h_arp
harps	10	59	2687	2	h_arps
harsh	11	64	1805	2	h_arsh
hart	7	68	6577	2	h_art
harts	8	84	4159	2	h_arts
has	6	73	7265	2	h_a_s
hats	7	68	5825	2	h_ats
haws	10	64	3944	2	h_aws
hays	10	61	3807	2	h_ays
head	8	71	3717	2	hea_d
headers	11	38	1939	2	headers
heady	12	51	1726	2	heady
heal	7	56	4569	2	hea_l
healers	10	43	1946	2	healers
heap	9	64	3289	2	hea_p
heapers	12	36	1667	2	heapers
heapy	13	59	1498	2	heapy
hearer	9	43	2364	2	hearer
hearers	10	43	1978	2	hearers
hearsay	13	3	552	2	hearsay
hearsed	11	38	1140	2	hearsed
hearses	10	44	1453	2	hearses
hearth	12	53	1521	2	hearth
hearths	13	53	1107	2	hearths
hearty	12	63	1363	2	hearty
heat	7	70	6142	2	hea_t
heaters	10	42	2522	2	heaters
heath	11	57	2428	2	heath
heaths	12	63	1638	2	heaths
heave	11	45	2181	2	heave
heavers	13	37	1719	2	heavers
heaves	12	41	2030	2	heaves
heavy	14	48	1418	2	heavy
hebes	10	55	2167	2	hebes
hecks	14	52	2065	2	hecks
heders	10	41	1976	2	heders
heeds	9	54	2042	2	heeds
heels	8	56	2553	2	heels
hefts	11	62	1815	2	hefts
hegari	10	3	952	2	hegari
hegaris	11	3	1043	2	hegaris
hehs	10	67	2396	2	he_hs
heils	8	52	2219	2	heils
heir	7	75	2380	2	heir_
hells	8	50	3204	2	hells
helms	10	56	1946	2	helms
helos	8	49	2806	2	helos
helps	10	52	1934	2	helps
hemes	10	50	3108	2	hemes
hemps	12	69	1733	2	hemps
hems	9	55	3494	2	he_ms
henry	11	40	1447	2	henry
henrys	12	36	610	2	henrys
hens	7	56	4257	2	he_ns
hents	8	73	3074	2	hents
her	6	65	4781	2	he_r_
herb	9	47	3096	2	he_rb
herbs	10	55	2050	2	herbs
herd	8	49	3306	2	he_rd
herds	9	64	2468	2	herds
here	7	64	4710	2	he_re
heres	8	62	4590	2	heres
herl	7	58	3455	2	he_rl
herls	8	52	2643	2	herls
herm	9	56	3615	2	he_rm
herms	10	56	2643	2	herms
hern	7	61	3489	2	he_rn
herns	8	48	2558	2	herns
hero	7	46	3578	2	he_ro
heros	8	49	3086	2	heros
herry	11	49	2247	2	herry
hes	6	66	5420	2	he__s
hests	8	58	2993	2	hests
heths	11	63	1778	2	heths
hets	7	55	4720	2	he_ts
hewers	12	37	1527	2	hewers
hews	10	56	3157	2	he_ws
hexads	17	46	820	2	hexads
hexers	16	56	1275	2	hexers
hexes	15	51	2304	2	hexes
hoar	7	67	2916	2	hoar_
hoard	9	49	1831	2	hoard
hoards	10	49	1262	2	hoards
hoarse	9	44	1132	2	hoarse
hoary	11	45	1676	2	hoary
hoers	8	57	2492	2	hoers
horas	8	63	3310	2	horas
hours	8	54	2239	2	hours
izars	14	51	1293	2	izars
jars	11	73	3835	2	_jars
jeans	12	60	2211	2	jeans
jeers	12	48	1813	2	jeers
kbars	11	46	1260	2	kbars
keas	8	63	3709	2	kea_s
kebars	12	41	1249	2	kebars
keirs	9	53	1367	2	keirs
knars	9	44	1611	2	knars
kyars	12	48	1396	2	kyars
lars	4	69	5657	2	_lars
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lear	4	70	4595	2	lear_
learn	5	53	2266	2	learn
learns	6	55	1374	2	learns
leary	8	59	2738	2	leary
leas	4	59	5418	2	lea_s
leers	5	48	2898	2	leers
lehrs	8	61	1113	2	lehrs
liars	5	47	2316	2	liars
maars	7	46	2163	2	maars
mars	6	62	6187	2	_mars
meads	8	54	2532	2	meads
meals	7	59	3338	2	meals
means	7	58	3123	2	means
meats	7	50	3405	2	meats
neaps	7	56	1832	2	neaps
near	4	52	3650	2	near_
neats	5	59	3190	2	neats
oars	4	68	4603	2	_oars
pars	6	75	6079	2	_pars
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pear	6	97	4523	2	pear_
pearl	7	53	2446	2	pearl
pearls	8	47	1539	2	pearls
peart	7	64	4075	2	peart
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
peers	7	51	3027	2	peers
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear_
rearm	7	59	2357	2	rearm
rearms	8	51	1465	2	rearms
rebars	8	40	1983	2	rebars
rehears	10	33	1277	2	rehears
rheas	8	48	1695	2	rhea_s
roars	5	56	2224	2	roars
scars	7	54	3353	2	scars
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sear	4	73	5384	2	sear_
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seers	5	51	3638	2	seers
sers	4	57	4665	2	se_rs
sewars	9	40	1863	2	sewars
sheafs	12	49	1288	2	sheafs
sheals	9	44	2064	2	sheals
shear	8	54	2483	2	shear_
sheas	8	63	3179	2	shea_s
sheers	9	43	2240	2	sheers
shmears	12	7	707	2	shmears
smears	8	47	1443	2	smears
soars	5	47	3251	2	soars
spars	7	54	3154	2	spars
spears	8	40	1947	2	spears
stars	5	58	3657	2	stars
swears	9	41	1407	2	swears
tars	4	67	6395	2	_tars
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tear	4	52	4288	2	tear_
teary	8	51	2405	2	teary
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
theirs	9	46	1035	2	theirs
thenars	10	24	852	2	thenars
tsars	5	67	1711	2	tsars
tzars	14	49	1427	2	tzars
vars	7	57	4207	2	_vars
veals	8	49	2619	2	veals
veers	8	45	2136	2	veers
velars	9	39	1372	2	velars
wars	7	86	5980	2	_wars
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear_
weary	11	56	2061	2	weary
weirs	8	43	1649	2	weirs
wheals	12	45	1252	2	wheals
wheats	12	50	1322	2	wheats
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year_
yearn	8	63	1643	2	yearn
yearns	9	50	954	2	yearns
yeas	7	86	3842	2	yea_s
zeals	14	53	2085	2	zeals

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	53800	0.343	520965.0
2	DLD Change Limit	53800	299	1.906	28226.7
3	Display Results	299	299	0.076	3934.2
	(SQL Overall)	178691	299	2.325	76856.3