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

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

39 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
sampler	11	32	1201	(None)
ampler	10	43	1330	1	_ampler
sample	10	42	1501	1	sample_
sampled	12	34	1079	1	sampled
samplers	12	29	940	1	samplers
samples	11	28	1545	1	samples
simpler	11	29	1086	1	simpler
ambler	10	49	1645	2	_ambler
ample	9	47	2030	2	_ample_
camper	12	47	2221	2	camp_er
campier	13	33	1327	2	campier
damper	11	41	1775	2	damp_er
gambler	12	36	1268	2	gambler
hamper	13	45	1865	2	hamp_er
pamper	12	43	1666	2	pamp_er
rambler	11	33	1326	2	rambler
saddler	9	38	1196	2	saddler
sailer	6	35	2610	2	sa_iler
samlet	8	41	2656	2	sam_let
sapper	10	38	2235	2	sa_pper
sappier	11	36	1312	2	sappier
scamper	13	46	1316	2	scamp_er
semple	10	32	1275	2	semple_
simper	10	36	1629	2	simp_er
simple	10	43	1517	2	simple_
simples	11	30	1494	2	simples
simplex	18	25	639	2	simplex
smaller	9	34	1033	2	smaller
smiler	8	39	1668	2	s_miler
stamper	11	37	1440	2	stamp_er
stapler	9	39	1364	2	stapler
sumpter	11	3	887	2	sumpter
suppler	11	4	844	2	suppler
swamper	14	34	931	2	swamp_er
swampier	15	4	459	2	swampier
tamper	10	46	1851	2	tamp_er
trampler	12	27	801	2	trampler
vamper	13	42	1265	2	vamp_er
vampier	14	30	823	2	vampier

Search took 6 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.766	233278.1
2	DLD Change Limit	107671	39	5.046	21337.9
3	Display Results	39	39	0.016	2437.5
	(SQL Overall)	178691	39	5.828	30660.8