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

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

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.

48 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	(None)
hearing	11	33	2416	1	hear_ing
hearting	12	5	1312	1	hearting
bearding	12	40	1194	2	bearding
bearing	10	36	2477	2	bear_ing
ceasing	10	41	1826	2	cea_sing
earing	7	52	3548	2	_ear_ing
earning	8	34	1821	2	_earning
earring	8	35	1901	2	_earring
easing	7	49	2646	2	_ea_sing
erasing	8	3	1795	2	_erasing
fearing	11	35	2003	2	fear_ing
feasing	11	39	1665	2	fea_sing
gearing	9	28	1884	2	gear_ing
haring	10	42	3300	2	h_ar_ing
harking	15	41	2094	2	h_arking
harming	13	37	1793	2	h_arming
harping	13	41	1838	2	h_arping
heading	12	29	1911	2	hea_ding
healing	11	39	2296	2	hea_ling
heaping	13	30	1585	2	hea_ping
hearings	12	36	1184	2	hear_ings
heating	11	40	2432	2	hea_ting
heaving	14	41	1476	2	hea_ving
heiring	11	33	1290	2	heir_ing
herding	12	29	1512	2	he_rding
herring	11	36	1587	2	he_rring
herrying	15	14	701	2	herrying
hoarding	13	28	864	2	hoarding
horsing	11	32	1558	2	h_orsing
learning	9	7	855	2	learning
leasing	8	39	2016	2	lea_sing
nearing	8	30	2033	2	near_ing
parsing	10	38	1955	2	_parsing
pearling	11	9	1200	2	pearling
rearing	8	31	2878	2	rear_ing
rearming	11	14	1360	2	rearming
rehearsing	14	4	434	2	rehearsing
searing	8	33	3092	2	sear_ing
shearing	12	39	1590	2	shear_ing
shearling	13	3	692	2	shearling
tearing	8	40	2149	2	tear_ing
teasing	8	39	1851	2	tea_sing
versing	11	23	1419	2	ve_rsing
wearing	11	33	1886	2	wear_ing
wearying	15	4	669	2	wearying
yearling	12	9	788	2	yearling
yearning	12	9	698	2	yearning

Search took 6 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	121059	0.140	1276364.3
2	DLD Change Limit	121059	48	5.173	23402.1
3	Display Results	48	48	0.013	3692.3
	(SQL Overall)	178691	48	5.326	33550.7