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

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

97 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
shyers	12	47	1220	(None)
sayers	9	42	2159	1	sayers
sheers	9	43	2240	1	sheers
shiers	9	49	2175	1	shiers
shoers	9	45	1832	1	shoers
shyer	11	47	1478	1	shyer_
ashlers	10	31	958	2	ashlers
buyers	11	45	1100	2	buyers
cheers	11	45	1891	2	cheers
dryers	10	44	927	2	dryers
dyers	9	66	1713	2	_dyers
eyers	8	65	2133	2	_eyers
flyers	12	57	1280	2	flyers
foyers	12	54	1313	2	foyers
fryers	12	57	1097	2	fryers
hayers	12	44	1594	2	hayers
hers	7	58	4487	2	_h_ers
hoers	8	57	2492	2	_hoers
hypers	14	48	1191	2	_hypers
layers	9	39	2118	2	layers
oyers	8	76	2088	2	_oyers
payers	11	46	2182	2	payers
plyers	11	49	1298	2	plyers
pryers	11	50	1224	2	pryers
rhymers	15	36	554	2	rhymers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sawyers	13	31	753	2	sawyers
sayeds	10	46	925	2	sayeds
sayer	8	49	2655	2	sayer_
seders	7	44	2028	2	seders
seers	5	51	3638	2	s_eers
sers	4	57	4665	2	s__ers
severs	9	41	2112	2	severs
sewers	9	47	1971	2	sewers
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shares	9	52	3641	2	shares
shavers	13	41	1509	2	shavers
shears	9	38	2090	2	shears
sheas	8	63	3179	2	sh_eas
sheds	9	61	2270	2	sh_eds
sheens	9	51	1699	2	sheens
sheer	8	47	2689	2	sheer_
sheets	9	39	1849	2	sheets
sherd	9	63	2115	2	sh_erd
sherds	10	56	1472	2	sh_erds
shes	7	57	3435	2	sh_e_s
shewers	13	43	1204	2	shewers
shews	11	59	2471	2	sh_ews
shiels	9	54	1892	2	shiels
shier	8	54	2894	2	shier_
shies	8	61	3655	2	shie_s
shiners	10	40	1594	2	shiners
shires	9	52	2557	2	shires
shirrs	9	44	1317	2	shirrs
shivers	13	37	1483	2	shivers
shleps	11	47	1033	2	shleps
shmears	12	7	707	2	shmears
shoer	8	47	2215	2	shoer_
shoes	8	54	2965	2	shoe_s
shores	9	48	3040	2	shores
shovers	13	46	1299	2	shovers
showers	13	46	1266	2	showers
shreds	10	56	1305	2	shreds
shrews	12	93	1391	2	shrews
shyest	12	55	1183	2	shyest
shyness	13	4	499	2	shyness
shysters	14	10	643	2	shysters
sivers	9	53	2415	2	sivers
sizers	15	52	1581	2	sizers
skiers	10	47	1369	2	skiers
slayers	10	45	1332	2	slayers
slyer	8	55	1512	2	slyer_
sneers	6	40	1617	2	sneers
snyes	8	50	1275	2	snye_s
sobers	8	52	1885	2	sobers
sowers	9	49	2343	2	sowers
speers	8	50	1995	2	speers
spiers	8	44	2174	2	spiers
stayers	10	38	1363	2	stayers
steers	6	38	2098	2	steers
styes	8	63	1652	2	stye_s
stylers	10	35	934	2	stylers
subers	8	57	2264	2	subers
suers	5	51	2848	2	s_uers
supers	8	46	2240	2	supers
swayers	13	39	885	2	swayers
toyers	9	55	1633	2	toyers
tuyers	9	46	1256	2	tuyers
twyers	12	49	741	2	twyers
tyers	8	62	2005	2	_tyers
ushers	9	44	1553	2	ush_ers

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	97	4.766	17320.8
3	Display Results	97	97	0.076	1276.3
	(SQL Overall)	178691	97	4.968	35968.4