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

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

73 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
kidders	13	39	917	(None)
bidders	11	40	1231	1	bidders
kidder	12	38	1110	1	kidder_
ridders	9	36	1249	1	ridders
skidders	14	5	482	1	skidders
widders	12	35	1227	1	widders
adders	8	43	1570	2	_adders
aiders	7	45	2463	2	ai_ders
bedders	11	35	1338	2	bedders
bidder	10	41	1486	2	bidder_
biders	9	48	2280	2	bi_ders
binders	10	39	2074	2	binders
birders	10	39	1326	2	birders
budders	11	38	1210	2	budders
ciders	9	46	2009	2	ci_ders
cinders	10	46	1776	2	cinders
codders	11	41	1445	2	codders
diddlers	11	35	915	2	diddlers
dodders	10	55	1179	2	dodders
eiders	7	43	2136	2	ei_ders
fiddlers	13	32	828	2	fiddlers
finders	11	37	1787	2	finders
fodders	12	40	1075	2	fodders
gadders	10	36	1150	2	gadders
gilders	9	42	1246	2	gilders
girders	9	37	994	2	girders
gridders	11	28	629	2	gridders
hiders	10	49	1965	2	hi_ders
hinders	11	37	1850	2	hinders
idlers	7	40	1281	2	_idlers
judders	16	34	779	2	judders
kickers	12	40	1329	2	kickers
kidded	13	29	939	2	kidde_d
kiddies	13	34	1228	2	kiddies
kiddoes	13	38	706	2	kiddoes
kiddos	12	41	686	2	kidd_os
kidneys	15	3	342	2	kidneys
kiers	9	53	2009	2	ki__ers
killers	11	42	1558	2	killers
kilters	11	38	1360	2	kilters
kinder	11	37	1684	2	kinder_
kindlers	13	31	848	2	kindlers
kippers	15	32	1143	2	kippers
kissers	11	42	1129	2	kissers
kiters	10	52	1859	2	ki_ters
ladders	9	41	1517	2	ladders
madders	11	35	1321	2	madders
middens	11	37	938	2	middens
middlers	12	34	1019	2	middlers
minders	10	37	2012	2	minders
mudders	11	32	1111	2	mudders
nodders	9	44	1026	2	nodders
padders	11	33	1287	2	padders
piddlers	12	35	959	2	piddlers
pinders	10	37	2047	2	pinders
redders	9	36	1534	2	redders
ridder	8	40	1514	2	ridder_
riddlers	10	26	910	2	riddlers
riders	7	41	2390	2	ri_ders
rudders	9	32	1065	2	rudders
siddurs	9	3	417	2	siddurs
sidlers	8	34	1423	2	sidlers
skidder	13	6	573	2	skidder_
tedders	9	40	1023	2	tedders
tiddlers	10	28	865	2	tiddlers
tidiers	8	38	977	2	tidiers
tinders	8	42	1917	2	tinders
udders	8	39	1129	2	_udders
wadders	12	38	1244	2	wadders
wedders	12	36	1072	2	wedders
widder	11	29	1397	2	widder_
wilders	11	35	1350	2	wilders
winders	11	37	2126	2	winders

Search took 6 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.360	496363.9
2	DLD Change Limit	107671	73	5.563	19354.8
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	5.953	30017.0