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

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

53 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
samples	11	28	1545	(None)
sample	10	42	1501	1	sample_
sampled	12	34	1079	1	sampled
sampler	11	32	1201	1	sampler
samplers	12	29	940	1	samplers
simples	11	30	1494	1	simples
ambles	10	51	2186	2	_ambles
amoles	8	41	2219	2	_amoles
ample	9	47	2030	2	_ample_
ampler	10	43	1330	2	_ampler
amplest	11	3	1233	2	_amplest
ampules	11	8	943	2	_ampules
apples	10	43	1576	2	_apples
dapples	12	3	899	2	dapples
dimples	12	28	1321	2	dimples
ensamples	13	4	312	2	ensamples
examples	19	4	431	2	examples
gambles	12	40	1620	2	gambles
maples	10	48	1942	2	ma_ples
pimples	13	30	1242	2	pimples
rambles	11	31	1831	2	rambles
rampoles	12	3	889	2	rampoles
resamples	13	4	471	2	resamples
rimples	11	31	1422	2	rimples
rumples	11	33	1313	2	rumples
sables	8	50	2669	2	sa_bles
saddles	9	54	1574	2	saddles
sales	5	60	5559	2	sa__les
samiels	9	3	976	2	samiels
samites	9	31	1871	2	samites
samlet	8	41	2656	2	sam_let
samlets	9	38	1355	2	sam_lets
sampans	11	24	1100	2	sampans
samps	9	61	2467	2	samp__s
sapless	9	33	1344	2	sa_pless
scampies	14	3	932	2	scampies
semple	10	32	1275	2	semple_
shambles	15	15	904	2	shambles
similes	9	29	1523	2	similes
simple	10	43	1517	2	simple_
simpler	11	29	1086	2	simpler
simplest	12	23	1022	2	simplest
simplex	18	25	639	2	simplex
smiles	8	45	2229	2	s_miles
stampless	13	3	454	2	stampless
staples	9	36	1721	2	staples
supples	11	5	1128	2	supples
swiples	12	33	964	2	swiples
tamales	9	32	1615	2	tamales
temples	11	26	1089	2	temples
tramples	12	26	1020	2	tramples
wambles	14	37	1402	2	wambles
wimples	14	33	1117	2	wimples

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.140	1276364.3
2	DLD Change Limit	107671	53	3.423	31455.2
3	Display Results	53	53	0.013	4076.9
	(SQL Overall)	178691	53	3.576	49969.5