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

Here are the results of your fuzzy-string dictionary search for “hepper” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

102 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
hepper	13	34	1266	(None)
heaper	11	41	1952	1	heaper
helper	11	43	1309	1	helper
hipper	13	38	1802	1	hipper
hopper	13	42	1848	1	hopper
pepper	9	35	1294	1	pepper
beeper	10	37	1409	2	beeper
bopper	12	38	1383	2	bopper
capper	12	44	2198	2	capper
cheaper	14	40	1058	2	cheaper
cheeper	14	36	1074	2	cheeper
chipper	16	39	1258	2	chipper
chopper	16	36	1189	2	chopper
copper	12	43	2189	2	copper
cupper	12	43	1386	2	cupper
dapper	11	40	1663	2	dapper
deeper	9	36	1350	2	deeper
dipper	11	40	1779	2	dipper
gipper	11	42	1530	2	gipper
gypper	14	34	729	2	gypper
hamper	13	45	1865	2	hamper
happed	14	48	2010	2	happed
happen	13	48	1219	2	happen
happier	14	33	1204	2	happier
harper	11	50	1840	2	harper
header	10	44	2254	2	header
healer	9	42	2180	2	healer
heaped	12	45	1690	2	heaped
heapers	12	36	1667	2	heapers
hearer	9	43	2365	2	hearer
heater	9	48	2830	2	heater
heaver	12	48	1967	2	heaver
heder	9	56	2364	2	he_der
hedger	11	49	1265	2	hedger
heeder	10	42	1604	2	heeder
heeler	9	39	1732	2	heeler
hefter	12	43	1392	2	hefter
heifer	12	3	820	2	heifer
heller	9	33	2251	2	heller
helped	12	47	1415	2	helped
helpers	12	33	1185	2	helpers
hemmer	13	41	1264	2	hemmer
hempen	13	3	896	2	hempen
hempier	14	31	900	2	hempier
heppest	14	22	815	2	heppest
herder	10	45	1646	2	herder
herpes	11	55	1732	2	herpes
hewer	11	57	1993	2	he_wer
hexer	15	51	1668	2	he_xer
hipped	14	43	1769	2	hipped
hippier	14	32	1210	2	hippier
hooper	11	45	1831	2	hooper
hoper	10	58	2914	2	h_oper
hopped	14	43	1811	2	hopped
hoppers	14	31	1514	2	hoppers
hoppier	14	31	1070	2	hoppier
humper	13	41	1588	2	humper
hyper	13	52	1390	2	h_yper
keeper	12	38	1192	2	keeper
kepped	15	30	954	2	kepped
keppen	14	34	657	2	keppen
kipper	14	34	1421	2	kipper
lapper	10	43	1995	2	lapper
leaper	8	81	1894	2	leaper
leper	7	48	2074	2	le_per
lipper	10	42	1963	2	lipper
lopper	10	37	1720	2	lopper
mapper	12	45	1609	2	mapper
mopper	12	62	1500	2	mopper
napper	10	37	1828	2	napper
nipper	10	37	1571	2	nipper
peeper	10	36	1480	2	peeper
pepped	10	31	1340	2	pepped
peppers	10	33	1144	2	peppers
peppery	13	28	625	2	peppery
peppier	10	26	832	2	peppier
popper	9	36	1596	2	popper
rapper	10	46	2157	2	rapper
reaper	8	42	2314	2	reaper
repaper	11	3	1002	2	repaper
repped	11	46	1672	2	repped
ripper	10	35	1865	2	ripper
sapper	10	38	2235	2	sapper
shipper	14	35	1404	2	shipper
shopper	14	33	1263	2	shopper
sipper	10	39	2099	2	sipper
stepper	11	30	1085	2	stepper
supper	10	41	1543	2	supper
tapper	10	44	1961	2	tapper
temper	10	39	1409	2	temper
tipper	10	39	1841	2	tipper
topper	10	38	1760	2	topper
upper	9	37	1426	2	_upper
vesper	11	3	808	2	vesper
weeper	11	43	1330	2	weeper
whapper	17	34	827	2	whapper
whipper	17	36	1138	2	whipper
whopper	17	32	850	2	whopper
yapper	13	37	1451	2	yapper
yelper	11	45	878	2	yelper
zapper	19	34	1402	2	zapper
zipper	19	38	1312	2	zipper

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	102	2.220	37185.1
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	2.593	68912.8