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

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

69 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
stumped	12	42	1015	(None)
slumped	12	37	1015	1	slumped
stamped	12	48	1281	1	stamped
stomped	12	41	1053	1	stomped
stummed	12	34	855	1	stummed
stumper	11	36	1009	1	stumper
tumped	11	42	1623	1	_tumped
bumped	13	44	1400	2	_bumped
chumped	17	37	949	2	chumped
clumped	14	36	1066	2	clumped
crumped	14	43	1122	2	crumped
dumped	12	38	1449	2	_dumped
flumped	15	37	771	2	flumped
grumped	13	33	733	2	grumped
humped	14	40	1524	2	_humped
jumped	18	35	1155	2	_jumped
lumped	11	42	1696	2	_lumped
mumped	13	38	1316	2	_mumped
plumped	14	31	864	2	plumped
pumped	13	39	1556	2	_pumped
scamped	14	47	1196	2	scamped
sculped	12	39	825	2	sculped
scummed	14	34	791	2	scummed
shlumped	16	4	344	2	shlumped
skimped	16	25	622	2	skimped
slummed	12	35	927	2	slummed
slurped	10	36	875	2	slurped
souped	9	50	1767	2	sou_ped
spumed	11	47	1154	2	spum_ed
stampede	13	32	616	2	stampede
stamper	11	37	1440	2	stamper
steeped	10	34	1228	2	steeped
stemmed	12	27	815	2	stemmed
stepped	12	32	1005	2	stepped
stimied	10	3	1062	2	stimied
stiped	9	45	1707	2	st_iped
stomper	11	41	1123	2	stomper
stooped	10	38	1383	2	stooped
stoped	9	47	2101	2	st_oped
stopped	12	45	1220	2	stopped
striped	10	52	1436	2	striped
strummed	13	4	447	2	strummed
strumpet	12	5	603	2	strumpet
stubbed	12	37	808	2	stubbed
studded	10	23	687	2	studded
studied	9	26	869	2	studied
stuffed	14	32	897	2	stuffed
stumbled	13	3	562	2	stumbled
stump	9	46	1646	2	stump__
stumpers	12	31	831	2	stumpers
stumpier	12	5	588	2	stumpier
stumps	10	49	1228	2	stump_s
stumpy	13	45	813	2	stump_y
stunned	8	35	889	2	stunned
stunted	8	30	1040	2	stunted
stupe	7	52	1775	2	stu_pe_
stupes	8	41	1695	2	stu_pes
stupid	9	3	759	2	stu_pid
stymied	13	3	566	2	stymied
summed	11	40	1404	2	s_ummed
supped	11	44	1570	2	s_upped
swamped	15	49	844	2	swamped
tamped	11	43	1704	2	_tamped
temped	11	39	1289	2	_temped
thumped	15	38	741	2	thumped
trumped	12	43	971	2	trumped
tupped	11	40	1323	2	_tupped
umped	10	47	1727	2	__umped
whumped	18	33	563	2	whumped

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.373	479064.3
2	DLD Change Limit	107671	69	3.533	30475.8
3	Display Results	69	69	0.013	5307.7
	(SQL Overall)	178691	69	3.919	45596.1