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

Here are the results of your fuzzy-string dictionary search for “waddies” 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
waddies	12	42	1475	(None)
baddies	11	40	1787	1	baddies
caddies	11	37	1838	1	caddies
daddies	10	34	1494	1	daddies
laddies	9	37	1505	1	laddies
paddies	11	37	1572	1	paddies
waddie	11	40	1332	1	waddie_
waddied	13	35	856	1	waddied
waddles	12	43	1484	1	waddles
wadies	10	51	2120	1	wa_dies
widdies	12	35	1403	1	widdies
addles	8	42	1660	2	_addles
baddie	10	41	1403	2	baddie_
baldies	10	53	1770	2	baldies
bandies	10	41	2486	2	bandies
bawdies	13	46	1339	2	bawdies
biddies	11	35	1449	2	biddies
buddies	11	39	1435	2	buddies
caddices	14	29	785	2	caddices
caddie	10	43	1645	2	caddie_
caddied	12	37	1056	2	caddied
caddis	10	46	1338	2	caddi_s
caddises	12	32	935	2	caddises
candies	10	41	2561	2	candies
cuddies	11	33	1326	2	cuddies
daddles	10	42	1380	2	daddles
dandies	9	41	2144	2	dandies
eddies	8	33	1316	2	_eddies
faddier	12	3	778	2	faddier
faddiest	13	3	811	2	faddiest
fuddies	12	32	1120	2	fuddies
gaddis	9	42	1137	2	gaddi_s
gaudies	9	3	1197	2	gaudies
giddies	10	37	1336	2	giddies
hardies	11	49	2323	2	hardies
kiddies	13	34	1228	2	kiddies
laddie	8	37	1317	2	laddie_
ladies	7	51	2488	2	la_dies
middies	11	31	1615	2	middies
muddies	11	35	1395	2	muddies
neddies	9	27	1070	2	neddies
noddies	9	35	1204	2	noddies
paddles	11	35	1564	2	paddles
pandies	10	42	2450	2	pandies
raddles	9	36	1570	2	raddles
randies	8	42	2566	2	randies
saddles	9	54	1574	2	saddles
soddies	9	23	1285	2	soddies
swaddles	13	29	645	2	swaddles
tardies	8	42	2586	2	tardies
teddies	9	27	1128	2	teddies
toddies	9	30	1199	2	toddies
twaddles	13	31	572	2	twaddles
wadded	12	40	1417	2	wadd_ed
wadder	11	42	1548	2	wadd_er
wadders	12	38	1244	2	wadders
wadding	13	37	1194	2	wadding
waddings	14	35	647	2	waddings
waddle	11	47	1530	2	waddle_
waddled	13	36	1164	2	waddled
waddler	12	40	1079	2	waddler
waddlers	13	29	833	2	waddlers
wades	9	56	3414	2	wa_d_es
wadis	9	52	2396	2	wa_di_s
waffies	16	36	1144	2	waffies
walies	9	53	2452	2	wa_lies
wallies	10	33	2074	2	wallies
wavies	12	50	1984	2	wa_vies
wedgies	12	39	1021	2	wedgies
widdie	11	34	1073	2	widdie_
widdles	12	35	1434	2	widdles
woodies	11	35	1715	2	woodies

Search took 10 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	1.216	146949.8
2	DLD Change Limit	107671	72	8.253	13046.3
3	Display Results	72	72	0.013	5538.5
	(SQL Overall)	178691	72	9.482	18845.3