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

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

38 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
hempier	14	31	900	(None)
hempie	13	24	1056	1	hempie_
humpier	14	31	1072	1	humpier
bumpier	13	35	920	2	bumpier
campier	13	33	1327	2	campier
dumpier	12	40	965	2	dumpier
empire	10	3	932	2	_empire
emptier	11	8	760	2	_emptier
gemmier	12	33	738	2	gemmier
gimpier	12	24	794	2	gimpier
hammier	14	35	1065	2	hammier
hamper	13	45	1865	2	hamp_er
happier	14	33	1203	2	happier
headier	11	32	1295	2	headier
heaper	11	41	1952	2	heap_er
heavier	13	42	942	2	heavier
hedgier	12	36	788	2	hedgier
heftier	13	3	720	2	heftier
helper	11	43	1309	2	help_er
hemipter	15	4	558	2	hemipter
hemmer	13	41	1264	2	hem_mer
hempen	13	3	896	2	hemp_en
hempiest	15	3	902	2	hempiest
hepper	13	34	1266	2	he_pper
herbier	12	3	959	2	herbier
hippier	14	32	1210	2	hippier
homier	11	64	1699	2	hom_ier
hoppier	14	31	1070	2	hoppier
humper	13	41	1588	2	hump_er
jumpier	18	31	794	2	jumpier
lumpier	11	34	1014	2	lumpier
peppier	10	26	832	2	peppier
seepier	9	29	1201	2	seepier
temper	10	39	1409	2	temp_er
tempter	11	35	821	2	tempter
vampier	14	30	823	2	vampier
weepier	12	31	927	2	weepier
wimpier	14	24	805	2	wimpier

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.360	496363.9
2	DLD Change Limit	107671	38	3.326	32372.5
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	3.702	48268.8