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

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

72 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
puddle	10	39	1415	(None)
buddle	10	43	1308	1	buddle
cuddle	10	44	1453	1	cuddle
fuddle	11	33	1210	1	fuddle
huddle	11	37	1299	1	huddle
muddle	10	34	1463	1	muddle
paddle	10	46	1514	1	paddle
peddle	10	35	1282	1	peddle
piddle	10	35	1491	1	piddle
puddled	12	30	1119	1	puddled
puddler	11	29	1075	1	puddler
puddles	11	36	1382	1	puddles
puddly	13	43	813	1	puddly
ruddle	8	34	1420	1	ruddle
addle	7	43	1835	2	_addle
audile	7	33	1530	2	audile
buddles	11	39	1307	2	buddles
bundle	9	43	1557	2	bundle
coddle	10	47	1385	2	coddle
cuddie	10	40	1117	2	cuddie
cuddled	12	41	1076	2	cuddled
cuddler	11	38	1074	2	cuddler
cuddles	11	40	1409	2	cuddles
cuddly	13	38	841	2	cuddly
curdle	9	55	1431	2	curdle
daddle	9	42	1428	2	daddle
diddle	9	49	1521	2	diddle
duddie	9	34	886	2	duddie
fiddle	11	36	1338	2	fiddle
fuddled	13	30	939	2	fuddled
fuddles	12	36	1193	2	fuddles
heddle	11	42	1116	2	heddle
huddled	13	34	978	2	huddled
huddler	12	37	942	2	huddler
huddles	12	37	1257	2	huddles
hurdle	10	37	1279	2	hurdle
meddle	10	33	1276	2	meddle
middle	10	34	1498	2	middle
muddled	12	41	1159	2	muddled
muddler	11	34	1162	2	muddler
muddles	11	29	1435	2	muddles
muddly	13	41	860	2	muddly
noddle	8	32	1136	2	noddle
paddled	12	36	1202	2	paddled
paddler	11	37	1155	2	paddler
paddles	11	35	1564	2	paddles
padle	8	45	2234	2	p_adle
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
puddlers	12	29	868	2	puddlers
puddlier	12	3	421	2	puddlier
pule	6	50	4095	2	pu__le
pungle	9	44	1357	2	pungle
purfle	11	25	1118	2	purfle
purple	10	27	1268	2	purple
puzzle	16	31	860	2	puzzle
raddle	8	48	1617	2	raddle
reddle	8	38	1591	2	reddle
riddle	8	39	1571	2	riddle
ruddled	10	30	1087	2	ruddled
ruddles	9	28	1387	2	ruddles
rundle	7	32	1423	2	rundle
saddle	8	39	1549	2	saddle
toddle	8	58	1103	2	toddle
waddle	11	47	1530	2	waddle
widdle	11	38	1484	2	widdle

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	72	2.360	34979.2
3	Display Results	72	72	0.013	5538.5
	(SQL Overall)	178691	72	2.716	65792.0