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

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

79 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
paddler	11	37	1155	(None)
padder	10	34	1549	1	padd_er
paddle	10	46	1514	1	paddle_
paddled	12	36	1202	1	paddled
paddlers	12	32	915	1	paddlers
paddles	11	35	1564	1	paddles
peddler	11	32	1049	1	peddler
piddler	11	29	1152	1	piddler
puddler	11	29	1075	1	puddler
saddler	9	38	1196	1	saddler
waddler	12	40	1079	1	waddler
adder	7	54	1959	2	_add_er
addle	7	43	1835	2	_addle_
addled	9	41	1252	2	_addled
addles	8	42	1660	2	_addles
badder	10	38	1751	2	badd_er
candler	10	35	1659	2	candler
coddler	11	37	1083	2	coddler
cuddler	11	38	1074	2	cuddler
daddle	9	42	1428	2	daddle_
daddled	11	38	1074	2	daddled
daddles	10	42	1380	2	daddles
dandler	9	44	1427	2	dandler
dawdler	12	35	679	2	dawdler
diddler	10	35	1151	2	diddler
faddier	12	3	778	2	faddier
fiddler	12	30	995	2	fiddler
gadder	9	37	1471	2	gadd_er
handler	11	35	1616	2	handler
huddler	12	37	942	2	huddler
ladder	8	46	1762	2	ladd_er
ladler	7	43	1493	2	la_dler
landler	8	41	1320	2	landler
madder	10	35	1559	2	madd_er
meddler	11	31	995	2	meddler
middler	11	27	1227	2	middler
muddler	11	34	1162	2	muddler
padded	11	41	1350	2	padd_ed
padders	11	33	1287	2	padd_ers
paddies	11	37	1572	2	paddies
padle	8	45	2234	2	pa_dle_
padles	9	52	2112	2	pa_dles
paler	7	54	3693	2	pa__ler
pander	9	37	2552	2	pand_er
pardner	10	23	947	2	pardner
pedaler	10	34	1069	2	pedaler
peddle	10	35	1282	2	peddle_
peddled	12	34	1054	2	peddled
peddlers	12	29	853	2	peddlers
peddlery	15	22	401	2	peddlery
peddles	11	29	1370	2	peddles
pedler	9	36	1462	2	p_edler
piddle	10	35	1491	2	piddle_
piddled	12	33	1125	2	piddled
piddlers	12	35	959	2	piddlers
piddles	11	43	1427	2	piddles
puddle	10	39	1415	2	puddle_
puddled	12	30	1119	2	puddled
puddlers	12	29	868	2	puddlers
puddles	11	36	1382	2	puddles
puddlier	12	3	421	2	puddlier
raddle	8	48	1617	2	raddle_
raddled	10	38	1222	2	raddled
raddles	9	36	1570	2	raddles
riddler	9	34	1126	2	riddler
sadder	8	29	1697	2	sadd_er
saddle	8	39	1549	2	saddle_
saddled	10	31	1203	2	saddled
saddlers	10	28	975	2	saddlers
saddlery	13	27	491	2	saddlery
saddles	9	54	1574	2	saddles
tiddler	9	31	1000	2	tiddler
toddler	9	37	904	2	toddler
twaddler	13	31	464	2	twaddler
wadder	11	42	1548	2	wadd_er
waddle	11	47	1530	2	waddle_
waddled	13	36	1164	2	waddled
waddlers	13	29	833	2	waddlers
waddles	12	43	1484	2	waddles

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	79	3.503	30736.8
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	3.906	45747.8