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

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

87 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
helving	14	40	1113	(None)
delving	12	37	1157	1	delving
halving	14	35	1154	1	halving
heaving	14	41	1476	1	heaving
helling	11	46	2322	1	helling
helming	13	37	1200	1	helming
helping	13	35	1222	1	helping
shelving	15	27	817	1	shelving
belling	10	38	2507	2	belling
belting	10	41	1913	2	belting
belying	13	36	1244	2	belying
calving	13	41	1350	2	calving
celling	10	39	2126	2	celling
deaving	12	38	1475	2	deaving
deleing	9	33	1395	2	deleing
felling	11	33	2113	2	felling
felting	11	35	1521	2	felting
gelding	10	39	1179	2	gelding
gelling	9	32	1976	2	gelling
haling	10	42	2978	2	hal_ing
haloing	11	38	1413	2	haloing
halting	11	44	1907	2	halting
having	13	42	2037	2	h_aving
heading	12	29	1911	2	heading
healing	11	39	2296	2	healing
heaping	13	30	1585	2	heaping
hearing	11	33	2416	2	hearing
heating	11	40	2432	2	heating
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
helpings	14	25	565	2	helpings
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
hiving	13	41	1552	2	h_iving
holding	12	35	1428	2	holding
holing	10	40	2507	2	hol_ing
holking	15	35	1231	2	holking
hulking	15	39	1098	2	hulking
hulling	11	36	1901	2	hulling
jelling	15	35	1661	2	jelling
kelping	14	31	919	2	kelping
kelvin	13	11	732	2	kelvin_
kelvins	14	10	656	2	kelvins
leaving	11	42	1685	2	leaving
melding	11	34	1427	2	melding
melling	10	28	2262	2	melling
melting	10	33	1775	2	melting
nerving	11	29	1082	2	nerving
peeving	13	51	1224	2	peeving
pelting	10	29	1727	2	pelting
reaving	11	38	2053	2	reaving
reeving	11	37	1766	2	reeving
reiving	11	33	1684	2	reiving
reliving	12	27	1334	2	reliving
relying	11	29	1461	2	relying
revving	14	37	934	2	revving
salving	11	39	1315	2	salving
selfing	11	29	1162	2	selfing
selling	8	32	2583	2	selling
serving	11	30	1498	2	serving
sheaving	15	41	1025	2	sheaving
shelling	12	35	1521	2	shelling
shelvings	16	28	382	2	shelvings
solving	11	29	1085	2	solving
telling	8	33	2108	2	telling
valving	14	36	855	2	valving
weaving	14	32	1162	2	weaving
welding	12	32	1325	2	welding
welling	11	29	2031	2	welling
welting	11	36	1531	2	welting
whelming	17	30	492	2	whelming
whelping	17	24	533	2	whelping
yelling	11	35	1670	2	yelling
yelping	13	31	787	2	yelping

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	87	3.360	32044.9
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	3.516	50822.2