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

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

95 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
helping	13	35	1222	(None)
heaping	13	30	1585	1	heaping
helling	11	46	2322	1	helling
helming	13	37	1200	1	helming
helpings	14	25	565	1	helpings
helving	14	40	1113	1	helving
kelping	14	31	919	1	kelping
whelping	17	24	533	1	whelping
yelping	13	31	787	1	yelping
beeping	12	40	1391	2	beeping
belling	10	38	2507	2	belling
belting	10	41	1913	2	belting
belying	13	36	1244	2	belying
celling	10	39	2126	2	celling
cheeping	16	32	955	2	cheeping
cleping	12	33	1042	2	cleping
deleing	9	33	1395	2	deleing
delving	12	37	1157	2	delving
eloping	10	35	1283	2	_eloping
felling	11	33	2113	2	felling
felting	11	35	1521	2	felting
gelding	10	39	1179	2	gelding
gelling	9	32	1976	2	gelling
gulping	11	30	975	2	gulping
haling	10	42	2978	2	hal_ing
haloing	11	38	1413	2	haloing
halting	11	44	1907	2	halting
halving	14	35	1154	2	halving
happing	15	38	1723	2	happing
harping	13	41	1838	2	harping
hasping	13	44	1490	2	hasping
heading	12	29	1911	2	heading
healing	11	39	2296	2	healing
hearing	11	33	2416	2	hearing
heating	11	40	2432	2	heating
heaving	14	41	1476	2	heaving
hedging	13	34	895	2	hedging
heeding	12	35	1506	2	heeding
heeling	11	36	1851	2	heeling
heezing	20	34	987	2	heezing
hefting	14	45	1091	2	hefting
heiling	11	36	1636	2	heiling
heiring	11	33	1290	2	heiring
helloing	12	15	912	2	helloing
hemming	15	26	997	2	hemming
henting	11	37	1965	2	henting
herding	12	29	1512	2	herding
herring	11	36	1588	2	herring
hewing	13	45	1424	2	he_wing
hexing	17	42	1051	2	he_xing
hilding	12	37	1353	2	hilding
hilling	11	38	2177	2	hilling
hilting	11	33	1689	2	hilting
hipping	15	39	1510	2	hipping
holding	12	35	1428	2	holding
holing	10	40	2507	2	hol_ing
holking	15	35	1231	2	holking
hooping	13	36	1570	2	hooping
hoping	12	37	1974	2	h_oping
hopping	15	41	1527	2	hopping
hulking	15	39	1098	2	hulking
hulling	11	36	1901	2	hulling
humping	15	32	1307	2	humping
hyping	15	40	848	2	h_yping
jeeping	17	40	1033	2	jeeping
jelling	15	35	1661	2	jelling
keeping	14	40	1254	2	keeping
kepping	16	26	859	2	kepping
leaping	10	32	1599	2	leaping
melding	11	34	1427	2	melding
melling	10	28	2262	2	melling
melting	10	33	1775	2	melting
palping	12	41	1287	2	palping
peeping	12	36	1521	2	peeping
pelting	10	29	1727	2	pelting
pepping	11	35	1162	2	pepping
pulping	12	36	1232	2	pulping
reaping	10	36	2121	2	reaping
relying	11	29	1461	2	relying
repping	12	33	1498	2	repping
seeping	10	38	1791	2	seeping
selfing	11	29	1162	2	selfing
selling	8	32	2583	2	selling
shelling	12	35	1521	2	shelling
shelving	15	27	817	2	shelving
skelping	15	3	597	2	skelping
telling	8	33	2108	2	telling
temping	12	27	1069	2	temping
weeping	13	36	1367	2	weeping
welding	12	32	1325	2	welding
welling	11	29	2031	2	welling
welting	11	36	1531	2	welting
wheeping	17	33	710	2	wheeping
whelming	17	30	492	2	whelming
yelling	11	35	1670	2	yelling

Search took 4 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	95	3.563	30219.2
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	3.716	48086.9