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

Here are the results of your fuzzy-string dictionary search for “ruddle” 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
ruddle	8	34	1420	(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
puddle	10	39	1415	1	puddle
raddle	8	48	1617	1	raddle
reddle	8	38	1591	1	reddle
riddle	8	39	1571	1	riddle
ruddled	10	30	1087	1	ruddled
ruddles	9	28	1387	1	ruddles
rundle	7	32	1423	1	rundle
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
griddle	10	3	550	2	griddle
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
paddle	10	46	1514	2	paddle
peddle	10	35	1282	2	peddle
piddle	10	35	1491	2	piddle
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
reddled	10	29	1232	2	reddled
reddles	9	33	1577	2	reddles
riddled	10	30	1204	2	riddled
riddler	9	34	1126	2	riddler
riddles	9	32	1502	2	riddles
rubble	10	43	1567	2	rubble
ruble	7	45	2125	2	ru_ble
ruckle	12	44	1458	2	ruckle
rudd	6	59	1747	2	rudd__
rudder	8	38	1280	2	rudder
ruddier	9	33	852	2	ruddier
ruddily	12	3	630	2	ruddily
rudds	7	48	1170	2	rudd_s
ruddy	10	45	1175	2	rudd_y
rude	5	56	3278	2	ru_d_e
rudely	10	38	997	2	rudely
ruffle	12	41	1167	2	ruffle
rule	4	99	3842	2	ru__le
rumble	10	37	1881	2	rumble
rumple	10	39	1301	2	rumple
rundles	8	32	1471	2	rundles
rundlet	8	31	1415	2	rundlet
runkle	10	36	1154	2	runkle
rustle	6	36	1541	2	rustle
rutile	6	52	1768	2	rutile
saddle	8	39	1549	2	saddle
toddle	8	58	1103	2	toddle
treddle	9	3	643	2	treddle
trundle	8	30	787	2	trundle
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	83	2.500	33020.4
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	2.876	62131.8