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

Here are the results of your fuzzy-string dictionary search for “hearsinh” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

90 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
hearsing	12	3	938	1	hearsing
hearing	11	33	2416	2	hear_ing
hearting	12	5	1312	2	hearting
arsine	6	40	2104	3	__arsine
arsino	6	41	1351	3	__arsino
bearding	12	40	1194	3	bearding
bearing	10	36	2477	3	bear_ing
bearish	12	30	1327	3	bear_ish
bearskin	14	4	362	3	bearskin_
bearskins	15	4	337	3	bearskins
ceasing	10	41	1826	3	cea_sing
earing	7	52	3548	3	_ear_ing
earning	8	34	1821	3	_earning
earring	8	35	1901	3	_earring
easing	7	49	2646	3	_ea_sing
erasing	8	3	1796	3	_erasing
fearing	11	35	2003	3	fear_ing
feasing	11	39	1665	3	fea_sing
gearing	9	28	1884	3	gear_ing
haring	10	42	3300	3	h_ar_ing
harking	15	41	2094	3	h_arking
harmin	11	31	1739	3	h_armin_
harmine	12	28	1619	3	h_armine
harming	13	37	1793	3	h_arming
harmins	12	37	1672	3	h_armins
harpin	11	36	1438	3	h_arpin_
harping	13	41	1838	3	h_arping
harpins	12	36	1570	3	h_arpins
harsh	11	64	1805	3	h_ars__h
headfish	18	4	544	3	headfish
heading	12	29	1911	3	hea_ding
headline	12	12	961	3	headline
headpin	13	3	600	3	headpin_
headpins	14	3	610	3	headpins
headwind	16	4	387	3	headwind
healing	11	39	2296	3	hea_ling
heaping	13	30	1585	3	hea_ping
hearings	12	36	1185	3	hear_ings
hearken	14	33	802	3	hearken_
hearkens	15	33	669	3	hearkens
hears	8	67	3737	3	hears___
hearsay	13	3	552	3	hears_ay
hearsays	14	4	451	3	hearsays
hearse	9	41	1427	3	hears__e
hearsed	11	38	1140	3	hears_ed
hearses	10	44	1453	3	hears_es
hearten	10	24	1175	3	hearten_
heartens	11	30	1015	3	heartens
hearth	12	53	1521	3	hear__th
heartier	11	3	909	3	heartier
hearties	11	3	1541	3	hearties
heartily	14	3	656	3	heartily
heartsick	18	4	248	3	heartsick
heating	11	40	2432	3	hea_ting
heaving	14	41	1476	3	hea_ving
heiring	11	33	1290	3	heir_ing
heparin	12	4	1043	3	hepar_in_
heparins	13	3	1012	3	hepar_ins
herding	12	29	1512	3	he_rding
herein	9	37	1779	3	he_rein_
heroin	9	44	2059	3	he_roin_
heroine	10	35	1748	3	he_roine
heroins	10	35	1801	3	he_roins
herring	11	36	1588	3	he_rring
herrying	15	14	702	3	herrying
hoarding	13	28	864	3	hoarding
hoarsen	10	36	799	3	hoarsen_
hoarsens	11	30	602	3	hoarsens
horsing	11	32	1558	3	h_orsing
learning	9	7	855	3	learning
leasing	8	39	2016	3	lea_sing
nearing	8	30	2033	3	near_ing
nearside	9	4	491	3	nearside
parsing	10	38	1955	3	_parsing
pearling	11	9	1201	3	pearling
rearing	8	31	2878	3	rear_ing
rearming	11	14	1361	3	rearming
rehearsing	14	4	434	3	rehearsing
searing	8	33	3092	3	sear_ing
shearing	12	39	1590	3	shear_ing
shearling	13	3	692	3	shearling
tearing	8	40	2149	3	tear_ing
teasing	8	39	1851	3	tea_sing
versine	10	25	1517	3	ve_rsine
versing	11	23	1419	3	ve_rsing
wearing	11	33	1886	3	wear_ing
wearish	13	23	1015	3	wear_ish
wearying	15	4	670	3	wearying
yearling	12	9	788	3	yearling
yearning	12	9	698	3	yearning

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	90	7.110	20557.2
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	7.563	23627.0