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

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

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

208 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
sugarers	9	3	630	(None)
sugarer	8	3	732	1	sugarer_
augurers	9	11	481	2	augurers
pugarees	11	19	549	2	pugarees
scarers	9	46	1851	2	s_carers
sharers	10	47	2062	2	s_harers
shearers	11	39	1132	2	shearers
smearers	10	30	862	2	smearers
snarers	7	42	1666	2	s_narers
soarers	7	41	1809	2	s_oarers
sparers	9	45	1961	2	s_parers
spearers	10	37	1114	2	spearers
squarers	17	33	802	2	squarers
starers	7	45	2231	2	s_tarers
subareas	10	3	862	2	subareas
sugared	9	3	858	2	sugare_d
sugarier	9	3	739	2	sugarier_
sugarless	10	4	367	2	sugarless
sugars	7	3	1242	2	suga__rs
swearers	11	32	858	2	swearers
augers	7	38	1870	3	aug__ers
augurer	8	13	634	3	augurer_
bearers	9	46	1959	3	_bearers
buggers	11	43	1566	3	bug_gers
buglers	10	51	1532	3	bug_lers
burrers	9	38	1449	3	bu_rrers
carers	8	51	3396	3	__carers
cigarets	11	4	547	3	cigarets
clearers	10	34	930	3	clearers
curares	9	49	1685	3	curare_s
curers	8	49	2319	3	cu__rers
darers	7	59	2187	3	__darers
dungarees	11	4	315	3	dungarees
engagers	10	24	655	3	engagers
farers	9	59	2405	3	__farers
fearers	10	48	1527	3	_fearers
figurers	12	25	487	3	figurers
fuehrers	14	4	261	3	fuehrers
fuhrers	13	3	481	3	fu_hrers
gagers	8	40	2133	3	__gagers
gamers	9	44	2083	3	__gamers
gapers	9	45	2047	3	__gapers
garners	8	38	1598	3	__garners
garters	8	42	1823	3	__garters
gaters	7	47	2864	3	__gaters
gazers	16	45	1630	3	__gazers
guarders	10	3	588	3	gu_arders
hearers	10	43	1978	3	_hearers
huggers	12	42	1159	3	hug_gers
jugglers	17	36	652	3	jugglers
lugers	7	46	1702	3	lug__ers
luggers	9	37	1348	3	lug_gers
lurers	6	42	1749	3	lu__rers
muggers	11	36	1193	3	mug_gers
negaters	9	34	978	3	negaters
parers	8	55	3074	3	__parers
pugaree	10	20	803	3	pugare_e
puggarees	13	17	304	3	puggarees
puggrees	12	19	426	3	puggrees
pugrees	10	21	852	3	pug_rees
quakers	20	30	969	3	qu_akers
quarters	17	31	1045	3	qu_arters
quavers	19	30	901	3	qu_avers
rearers	7	43	2356	3	_rearers
regalers	9	43	1113	3	regalers
roarers	7	38	1274	3	_roarers
ruggers	9	46	1231	3	rug_gers
sabers	8	52	2473	3	s__abers
saggers	9	40	1708	3	sag_gers
sakers	10	41	2543	3	s__akers
sangarees	10	4	654	3	sangarees
sarees	6	53	2994	3	s__arees
saugers	8	39	1405	3	saug__ers
savers	9	38	2592	3	s__avers
savorers	11	5	722	3	savorers
sawers	9	46	2016	3	s__awers
sayers	9	42	2159	3	s__ayers
scalers	9	38	1726	3	s_calers
scarer	8	45	2461	3	s_carer_
scares	8	50	3300	3	s_care_s
scarfers	13	40	846	3	s_carfers
scarpers	12	47	1251	3	s_carpers
scorers	9	41	1532	3	s_corers
scourers	10	34	853	3	scourers
scrapers	12	55	1053	3	scrapers
seafarers	12	4	414	3	seafarers
sealers	7	43	2355	3	s_ealers
seamers	9	47	1943	3	s_eamers
searer	6	54	3202	3	s_earer_
seaters	7	40	2894	3	s_eaters
securers	10	5	715	3	securers
shaders	11	59	1555	3	s_haders
shakers	14	40	1556	3	s_hakers
shapers	12	40	1689	3	s_hapers
sharer	9	50	2548	3	s_harer_
shares	9	52	3641	3	s_hare_s
sharkers	15	40	1105	3	s_harkers
sharpers	13	38	1094	3	s_harpers
shavers	13	41	1509	3	s_havers
shearer	10	44	1468	3	shearer_
sighers	11	37	1218	3	sig_hers
sighters	12	25	1060	3	sighters
signalers	10	4	458	3	signalers
signers	8	47	1444	3	sig_ners
skaters	11	35	1296	3	s_katers
slakers	11	41	1575	3	s_lakers
slaters	7	31	2373	3	s_laters
slavers	10	37	1650	3	s_lavers
slayers	10	45	1332	3	s_layers
slugabeds	13	9	114	3	slugabeds
sluggers	10	34	848	3	slug_gers
smearer	9	41	1040	3	smearer_
smugglers	13	26	343	3	smugglers
snarer	6	46	2084	3	s_narer_
snares	6	53	2903	3	s_nare_s
snarlers	8	29	875	3	s_narlers
sneakers	12	30	864	3	sneakers
sneerers	8	30	980	3	sneerers
snorers	7	43	1380	3	s_norers
soakers	11	41	1495	3	s_oakers
soapers	9	37	1592	3	s_oapers
soarer	6	45	2224	3	s_oarer_
socagers	11	9	636	3	socagers
solacers	10	26	889	3	solacers
spacers	11	38	1387	3	s_pacers
spaders	10	42	1447	3	s_paders
sparer	8	45	2496	3	s_parer_
spares	8	48	3455	3	s_pare_s
spargers	11	38	973	3	s_pargers
sparkers	14	41	1131	3	s_parkers
speakers	14	29	945	3	speakers
spearer	9	39	1366	3	spearer_
sprayers	13	36	705	3	sprayers
spurrers	10	33	846	3	spurrers
squarer	16	34	1066	3	squarer_
squares	16	37	1446	3	square_s
squeakers	22	8	411	3	squeakers
squealers	18	9	445	3	squealers
stagers	8	41	1667	3	s_tagers
staggers	10	37	984	3	staggers
starer	6	40	2736	3	s_tarer_
stares	6	60	3875	3	s_tare_s
starets	7	35	1592	3	s_tarets
starkers	12	37	1239	3	s_tarkers
starters	8	37	1477	3	s_tarters
starvers	11	45	964	3	s_tarvers
staters	7	39	2234	3	s_taters
stayers	10	38	1363	3	s_tayers
stealers	8	34	1221	3	stealers
steamers	10	34	1087	3	steamers
steerers	8	25	1135	3	steerers
stirrers	8	26	694	3	stirrers
storers	7	50	1868	3	s_torers
strafers	11	37	991	3	strafers
strayers	11	35	1014	3	strayers
suaver	9	30	1423	3	su_aver_
subadars	11	12	509	3	subadars
subarea	9	3	940	3	subare_a
subduers	11	8	636	3	subduers
subers	8	57	2264	3	su__bers
suborders	12	4	550	3	suborders
suborners	11	4	631	3	suborners
succorers	13	12	420	3	succorers
suckers	13	37	1762	3	su_ckers
sucklers	14	37	996	3	sucklers
sucres	8	42	1889	3	su_cre_s
sudaries	9	3	1275	3	sudaries
sudsers	8	33	1042	3	su_dsers
suers	5	51	2848	3	su___ers
sufferers	15	5	510	3	sufferers
suffers	13	31	1354	3	su_ffers
sugar	6	3	1291	3	suga__r_
sugarberry	16	5	136	3	sugarberry
sugarbush	15	5	158	3	sugarbush
sugariest	10	3	814	3	sugariest
sugaring	10	3	905	3	sugaring
sugary	10	3	901	3	suga__ry
suiters	7	36	1888	3	su_iters
sulkers	11	36	1334	3	su_lkers
summers	11	36	1650	3	su_mmers
sumpters	12	3	802	3	sumpters
sunderers	10	3	907	3	sunderers
sunders	8	41	2005	3	su_nders
sundress	9	3	698	3	sundress
supers	8	46	2240	3	su__pers
suppers	11	33	1470	3	su_ppers
suppress	12	3	644	3	suppress
surer	5	48	3310	3	su__rer_
surfacers	14	4	432	3	surfacers
surfers	10	36	1413	3	su_rfers
surgers	8	35	1748	3	su_rgers
surnamers	11	4	380	3	surnamers
surreys	10	48	944	3	su_rreys
sutlers	7	31	1697	3	su_tlers
sutures	7	3	1422	3	suture_s
swagers	11	42	1102	3	s_wagers
swaggers	13	40	722	3	swaggers
swarmers	13	4	632	3	s_warmers
swayers	13	39	885	3	s_wayers
swearer	10	34	995	3	swearer_
sweaters	11	38	1106	3	sweaters
tearers	7	52	1823	3	_tearers
tuggers	9	37	1144	3	tug_gers
urares	6	45	1909	3	_urare_s
usurers	7	6	636	3	_usurers
vulgarer	12	4	301	3	vulgarer_
wagerers	12	24	761	3	wagerers
wearers	10	46	1590	3	_wearers

Search took 7 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	146162	0.406	440125.6
2	DLD Change Limit	146162	208	6.406	22816.4
3	Display Results	208	208	0.076	2736.8
	(SQL Overall)	178691	208	6.888	25942.4