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

Here are the results of your fuzzy-string dictionary search for “waders” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

222 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
waders	10	91	2064	(None)
faders	10	51	1746	1	faders
laders	7	49	2776	1	laders
wadders	12	38	1244	1	wadders
wader	9	53	2536	1	wader_
wades	9	56	3414	1	wade_s
wafers	12	43	1614	1	wafers
wagers	10	51	2220	1	wagers
wakers	13	48	2249	1	wakers
walers	9	48	2446	1	walers
wanders	11	42	2133	1	wanders
warders	11	34	1681	1	warders
waters	9	50	3062	1	waters
wavers	12	50	2247	1	wavers
waxers	16	40	1430	1	waxers
adders	8	43	1570	2	adders
agers	6	50	2785	2	_agers
aiders	7	45	2463	2	aiders
alders	7	42	1842	2	alders
apers	7	66	2913	2	_apers
avers	8	51	2731	2	_avers
awarders	12	4	507	2	awarders
badgers	11	48	1264	2	badgers
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
banders	10	43	2456	2	banders
beaders	10	41	2018	2	beaders
biders	9	48	2280	2	biders
bladers	10	42	1468	2	bladers
cabers	10	50	2390	2	cabers
cades	8	54	4073	2	cade_s
cadets	9	63	1650	2	cadets
cadgers	11	47	1199	2	cadgers
cadres	9	40	1792	2	cadres
cagers	9	56	2418	2	cagers
caners	8	46	2919	2	caners
capers	10	54	2813	2	capers
carders	10	48	2035	2	carders
carers	8	51	3395	2	carers
caters	8	53	3649	2	caters
cavers	11	50	2683	2	cavers
ceders	9	38	1767	2	ceders
ciders	9	46	2008	2	ciders
coders	9	54	2697	2	coders
cyders	12	39	883	2	cyders
danders	9	39	2118	2	danders
darers	7	59	2187	2	darers
daters	7	48	2736	2	daters
eagers	7	45	2368	2	eagers
eaters	6	55	3594	2	eaters
eiders	7	43	2136	2	eiders
elders	7	48	1730	2	elders
enders	7	43	2405	2	enders
evaders	11	3	693	2	evaders
facers	11	55	1944	2	facers
fader	9	44	2151	2	fader_
fades	9	49	3286	2	fade_s
fakers	13	42	1953	2	fakers
farers	9	59	2405	2	farers
gadders	10	36	1150	2	gadders
gagers	8	40	2132	2	gagers
gamers	9	44	2082	2	gamers
ganders	9	35	2170	2	ganders
gapers	9	45	2046	2	gapers
gaters	7	47	2863	2	gaters
gazers	16	45	1629	2	gazers
graders	9	47	1599	2	graders
hades	9	60	3511	2	hade_s
halers	9	49	2691	2	halers
handers	11	42	2433	2	handers
haters	9	49	3039	2	haters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
headers	11	38	1939	2	headers
heders	10	41	1976	2	heders
hiders	10	49	1965	2	hiders
jades	13	52	2211	2	jade_s
jagers	14	44	1572	2	jagers
japers	15	46	1617	2	japers
lacers	8	52	2525	2	lacers
ladders	9	41	1517	2	ladders
ladens	7	45	1623	2	ladens
lader	6	56	3372	2	lader_
lades	6	51	4127	2	lade_s
ladlers	8	46	1356	2	ladlers
lagers	7	48	2614	2	lagers
lakers	10	52	2515	2	lakers
landers	8	40	2621	2	landers
larders	8	35	1694	2	larders
lasers	6	49	2570	2	lasers
lauders	8	40	1289	2	lauders
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
leaders	8	38	1960	2	leaders
loaders	8	34	1341	2	loaders
macers	10	53	2127	2	macers
madders	11	35	1321	2	madders
madres	9	37	1818	2	madres
makers	12	39	2173	2	makers
masers	8	46	2345	2	masers
maters	8	50	3238	2	maters
mazers	17	39	1709	2	mazers
nadirs	7	10	900	2	nadirs
namers	8	45	1733	2	namers
oaters	6	50	2978	2	oaters
orders	7	43	1599	2	orders
pacers	10	51	2454	2	pacers
padders	11	33	1287	2	padders
padres	9	50	1698	2	padres
pagers	9	44	2325	2	pagers
panders	10	34	2373	2	panders
papers	10	51	2532	2	papers
parers	8	55	3074	2	parers
paters	8	49	3582	2	paters
pavers	11	50	2182	2	pavers
pawers	11	48	1878	2	pawers
payers	11	46	2182	2	payers
racers	8	47	2543	2	racers
radars	7	13	1466	2	radars
raiders	8	46	1514	2	raiders
rakers	10	41	2357	2	rakers
rapers	8	43	2718	2	rapers
rasers	6	45	2678	2	rasers
raters	6	39	3657	2	raters
ravers	9	46	2818	2	ravers
razers	15	49	1961	2	razers
readers	8	38	2376	2	readers
riders	7	41	2390	2	riders
sabers	8	52	2473	2	sabers
sades	6	52	3989	2	sade_s
sakers	10	41	2543	2	sakers
sanders	8	40	2594	2	sanders
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
seders	7	44	2028	2	seders
shaders	11	59	1555	2	shaders
spaders	10	42	1447	2	spaders
swagers	11	42	1102	2	swagers
swayers	13	39	885	2	swayers
tabers	8	46	2157	2	tabers
takers	10	39	2374	2	takers
talers	6	46	2814	2	talers
tamers	8	42	2403	2	tamers
tapers	8	40	2581	2	tapers
taters	6	49	3219	2	taters
tawers	9	41	1860	2	tawers
taxers	13	40	1528	2	taxers
traders	8	43	1694	2	traders
udders	8	39	1129	2	udders
wadder	11	42	1548	2	wadder_
waddlers	13	29	833	2	waddlers
wade	8	52	3706	2	wade__
waded	10	60	2475	2	wade_d
wadies	10	51	2120	2	wadies
wadis	9	52	2396	2	wad_is
wadmels	13	3	430	2	wadmels
wads	8	73	4314	2	wad__s
wadsets	11	3	644	2	wadsets
waes	7	60	4860	2	wa_e_s
wafer	11	44	1764	2	wafer_
wafery	15	39	869	2	wafery
wafters	13	41	1281	2	wafters
wager	9	59	2505	2	wager_
wages	9	53	3093	2	wage_s
waggers	12	46	1308	2	waggers
wailers	10	39	1680	2	wailers
wairs	8	64	2406	2	wa_irs
waiters	10	42	1862	2	waiters
waivers	13	34	1005	2	waivers
wakens	13	50	1204	2	wakens
waker	12	55	2659	2	waker_
wakes	12	66	3365	2	wake_s
waler	8	42	2926	2	waler_
wales	8	61	4283	2	wale_s
walkers	14	34	1147	2	walkers
wames	10	64	3280	2	wame_s
wander	10	44	2371	2	wander_
wanes	8	50	4088	2	wane_s
wankers	14	45	1471	2	wankers
wanters	10	44	2009	2	wanters
wardens	11	37	1190	2	wardens
warder	10	40	2027	2	warder_
wares	8	82	5058	2	ware_s
warmers	12	45	1429	2	warmers
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
wars	7	86	5980	2	wa__rs
washers	13	45	1752	2	washers
wasters	10	40	2659	2	wasters
water	8	47	3331	2	water_
watery	12	39	1449	2	watery
waver	11	50	2570	2	waver_
wavery	15	46	1005	2	wavery
waves	11	56	3392	2	wave_s
waveys	15	59	701	2	waveys
waxer	15	43	1748	2	waxer_
waxes	15	58	2550	2	waxe_s
weaners	10	46	1383	2	weaners
wearers	10	46	1590	2	wearers
weavers	13	37	1446	2	weavers
webers	11	3	1094	2	webers
wedders	12	36	1072	2	wedders
wedels	10	38	1103	2	wedels
weeders	11	34	1293	2	weeders
welders	11	33	1341	2	welders
whalers	13	52	970	2	whalers
widders	12	35	1226	2	widders
widens	10	62	1272	2	widens
wider	9	48	2635	2	wider_
wides	9	48	3282	2	wide_s
wilders	11	35	1350	2	wilders
winders	11	37	2126	2	winders
wipers	11	54	1608	2	wipers
wirers	9	46	1789	2	wirers
wivers	12	53	2080	2	wivers
wonders	11	33	1599	2	wonders
wooers	9	37	1244	2	wooers
yagers	10	51	1453	2	yagers
yarders	11	32	1159	2	yarders
zanders	17	30	1579	2	zanders

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.126	1418182.5
2	DLD Change Limit	82551	222	2.593	31836.1
3	Display Results	222	222	0.063	3523.8
	(SQL Overall)	178691	222	2.782	64231.1