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

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

61 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
simple	10	43	1517	(None)
dimple	11	35	1279	1	dimple
pimple	12	35	1296	1	pimple
rimple	10	38	1458	1	rimple
sample	10	42	1501	1	sample
semple	10	32	1275	1	semple
simile	8	31	1563	1	simile
simpler	11	29	1086	1	simpler
simples	11	30	1494	1	simples
simplex	18	25	639	1	simplex
simply	13	30	1052	1	simply
wimple	13	36	1136	1	wimple
ample	9	47	2030	2	_ample
crimple	13	40	869	2	crimple
dimpled	13	28	1030	2	dimpled
dimples	12	28	1321	2	dimples
dimply	14	33	974	2	dimply
fimble	13	36	1175	2	fimble
fipple	13	32	906	2	fipple
hirple	11	15	897	2	hirple
impale	10	28	1166	2	_impale
impel	9	57	1177	2	_impel
impled	11	38	1251	2	_impled
imply	12	49	1184	2	_imply
jimply	20	39	748	2	jimply
limply	13	38	1003	2	limply
nimble	10	34	1294	2	nimble
nipple	10	34	1037	2	nipple
pimpled	14	28	919	2	pimpled
pimples	13	30	1242	2	pimples
pimply	15	32	921	2	pimply
rimpled	12	33	1142	2	rimpled
rimples	11	31	1422	2	rimples
ripple	10	34	1391	2	ripple
rumple	10	39	1301	2	rumple
sampled	12	34	1079	2	sampled
sampler	11	32	1201	2	sampler
samples	11	28	1545	2	samples
sempre	10	27	1009	2	sempre
sickle	12	44	1832	2	sickle
sidle	6	51	2403	2	si_dle
similes	9	29	1523	2	similes
simnel	8	5	702	2	simnel
simp	8	52	2877	2	simp__
simper	10	36	1629	2	simper
simplest	12	23	1022	2	simplest
simps	9	47	1976	2	simp_s
single	7	45	2060	2	single
sipe	6	73	4104	2	si_p_e
sizzle	14	30	961	2	sizzle
smile	7	48	2392	2	s_mile
staple	8	44	1582	2	staple
stipple	11	4	662	2	stipple
supple	10	4	1020	2	supple
swiple	11	37	923	2	swiple
swipple	14	4	463	2	swipple
temple	10	28	1133	2	temple
tipple	10	34	1191	2	tipple
wimble	13	32	1192	2	wimble
wimpled	15	33	882	2	wimpled
wimples	14	33	1117	2	wimples

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	61	2.563	32208.7
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	2.922	61153.7