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

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

65 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
hempy	15	49	1276	(None)
heapy	13	59	1498	1	heapy
hemp	11	57	2562	1	hemp_
hemps	12	69	1733	1	hemps
humpy	15	51	1567	1	humpy
bumpy	14	47	1505	2	bumpy
campy	14	51	1618	2	campy
champy	18	50	961	2	champy
demy	10	54	2285	2	dem_y
dumpy	13	54	1475	2	dumpy
emmy	11	60	1324	2	_emmy
empty	12	4	776	2	_empty
espy	9	6	937	2	_espy
gemmy	13	52	1105	2	gemmy
gimpy	13	52	1223	2	gimpy
hammy	15	51	1343	2	hammy
happy	15	58	1353	2	happy
harpy	13	64	1820	2	harpy
heady	12	51	1726	2	heady
heap	9	64	3289	2	heap_
heaps	10	52	2322	2	heaps
heavy	14	48	1418	2	heavy
hedgy	13	45	1074	2	hedgy
hefty	14	61	1213	2	hefty
help	9	53	2892	2	help_
helps	10	52	1934	2	helps
hem	8	61	4873	2	hem__
hemal	10	44	1980	2	hemal
heme	9	50	3441	2	hem_e
hemes	10	50	3108	2	hemes
hemic	12	57	1862	2	hemic
hemin	10	36	2093	2	hemin
hempen	13	3	896	2	hempen
hempie	13	24	1056	2	hempie
hems	9	55	3494	2	hem_s
henry	11	40	1447	2	henry
hep	8	66	4414	2	he_p_
herby	13	47	1531	2	herby
herry	11	49	2247	2	herry
hey	9	67	4106	2	he__y
hippy	15	51	1279	2	hippy
homey	13	59	2484	2	homey
homy	12	66	2322	2	hom_y
hoppy	15	49	1235	2	hoppy
hump	11	62	2872	2	hump_
humph	15	57	1221	2	humph
humps	12	63	2280	2	humps
jemmy	19	49	855	2	jemmy
jimpy	19	52	1082	2	jimpy
jumpy	19	57	1281	2	jumpy
kelpy	14	51	1068	2	kelpy
kemp	12	64	1876	2	kemp_
kemps	13	50	1252	2	kemps
kempt	13	43	1846	2	kempt
lumpy	12	66	1591	2	lumpy
peppy	11	43	1036	2	peppy
seepy	10	47	1797	2	seepy
temp	8	53	2333	2	temp_
tempi	9	49	1220	2	tempi
tempo	9	52	1497	2	tempo
temps	9	54	1713	2	temps
tempt	9	51	2484	2	tempt
vampy	15	53	940	2	vampy
weepy	13	42	1259	2	weepy
wimpy	15	59	1192	2	wimpy

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	53800	0.096	1861364.6
2	DLD Change Limit	53800	65	1.890	28465.6
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	2.016	88636.4