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

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

75 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
daddies	10	34	1494	(None)
baddies	11	40	1787	1	baddies
caddies	11	37	1838	1	caddies
daddles	10	42	1380	1	daddles
dandies	9	41	2144	1	dandies
laddies	9	37	1505	1	laddies
paddies	11	37	1572	1	paddies
waddies	12	42	1475	1	waddies
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
daddle	9	42	1428	2	daddle_
daddled	11	38	1074	2	daddled
dadoes	8	56	1653	2	da_does
dailies	8	42	1926	2	dailies
dairies	8	42	1773	2	dairies
daisies	8	42	1709	2	daisies
dallies	8	40	2319	2	dallies
dandier	9	37	1457	2	dandier
dandiest	10	34	1503	2	dandiest
dandles	9	42	1853	2	dandles
darbies	10	42	1698	2	darbies
darkies	12	40	1575	2	darkies
dassies	8	44	1866	2	dassies
dauties	8	33	1576	2	dauties
davies	10	50	2051	2	da_vies
dawdles	12	37	916	2	dawdles
dawties	11	33	1270	2	dawties
diddles	10	39	1507	2	diddles
diddlies	11	3	759	2	diddlies
didies	8	46	2183	2	d_idies
doodies	9	42	1877	2	doodies
dowdies	12	34	1273	2	dowdies
duddie	9	34	886	2	duddie_
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
hodaddies	15	4	226	2	hodaddies
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
tardies	8	42	2586	2	tardies
teddies	9	27	1128	2	teddies
toddies	9	30	1199	2	toddies
waddie	11	40	1332	2	waddie_
waddied	13	35	856	2	waddied
waddles	12	43	1484	2	waddles
wadies	10	51	2120	2	wa_dies
widdies	12	35	1403	2	widdies

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.123	1452772.4
2	DLD Change Limit	107671	75	3.250	33129.5
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	3.406	52463.6