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

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

83 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
paddle	10	46	1514	(None)
addle	7	43	1835	1	_addle
daddle	9	42	1428	1	daddle
paddled	12	36	1202	1	paddled
paddler	11	37	1155	1	paddler
paddles	11	35	1564	1	paddles
padle	8	45	2234	1	pa_dle
peddle	10	35	1282	1	peddle
piddle	10	35	1491	1	piddle
puddle	10	39	1415	1	puddle
raddle	8	48	1617	1	raddle
saddle	8	39	1549	1	saddle
waddle	11	47	1530	1	waddle
addled	9	41	1252	2	_addled
addles	8	42	1660	2	_addles
baddie	10	41	1403	2	baddie
buddle	10	43	1308	2	buddle
caddie	10	43	1645	2	caddie
candle	9	43	2148	2	candle
caudle	9	39	1291	2	caudle
coddle	10	47	1385	2	coddle
cuddle	10	44	1453	2	cuddle
daddled	11	38	1074	2	daddled
daddles	10	42	1380	2	daddles
dandle	8	42	1809	2	dandle
dawdle	11	39	950	2	dawdle
diddle	9	49	1521	2	diddle
fiddle	11	36	1338	2	fiddle
fuddle	11	33	1210	2	fuddle
handle	10	42	1929	2	handle
heddle	11	42	1116	2	heddle
huddle	11	37	1299	2	huddle
laddie	8	37	1317	2	laddie
ladle	6	63	2044	2	la_dle
meddle	10	33	1276	2	meddle
middle	10	34	1498	2	middle
muddle	10	34	1463	2	muddle
noddle	8	32	1136	2	noddle
padded	11	41	1350	2	padded
padder	10	34	1549	2	padder
paddies	11	37	1572	2	paddies
paddlers	12	32	915	2	paddlers
paddy	12	59	1359	2	padd_y
padles	9	52	2112	2	pa_dles
padre	8	60	1816	2	pa_dre
pale	6	60	5501	2	pa__le
papule	10	22	1213	2	papule
pardee	9	39	2202	2	pardee
pardie	9	60	2144	2	pardie
parle	7	58	3616	2	pa_rle
parole	8	44	2525	2	parole
peddled	12	34	1054	2	peddled
peddler	11	32	1049	2	peddler
peddles	11	29	1370	2	peddles
piddled	12	33	1125	2	piddled
piddler	11	29	1152	2	piddler
piddles	11	43	1427	2	piddles
piddly	13	31	914	2	piddly
poodle	9	31	1204	2	poodle
puddled	12	30	1119	2	puddled
puddler	11	29	1075	2	puddler
puddles	11	36	1382	2	puddles
puddly	13	43	813	2	puddly
raddled	10	38	1222	2	raddled
raddles	9	36	1570	2	raddles
reddle	8	38	1591	2	reddle
riddle	8	39	1571	2	riddle
ruddle	8	34	1420	2	ruddle
saddled	10	31	1203	2	saddled
saddler	9	38	1196	2	saddler
saddles	9	54	1574	2	saddles
spraddle	12	19	416	2	spraddle
staddle	9	28	809	2	staddle
swaddle	12	27	674	2	swaddle
toddle	8	58	1103	2	toddle
twaddle	12	24	571	2	twaddle
waddie	11	40	1332	2	waddie
waddled	13	36	1164	2	waddled
waddler	12	40	1079	2	waddler
waddles	12	43	1484	2	waddles
waddly	14	47	872	2	waddly
wandle	10	53	1666	2	wandle
widdle	11	38	1484	2	widdle

Search took 7 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.733	243780.4
2	DLD Change Limit	82551	83	5.393	15307.1
3	Display Results	83	83	0.060	1383.3
	(SQL Overall)	178691	83	6.186	28886.4