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

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

66 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
rimple	10	38	1458	(None)
crimple	13	40	869	1	crimple
dimple	11	35	1279	1	dimple
pimple	12	35	1296	1	pimple
rimpled	12	33	1142	1	rimpled
rimples	11	31	1422	1	rimples
ripple	10	34	1391	1	ripple
rumple	10	39	1301	1	rumple
simple	10	43	1517	1	simple
wimple	13	36	1136	1	wimple
ample	9	47	2030	2	_ample
crimpled	15	36	693	2	crimpled
crimples	14	30	896	2	crimples
cripple	13	37	858	2	cripple
crumple	13	36	836	2	crumple
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
gripple	12	41	661	2	gripple
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	918	2	pimpled
pimples	13	30	1242	2	pimples
pimply	15	32	921	2	pimply
ramble	10	45	1997	2	ramble
rampole	11	3	969	2	rampole
riddle	8	39	1571	2	riddle
riffle	12	42	1023	2	riffle
rifle	8	55	1833	2	ri_fle
rile	4	56	5053	2	ri__le
rille	5	57	2873	2	ri_lle
rime	6	51	3888	2	rim__e
rimose	8	3	1059	2	rimose
ripe	6	60	3892	2	ri_p_e
rippled	12	31	1027	2	rippled
rippler	11	32	1010	2	rippler
ripples	11	35	1329	2	ripples
ripplet	11	34	1258	2	ripplet
ripply	13	34	800	2	ripply
rumble	10	37	1881	2	rumble
rumpled	12	38	1001	2	rumpled
rumples	11	33	1313	2	rumples
rumply	13	34	857	2	rumply
sample	10	42	1501	2	sample
semple	10	32	1275	2	semple
simile	8	31	1563	2	simile
simpler	11	29	1086	2	simpler
simples	11	30	1494	2	simples
simplex	18	25	639	2	simplex
simply	13	30	1052	2	simply
temple	10	28	1133	2	temple
tipple	10	34	1191	2	tipple
trample	11	29	970	2	trample
triple	8	42	1592	2	tri_ple
wimble	13	32	1192	2	wimble
wimpled	15	33	882	2	wimpled
wimples	14	33	1117	2	wimples

Search took 5 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.110	1624463.6
2	DLD Change Limit	82551	66	4.076	20252.9
3	Display Results	66	66	0.046	1434.8
	(SQL Overall)	178691	66	4.232	42223.8