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

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

171 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
sheers	9	43	2240	(None)
cheers	11	45	1891	1	cheers
seers	5	51	3638	1	s_eers
shears	9	38	2090	1	shears
sheens	9	51	1699	1	sheens
sheer	8	47	2689	1	sheer_
sheets	9	39	1850	1	sheets
shewers	13	43	1205	1	shewers
shiers	9	49	2175	1	shiers
shoers	9	45	1833	1	shoers
shyers	12	47	1220	1	shyers
sneers	6	40	1617	1	sneers
speers	8	50	1995	1	speers
steers	6	38	2098	1	steers
ameers	8	40	1557	2	ameers
ashlers	10	31	958	2	ashlers
beers	7	56	2839	2	_beers
cheders	13	45	1239	2	cheders
cheeks	15	47	1278	2	cheeks
cheeps	13	53	1291	2	cheeps
cheer	10	54	2038	2	cheer_
cheero	11	47	1294	2	cheero
cheeros	12	37	1164	2	cheeros
cheery	14	49	1315	2	cheery
chewers	15	41	1114	2	chewers
deers	6	49	3052	2	_deers
emeers	8	33	1418	2	emeers
fleers	9	60	1579	2	fleers
freers	9	47	1730	2	freers
ghees	9	52	1555	2	ghee_s
hears	8	67	3737	2	_hears
heders	10	41	1976	2	_heders
heeds	9	54	2042	2	_heeds
heels	8	56	2553	2	_heels
heirs	8	56	1856	2	_heirs
heres	8	62	4590	2	_heres
hers	7	58	4487	2	_h_ers
hewers	12	37	1527	2	_hewers
hexers	16	56	1275	2	_hexers
hoers	8	57	2492	2	_hoers
jeers	12	48	1813	2	_jeers
leers	5	48	2898	2	_leers
peers	7	51	3027	2	_peers
queers	15	35	1077	2	queers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
schemers	15	7	671	2	schemers
schmeers	15	7	483	2	schmeers
sears	5	47	4491	2	s_ears
seders	7	44	2028	2	seders
seeders	8	30	1711	2	seeders
seeds	6	43	3006	2	s_eeds
seekers	11	37	1233	2	seekers
seeks	9	47	2464	2	s_eeks
seels	5	56	3282	2	s_eels
seemers	9	38	1433	2	seemers
seems	7	55	2502	2	s_eems
seeps	7	48	2875	2	s_eeps
seer	4	55	4704	2	s_eer_
sees	4	53	6105	2	s_ee_s
seres	5	54	4889	2	s_eres
sers	4	57	4665	2	s__ers
severs	9	41	2112	2	severs
sewers	9	47	1972	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
sheafs	12	49	1288	2	sheafs
sheals	9	44	2064	2	sheals
shear	8	54	2483	2	shear_
shearers	11	39	1132	2	shearers
sheas	8	63	3179	2	sh_eas
shedders	13	26	743	2	shedders
sheds	9	61	2270	2	sh_eds
sheen	8	50	2331	2	shee_n
sheeny	12	49	1219	2	sheeny
sheep	10	53	2152	2	shee_p
sheered	11	35	1546	2	sheered
sheerer	10	38	1385	2	sheerer
sheerest	11	3	1008	2	sheerest
sheerly	13	33	770	2	sheerly
sheesh	12	3	781	2	sheesh
sheet	8	48	3696	2	shee_t
sheeters	11	31	1186	2	sheeters
sheeve	12	34	1284	2	sheeve
sheeves	13	39	1195	2	sheeves
sheiks	13	25	1001	2	sheiks
shekels	14	3	604	2	shekels
shellers	11	28	1258	2	shellers
shells	9	43	1952	2	shells
shelters	11	34	1281	2	shelters
shelvers	14	38	881	2	shelvers
shends	10	53	1377	2	shends
sheols	9	46	1416	2	sheols
sheqels	19	3	475	2	sheqels
sherd	9	63	2115	2	sh_erd
sherds	10	56	1472	2	sherds
sherris	10	16	880	2	sherris
sherry	12	45	1041	2	sherry
shes	7	57	3435	2	sh_e_s
shewer	12	45	1511	2	shewer_
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	2216	2	shoer_
shoes	8	54	2966	2	shoe_s
shores	9	48	3041	2	shores
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
shreds	10	56	1305	2	shreds
shrews	12	93	1392	2	shrews
shyer	11	47	1478	2	shyer_
sieurs	6	5	904	2	sieurs
sivers	9	53	2415	2	sivers
sizers	15	52	1581	2	sizers
skeens	10	39	1291	2	skeens
skees	9	50	2312	2	skee_s
skeets	10	45	1325	2	skeets
skewers	14	49	838	2	skewers
skiers	10	47	1370	2	skiers
sleeks	10	45	1246	2	sleeks
sleeps	8	39	1332	2	sleeps
sleets	6	43	1887	2	sleets
smears	8	47	1443	2	smears
smeeks	12	42	843	2	smeeks
sneer	5	49	1995	2	sneer_
sneery	9	36	1041	2	sneery
sobers	8	52	1886	2	sobers
sowers	9	49	2344	2	sowers
spears	8	40	1947	2	spears
speeds	9	43	1605	2	speeds
speels	8	51	1639	2	speels
speer	7	46	2390	2	speer_
speirs	8	50	1323	2	speirs
spewers	12	42	1066	2	spewers
spheres	12	31	1435	2	spheres
spiers	8	44	2174	2	spiers
steeds	7	38	1488	2	steeds
steeks	10	36	1370	2	steeks
steels	6	41	1798	2	steels
steeps	8	52	1519	2	steeps
steer	5	54	2386	2	steer_
steres	6	39	2953	2	steres
subers	8	57	2264	2	subers
suers	5	51	2848	2	s_uers
supers	8	46	2240	2	supers
swears	9	41	1407	2	swears
sweeps	11	41	1051	2	sweeps
sweer	8	49	1857	2	sweer_
sweets	9	42	1443	2	sweets
theirs	9	46	1035	2	theirs
theres	9	65	2547	2	theres
ushers	9	44	1553	2	ush_ers
veers	8	45	2136	2	_veers
wheels	12	38	1172	2	wheels
wheens	12	46	1061	2	wheens
wheeps	14	43	995	2	wheeps
wheres	12	59	1744	2	wheres

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.376	475242.0
2	DLD Change Limit	82551	171	2.233	36968.7
3	Display Results	171	171	0.063	2714.3
	(SQL Overall)	178691	171	2.672	66875.4