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

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

138 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
sharers	10	47	2062	(None)
scarers	9	46	1851	1	scarers
shaders	11	59	1555	1	shaders
shakers	14	40	1556	1	shakers
shapers	12	40	1689	1	shapers
sharer	9	50	2548	1	sharer_
shares	9	52	3641	1	share_s
sharkers	15	40	1105	1	sharkers
sharpers	13	38	1094	1	sharpers
shavers	13	41	1509	1	shavers
shearers	11	39	1132	1	shearers
snarers	7	42	1666	1	snarers
soarers	7	41	1809	1	soarers
sparers	9	45	1961	1	sparers
starers	7	45	2231	1	starers
bearers	9	46	1959	2	bearers
carers	8	51	3396	2	_carers
chafers	15	45	1274	2	chafers
chares	11	56	3180	2	chare_s
chargers	14	40	1132	2	chargers
charmers	15	42	1133	2	charmers
charrs	11	52	1919	2	char_rs
charters	13	41	1558	2	charters
chasers	12	37	1492	2	chasers
chawers	15	44	1205	2	chawers
darers	7	59	2187	2	_darers
farers	9	59	2405	2	_farers
fearers	10	48	1527	2	fearers
halers	9	49	2691	2	_halers
harems	11	55	1382	2	_harems
hares	8	62	5554	2	_hare_s
harmers	12	41	1659	2	_harmers
harpers	12	49	1620	2	_harpers
haters	9	49	3040	2	_haters
havers	12	47	2148	2	_havers
hayers	12	44	1594	2	_hayers
hazers	18	46	1595	2	_hazers
hearers	10	43	1978	2	hearers
hirers	9	45	1806	2	_hirers
parers	8	55	3074	2	_parers
rearers	7	43	2356	2	rearers
roarers	7	38	1274	2	roarers
sabers	8	52	2473	2	s_abers
sakers	10	41	2543	2	s_akers
sarees	6	53	2994	2	s_arees
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
scarer	8	45	2461	2	scarer_
scares	8	50	3300	2	scare_s
scarfers	13	40	846	2	scarfers
scarpers	12	47	1251	2	scarpers
scorers	9	41	1532	2	scorers
sealers	7	43	2355	2	sealers
seamers	9	47	1943	2	seamers
searer	6	54	3202	2	searer_
seaters	7	40	2894	2	seaters
shader	10	42	1876	2	shader_
shades	10	59	2453	2	shade_s
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	2495	2	shape_s
shards	10	43	1917	2	shar_ds
share	8	64	3708	2	share__
shared	10	58	2906	2	share_d
sharias	10	25	1600	2	sharias
sharifs	13	27	990	2	sharifs
sharker	14	43	1381	2	sharker_
sharks	13	50	1972	2	shar_ks
sharns	9	55	1698	2	shar_ns
sharpens	13	37	781	2	sharpens
sharper	12	43	1270	2	sharper_
sharps	11	55	1608	2	shar_ps
shatters	11	33	1391	2	shatters
shaver	12	37	1891	2	shaver_
shaves	12	52	2493	2	shave_s
shearer	10	44	1468	2	shearer_
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
shires	9	52	2557	2	shire_s
shirkers	15	31	958	2	shirkers
shirrs	9	44	1317	2	shir_rs
shivers	13	37	1483	2	shivers
shoers	9	45	1833	2	sh_oers
shores	9	48	3041	2	shore_s
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
shreds	10	56	1305	2	sh_reds
shrews	12	93	1392	2	sh_rews
shyers	12	47	1220	2	sh_yers
skaters	11	35	1296	2	skaters
slakers	11	41	1575	2	slakers
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayers	10	45	1332	2	slayers
smearers	10	30	862	2	smearers
snarer	6	46	2084	2	snarer_
snares	6	53	2903	2	snare_s
snarlers	8	29	875	2	snarlers
snorers	7	43	1380	2	snorers
soakers	11	41	1495	2	soakers
soapers	9	37	1592	2	soapers
soarer	6	45	2224	2	soarer_
spacers	11	38	1387	2	spacers
spaders	10	42	1447	2	spaders
sparer	8	45	2496	2	sparer_
spares	8	48	3455	2	spare_s
spargers	11	38	973	2	spargers
sparkers	14	41	1131	2	sparkers
spearers	10	37	1114	2	spearers
squarers	17	33	802	2	squarers
stagers	8	41	1667	2	stagers
starer	6	40	2736	2	starer_
stares	6	60	3875	2	stare_s
starets	7	35	1592	2	starets
starkers	12	37	1239	2	starkers
starters	8	37	1477	2	starters
starvers	11	45	964	2	starvers
staters	7	39	2234	2	staters
stayers	10	38	1363	2	stayers
storers	7	50	1868	2	storers
sugarers	9	3	630	2	sugarers
swagers	11	42	1102	2	swagers
swarmers	13	4	632	2	swarmers
swayers	13	39	885	2	swayers
swearers	11	32	858	2	swearers
tearers	7	52	1823	2	tearers
thalers	10	62	1226	2	thalers
thawers	13	42	848	2	thawers
wearers	10	46	1590	2	wearers
whalers	13	52	970	2	whalers

Search took 5 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.423	422437.4
2	DLD Change Limit	107671	138	3.826	28141.9
3	Display Results	138	138	0.050	2760.0
	(SQL Overall)	178691	138	4.299	41565.7