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

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

79 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
hearting	12	5	1312	(None)
hearing	11	33	2416	1	hear_ing
hearsing	12	3	938	1	hearsing
heating	11	40	2432	1	hea_ting
aerating	9	28	2100	2	aerating
bearding	12	40	1194	2	bearding
bearing	10	36	2477	2	bear_ing
beating	10	43	2687	2	bea_ting
berating	11	32	2076	2	berating
carting	10	42	2828	2	_carting
charting	14	26	1419	2	charting
cheating	14	40	1452	2	chea_ting
darting	9	40	2066	2	_darting
departing	13	4	951	2	departing
derating	10	32	2228	2	derating
earing	7	52	3548	2	_ear_ing
earning	8	34	1821	2	_earning
earring	8	35	1901	2	_earring
earthing	12	3	1032	2	_earthing
easting	8	49	2430	2	_easting
eating	7	51	3440	2	_ea_ting
farting	11	41	2075	2	_farting
fearing	11	35	2003	2	fear_ing
feasting	12	20	1132	2	feasting
gearing	9	28	1884	2	gear_ing
hafting	14	40	1417	2	h_afting
halting	11	44	1907	2	h_alting
hanting	11	41	2448	2	h_anting
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
hasting	11	47	2519	2	h_asting
hating	10	49	2971	2	h_a_ting
hatting	11	39	2023	2	h_atting
heading	12	29	1911	2	hea_ding
healing	11	39	2296	2	hea_ling
heaping	13	30	1585	2	hea_ping
hearings	12	36	1185	2	hear_ings
hearten	10	24	1175	2	hearten_
heartening	14	4	673	2	heartening
heartens	11	30	1015	2	heartens
heartier	11	3	909	2	heartier
hearties	11	3	1541	2	hearties
heartily	14	3	656	2	heartily
heaving	14	41	1476	2	hea_ving
hefting	14	45	1091	2	he_fting
heiring	11	33	1290	2	heir_ing
heisting	12	34	1104	2	heisting
henting	11	37	1965	2	he_nting
herding	12	29	1512	2	he_rding
herring	11	36	1588	2	he_rring
herrying	15	14	702	2	herrying
hoarding	13	28	864	2	hoarding
hurting	11	39	1403	2	h_urting
karting	12	37	1606	2	_karting
learning	9	7	855	2	learning
marting	10	33	2501	2	_marting
nearing	8	30	2033	2	near_ing
parting	10	35	2738	2	_parting
pearling	11	9	1201	2	pearling
reacting	11	33	1789	2	reacting
rearing	8	31	2878	2	rear_ing
rearming	11	14	1361	2	rearming
scarting	11	34	1526	2	scarting
searing	8	33	3092	2	sear_ing
seating	8	41	3068	2	sea_ting
shearing	12	39	1590	2	shear_ing
shearling	13	3	692	2	shearling
smarting	11	32	1245	2	smarting
starting	9	31	1617	2	starting
tarting	8	42	2265	2	_tarting
tearing	8	40	2149	2	tear_ing
thwarting	16	3	276	2	thwarting
wearing	11	33	1886	2	wear_ing
wearying	15	4	670	2	wearying
yearling	12	9	788	2	yearling
yearning	12	9	698	2	yearning
yeasting	12	18	892	2	yeasting

Search took 5 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.406	440125.6
2	DLD Change Limit	121059	79	4.016	30144.2
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	4.452	40137.2