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

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

114 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
shaders	11	59	1555	(None)
shader	10	42	1876	1	shader_
shades	10	59	2453	1	shade_s
shakers	14	40	1556	1	shakers
shapers	12	40	1689	1	shapers
sharers	10	47	2062	1	sharers
shavers	13	41	1509	1	shavers
spaders	10	42	1447	1	spaders
beaders	10	41	2018	2	beaders
bladers	10	42	1468	2	bladers
chadars	13	3	829	2	chadars
chadors	13	3	875	2	chadors
chafers	15	45	1274	2	chafers
chasers	12	37	1492	2	chasers
chawers	15	44	1205	2	chawers
cheders	13	45	1239	2	cheders
chiders	13	53	1294	2	chiders
evaders	11	3	693	2	evaders
faders	10	51	1746	2	_faders
graders	9	47	1601	2	graders
hades	9	60	3511	2	_hade_s
halers	9	49	2691	2	_halers
handers	11	42	2433	2	_handers
haters	9	49	3040	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
laders	7	49	2776	2	_laders
leaders	8	38	1960	2	leaders
loaders	8	34	1343	2	loaders
readers	8	38	2377	2	readers
sabers	8	52	2473	2	s_abers
sades	6	52	3989	2	s_ade_s
sakers	10	41	2543	2	s_akers
sanders	8	40	2594	2	sanders
savers	9	38	2592	2	s_avers
sawers	9	46	2016	2	s_awers
sayers	9	42	2159	2	s_ayers
scalers	9	38	1726	2	scalers
scarers	9	46	1851	2	scarers
sealers	7	43	2355	2	sealers
seamers	9	47	1943	2	seamers
seaters	7	40	2894	2	seaters
seders	7	44	2028	2	s_eders
seeders	8	30	1711	2	seeders
senders	8	30	2235	2	senders
shade	9	51	2558	2	shade__
shaded	11	45	1887	2	shade_d
shadier	11	31	1115	2	shadier_
shadowers	16	4	430	2	shadowers
shadows	14	3	719	2	shadows
shads	9	51	2448	2	shad__s
shadufs	14	3	367	2	shadufs
shaker	13	43	1946	2	shaker_
shakes	13	50	2459	2	shake_s
shales	9	47	3125	2	shale_s
shames	11	47	2622	2	shame_s
shammers	15	37	1084	2	shammers
shaper	11	41	1993	2	shaper_
shapes	11	51	2494	2	shape_s
sharer	9	50	2548	2	sharer_
shares	9	52	3641	2	share_s
sharkers	15	40	1105	2	sharkers
sharpers	13	38	1094	2	sharpers
shatters	11	33	1391	2	shatters
shaver	12	37	1891	2	shaver_
shaves	12	52	2493	2	shave_s
shearers	11	39	1132	2	shearers
shedders	13	26	743	2	shedders
sheers	9	43	2240	2	sh_eers
shewers	13	43	1205	2	shewers
shiers	9	49	2175	2	sh_iers
shiners	10	40	1594	2	shiners
shivers	13	37	1483	2	shivers
shoers	9	45	1833	2	sh_oers
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
shudders	13	31	664	2	shudders
shyers	12	47	1220	2	sh_yers
skaters	11	35	1296	2	skaters
slakers	11	41	1575	2	slakers
slanders	9	40	1401	2	slanders
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayers	10	45	1332	2	slayers
sliders	8	35	1522	2	sliders
snarers	7	42	1666	2	snarers
soakers	11	41	1495	2	soakers
soapers	9	37	1592	2	soapers
soarers	7	41	1809	2	soarers
solders	8	35	1777	2	solders
sonders	8	38	2071	2	sonders
spacers	11	38	1387	2	spacers
spader	9	43	1713	2	spader_
spades	9	42	2258	2	spade_s
sparers	9	45	1961	2	sparers
spiders	10	39	1441	2	spiders
stades	7	46	2624	2	stade_s
stagers	8	41	1667	2	stagers
standers	9	35	1430	2	standers
starers	7	45	2231	2	starers
staters	7	39	2234	2	staters
stayers	10	38	1363	2	stayers
sunders	8	41	2005	2	sunders
swagers	11	42	1102	2	swagers
swayers	13	39	885	2	swayers
thalers	10	62	1226	2	thalers
thawers	13	42	848	2	thawers
traders	8	43	1695	2	traders
waders	10	91	2064	2	_waders
whalers	13	52	970	2	whalers

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.373	479064.3
2	DLD Change Limit	107671	114	3.300	32627.6
3	Display Results	114	114	0.030	3800.0
	(SQL Overall)	178691	114	3.703	48255.7