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

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

99 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
helmed	12	45	1369	(None)
helled	10	40	2470	1	helled
helmet	11	37	1893	1	helmet
helped	12	47	1415	1	helped
helved	13	43	1370	1	helved
hemmed	14	42	1146	1	hemmed
whelmed	16	37	515	1	whelmed
beamed	11	57	2073	2	beamed
belied	9	50	2216	2	belied
belled	9	46	2619	2	belled
belted	9	40	2063	2	belted
bermed	11	52	1772	2	bermed
calmed	11	48	1638	2	calmed
celled	9	44	2032	2	celled
culmed	11	46	1059	2	culmed
deemed	10	47	1306	2	deemed
deled	7	53	2654	2	del_ed
delimed	11	3	1072	2	delimed
delved	11	41	1275	2	delved
felled	10	37	2030	2	felled
felted	10	37	1465	2	felted
filmed	12	46	1036	2	filmed
gelded	9	45	1211	2	gelded
gelled	8	47	1889	2	gelled
gemmed	12	32	957	2	gemmed
haled	9	53	3582	2	hal_ed
haloed	10	47	1760	2	haloed
halted	10	50	1960	2	halted
halved	13	48	1390	2	halved
hammed	14	41	1697	2	hammed
harmed	12	52	1883	2	harmed
headed	11	40	2047	2	headed
healed	10	51	2144	2	healed
heaped	12	45	1690	2	heaped
heated	10	45	2559	2	heated
heaved	13	47	1786	2	heaved
hedged	12	52	1181	2	hedged
heed	8	64	3760	2	he__ed
heeded	11	42	1576	2	heeded
heeled	10	40	1841	2	heeled
heezed	19	42	1051	2	heezed
hefted	13	49	1142	2	hefted
heiled	10	44	1561	2	heiled
heired	10	38	1304	2	heired
held	8	53	3040	2	hel__d
heller	9	33	2251	2	heller
helloed	11	35	1242	2	helloed
helm	9	55	3002	2	helm__
helmeted	14	3	583	2	helmeted
helmets	12	30	907	2	helmets
helms	10	56	1946	2	helm_s
helper	11	43	1309	2	helper
helve	11	50	1809	2	helve_
helves	12	43	1606	2	helves
heme	9	50	3441	2	he_me_
hemes	10	50	3108	2	he_mes
hemmer	13	41	1264	2	hemmer
hented	10	42	1875	2	hented
herbed	12	35	1345	2	herbed
herded	11	42	1564	2	herded
hewed	12	56	1943	2	he_wed
hexed	16	56	1576	2	he_xed
hilled	10	40	2222	2	hilled
hilted	10	40	1604	2	hilted
holed	9	56	3413	2	hol_ed
holked	14	49	1366	2	holked
homed	11	54	2542	2	h_omed
hulked	14	46	1130	2	hulked
hulled	10	39	2001	2	hulled
hummed	14	48	1267	2	hummed
jelled	14	49	1606	2	jelled
kelped	13	44	955	2	kelped
melamed	12	4	963	2	melamed
melded	10	47	1471	2	melded
melled	9	50	2302	2	melled
melted	9	42	1906	2	melted
palmed	11	43	1464	2	palmed
pelmet	10	34	1924	2	pelmet
pelted	9	46	1776	2	pelted
permed	11	52	1735	2	permed
reamed	9	43	2612	2	reamed
relied	7	49	2623	2	relied
relumed	10	6	981	2	relumed
seamed	9	48	2388	2	seamed
seemed	9	51	1761	2	seemed
selfed	10	3	1091	2	selfed
shelled	11	38	1509	2	shelled
shelved	14	37	993	2	shelved
teamed	9	54	1859	2	teamed
teemed	9	51	1487	2	teemed
termed	9	48	1670	2	termed
themed	12	59	1258	2	the_med
unhelmed	14	3	599	2	unhelmed
welded	11	40	1338	2	welded
welled	10	38	2021	2	welled
welted	10	37	1582	2	welted
whelped	16	35	563	2	whelped
yelled	10	41	1625	2	yelled
yelped	12	43	936	2	yelped

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	99	2.156	38289.0
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	2.529	70656.8