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

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

57 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
harpings	14	37	977	(None)
carpings	13	38	1239	1	carpings
harping	13	41	1838	1	harping_
harpins	12	36	1570	1	harpin_s
armings	10	38	1150	2	_armings
campings	15	40	1020	2	campings
cappings	15	36	949	2	cappings
cardings	12	38	1264	2	cardings
carlings	11	40	1586	2	carlings
carping	12	35	2108	2	carping_
carvings	14	38	1021	2	carvings
dampings	14	37	752	2	dampings
darings	9	37	1365	2	dar_ings
darlings	10	37	1038	2	darlings
darnings	10	37	855	2	darnings
earings	8	45	1771	2	ear_ings
earnings	9	41	933	2	earnings
earrings	9	29	963	2	earrings
farmings	14	29	822	2	farmings
hairpins	13	6	543	2	hairpin_s
hangings	13	25	858	2	hangings
happing	15	38	1723	2	happing_
haring	10	42	3300	2	har_ing_
harking	15	41	2094	2	harking_
harmines	13	27	1514	2	harmines
harming	13	37	1793	2	harming_
harmins	12	37	1672	2	harmin_s
harpies	12	38	1832	2	harpi_es
harpin	11	36	1438	2	harpin__
harpists	13	3	810	2	harpists
hasping	13	44	1490	2	hasping_
hatpins	12	34	1064	2	hatpin_s
hawkings	19	33	613	2	hawkings
hayings	14	37	939	2	ha_yings
hazings	20	37	834	2	ha_zings
hearings	12	36	1185	2	hear_ings
helpings	14	25	565	2	helpings
herrings	12	37	953	2	herrings
hoardings	14	31	511	2	hoardings
hoppings	16	30	652	2	hoppings
hornings	12	23	836	2	hornings
hurlings	12	38	821	2	hurlings
kartings	13	41	852	2	kartings
mappings	15	29	641	2	mappings
markings	15	34	1024	2	markings
marlings	11	37	1349	2	marlings
pargings	12	34	1016	2	pargings
parings	10	42	1921	2	par_ings
parkings	15	36	1068	2	parkings
partings	11	35	1373	2	partings
pharmings	17	25	472	2	pharmings
raspings	11	33	785	2	raspings
sharping	14	30	1137	2	sharping_
tappings	13	26	771	2	tappings
warnings	12	35	845	2	warnings
warping	13	37	1518	2	warping_
yawpings	17	25	358	2	yawpings

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.843	211970.3
2	DLD Change Limit	121059	57	4.500	26902.0
3	Display Results	57	57	0.030	1900.0
	(SQL Overall)	178691	57	5.373	33257.2