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

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

385 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
beanery	12	3	756	(None)
deanery	11	3	761	1	deanery
bakery	15	59	1100	2	b_akery
beader	9	46	2379	2	beader_
beaders	10	41	2018	2	beaders
beaker	12	55	2069	2	beaker_
beakers	13	42	1687	2	beakers
beaned	9	56	2147	2	beane_d
bearer	8	53	2391	2	bearer_
bearers	9	46	1959	2	bearers
beater	8	47	2939	2	beater_
beaters	9	49	2504	2	beaters
beaver	11	48	1925	2	beaver_
beavers	12	44	1732	2	beavers
beery	10	52	2012	2	be__ery
bravery	15	42	813	2	bravery
eatery	9	53	1635	2	_eatery
fernery	13	3	581	2	fernery
hennery	13	3	530	2	hennery
leaner	6	40	2219	2	leaner_
leaners	7	37	1817	2	leaners
meaner	8	46	1784	2	meaner_
meaners	9	44	1524	2	meaners
sealery	10	40	1105	2	sealery
venery	12	37	1066	2	ve_nery
weaner	9	38	1677	2	weaner_
weaners	10	46	1383	2	weaners
aery	7	72	3168	3	__a_ery
anergy	10	15	686	3	__anergy
angry	9	3	1086	3	__angry
apery	10	65	1790	3	__apery
baker	11	56	2954	3	b_aker_
bakers	12	53	2345	3	b_akers
baler	7	56	3527	3	b_aler_
balers	8	56	2693	3	b_alers
bander	9	39	2822	3	b_ander_
banders	10	43	2456	3	b_anders
bandy	11	48	2418	3	b_an_dy
bane	6	52	5043	3	b_ane__
baned	8	54	3635	3	b_ane_d
banes	7	49	4558	3	b_ane_s
banger	9	44	2363	3	b_anger_
bangers	10	40	2035	3	b_angers
banker	12	42	2273	3	b_anker_
bankerly	17	4	433	3	b_ankerly
bankers	13	39	1909	3	b_ankers
banner	8	44	2150	3	banner_
banners	9	40	1871	3	banners
banter	8	48	2533	3	b_anter_
banters	9	46	2311	3	b_anters
banty	10	66	2400	3	b_an_ty
barely	11	47	1679	3	b_arely
barer	7	45	3580	3	b_arer_
barney	11	53	1445	3	barne_y
basely	11	44	1231	3	b_asely
baser	7	48	2892	3	b_aser_
battery	12	49	1181	3	battery
bawdry	15	51	646	3	b_awdry
beachy	16	40	1125	3	bea_chy
beaded	10	49	2242	3	beade_d
beadier	10	35	1391	3	beadier_
beadily	13	7	884	3	beadily
beady	11	47	1992	3	bea__dy
beaked	13	59	1949	3	beake_d
beakier	13	40	1216	3	beakier_
beaky	14	61	1802	3	bea__ky
beamed	11	57	2073	3	beame_d
beamier	11	34	1194	3	beamier_
beamily	14	7	739	3	beamily
beamy	12	62	1857	3	bea__my
bean	6	64	4386	3	bean___
beanbag	12	4	394	3	beanbag
beaneries	11	3	1090	3	beaneries
beanie	8	36	1859	3	bean_ie
beanies	9	38	2109	3	beanies
beaning	10	38	2068	3	beaning
beano	7	54	2155	3	bean__o
beanos	8	55	1651	3	bean_os
beans	7	57	3469	3	bean__s
bear	6	68	4464	3	bea__r_
bearberry	16	4	263	3	bearberry
beard	8	60	2496	3	bea__rd
bears	7	57	3904	3	bea__rs
beastly	12	7	756	3	beastly
beaten	8	46	1706	3	beate_n
beatify	15	3	659	3	beatify
beauty	11	54	1016	3	bea_uty
beavered	14	3	750	3	beavered
bebeeru	11	4	426	3	bebeeru
bedder	10	42	1579	3	bedder_
bedders	11	35	1338	3	bedders
beefy	13	53	1383	3	be__efy
beeper	10	37	1409	3	beeper_
beepers	11	36	1238	3	beepers
beer	6	56	3599	3	be__er_
beers	7	56	2839	3	be__ers
beezer	17	40	1052	3	beezer_
beezers	18	34	924	3	beezers
beggary	14	31	615	3	beggary
behaver	15	20	672	3	behaver_
behavers	16	20	561	3	behavers
bejabers	19	3	363	3	bejabers
belayer	12	33	950	3	belayer_
belayers	13	29	814	3	belayers
belfry	14	3	507	3	be_lfry
belier	8	44	2356	3	belier_
beliers	9	46	1738	3	beliers
belter	8	47	2096	3	belter_
belters	9	38	1941	3	belters
benadryl	14	5	182	3	benadryl
benday	12	38	1081	3	be_nday
bender	9	52	2330	3	bender_
benders	10	40	2106	3	benders
bendy	11	50	1725	3	be_n_dy
bene	6	64	3949	3	be_ne__
benes	7	55	3623	3	be_ne_s
benne	7	65	2112	3	benne__
bennes	8	60	1901	3	benne_s
bennet	8	48	2336	3	benne_t
bennets	9	47	1216	3	bennets
benny	10	52	1736	3	be_n_ny
bergere	10	6	891	3	bergere
berry	10	45	2177	3	be__rry
berserk	13	3	491	3	berserk
better	8	47	2370	3	better_
betters	9	44	2209	3	betters
beweary	15	3	622	3	beweary
beworry	15	4	374	3	beworry
bhangra	13	4	318	3	bhangra
bibbery	13	42	654	3	bibbery
binary	11	3	1222	3	b_inary
bindery	13	45	983	3	bindery
biner	7	59	3069	3	b_iner_
biners	8	50	2363	3	b_iners
bladdery	15	34	458	3	bladdery
blader	9	36	1858	3	blader_
bladers	10	42	1468	3	bladers
blamer	10	44	1714	3	blamer_
blamers	11	53	1421	3	blamers
blander	10	37	1516	3	blander_
blandly	13	3	604	3	blandly
blanker	13	46	1202	3	blanker_
blankly	16	3	426	3	blankly
blarney	12	17	476	3	blarne_y
blazer	17	44	1402	3	blazer_
blazers	18	48	1168	3	blazers
bleaker	13	35	1053	3	bleaker_
bleary	11	51	1255	3	blea__ry
bleater	9	45	1530	3	bleater_
bleaters	10	34	1232	3	bleaters
boater	8	46	2209	3	boater_
boaters	9	34	1924	3	boaters
bobbery	13	43	835	3	bobbery
boner	7	51	3308	3	b_oner_
boners	8	48	2543	3	b_oners
boney	10	52	2731	3	b_one_y
bootery	12	3	898	3	bootery
bowery	14	60	1211	3	b_owery
bracer	10	46	2058	3	bracer_
bracero	11	42	874	3	bracero
bracers	11	46	1670	3	bracers
branchy	17	35	791	3	branchy
brander	10	39	1582	3	brander_
branders	11	43	1309	3	branders
brandy	12	47	1206	3	bran_dy
branner	9	42	1237	3	branner_
branners	10	40	1092	3	branners
branny	11	51	1183	3	bran_ny
bravely	15	42	823	3	bravely
braver	11	47	1904	3	braver_
bravers	12	47	1552	3	bravers
brawer	11	42	1633	3	brawer_
brayer	11	53	1531	3	brayer_
brayers	12	45	1190	3	brayers
brazer	17	49	1753	3	brazer_
brazers	18	45	1394	3	brazers
breaker	13	39	1292	3	breaker_
breakers	14	38	1097	3	breakers
brewery	15	37	696	3	brewery
bribery	14	42	649	3	bribery
briery	11	45	1077	3	b_riery
briner	8	45	1904	3	briner_
briners	9	43	1563	3	briners
buggery	14	36	793	3	buggery
burner	8	38	1920	3	burner_
burners	9	41	1567	3	burners
butlery	12	36	942	3	butlery
buttery	12	43	1119	3	buttery
canary	11	3	1469	3	_canary
caner	7	53	3477	3	_caner_
caners	8	46	2920	3	_caners
cannery	12	36	1001	3	cannery
celery	11	3	962	3	ce_lery
chancery	18	36	665	3	chancery
chantry	15	38	822	3	chantry
cleaner	9	37	1230	3	cleaner_
cleaners	10	36	1054	3	cleaners
creamery	15	38	598	3	creamery
deader	8	42	2047	3	deader_
deafer	10	41	1481	3	deafer_
dealer	7	41	2214	3	dealer_
dealers	8	41	1861	3	dealers
deaned	8	46	2045	3	deane_d
dearer	7	48	2280	3	dearer_
deary	9	58	2684	3	dea__ry
denary	10	53	1686	3	de_nary
drapery	13	38	794	3	drapery
eager	6	55	2697	3	_eager_
eagerly	11	3	605	3	_eagerly
eagers	7	45	2368	3	_eagers
earner	6	36	1722	3	_earner_
earners	7	40	1645	3	_earners
eater	5	46	3984	3	_eater_
eaters	6	55	3595	3	_eaters
eery	7	61	2962	3	_e__ery
emery	10	48	1433	3	_e_mery
empery	13	4	868	3	_empery
enemy	10	5	999	3	_e_nemy
energy	10	13	751	3	_e_nergy
entry	8	24	1426	3	_e_ntry
every	11	52	1545	3	_e_very
faery	11	60	1548	3	_fa_ery
fakery	16	50	926	3	_fakery
fearer	9	48	2018	3	fearer_
fearers	10	48	1527	3	fearers
feater	9	52	2405	3	feater_
feathery	17	36	807	3	feathery
finery	12	45	1289	3	_finery
gantry	10	38	1011	3	_gantry
genera	7	12	1171	3	ge_nera
gentry	10	34	1044	3	ge_ntry
gleaner	8	37	977	3	gleaner_
gleaners	9	34	807	3	gleaners
granary	11	5	779	3	granary
grapery	13	45	795	3	grapery
greenery	12	26	592	3	greenery
gunnery	11	37	637	3	gunnery
header	10	44	2254	3	header_
headers	11	38	1939	3	headers
healer	9	42	2180	3	healer_
healers	10	43	1946	3	healers
heaper	11	41	1952	3	heaper_
heapers	12	36	1667	3	heapers
hearer	9	43	2364	3	hearer_
hearers	10	43	1978	3	hearers
heater	9	48	2830	3	heater_
heaters	10	42	2522	3	heaters
heathery	17	34	908	3	heathery
heaver	12	48	1967	3	heaver_
heavers	13	37	1719	3	heavers
hellery	13	32	921	3	hellery
henry	11	40	1447	3	he_n_ry
imagery	13	12	420	3	imagery
inanely	10	3	794	3	inanely
inaner	6	22	1354	3	inaner_
japery	18	43	914	3	_japery
jeaned	14	38	1346	3	jeane_d
joinery	17	36	659	3	joinery
keener	10	40	1284	3	keener_
keeners	11	36	1078	3	keeners
knavery	17	3	312	3	knavery
lanely	9	39	1448	3	_lanely
leader	7	48	2465	3	leader_
leaders	8	38	1960	3	leaders
leaker	10	46	2007	3	leaker_
leakers	11	34	1542	3	leakers
leaned	7	34	2254	3	leane_d
leanest	7	4	1586	3	leanest
leanly	9	38	1150	3	lean_ly
leaper	8	81	1894	3	leaper_
leapers	9	37	1666	3	leapers
learner	7	31	938	3	learner_
learners	8	39	815	3	learners
leary	8	59	2738	3	lea__ry
leaser	6	53	2267	3	leaser_
leasers	7	47	1784	3	leasers
leathery	14	43	897	3	leathery
leaver	9	43	2151	3	leaver_
leavers	10	37	1778	3	leavers
lechery	15	25	764	3	lechery
leery	8	59	1913	3	le__ery
loaner	6	44	1650	3	loaner_
loaners	7	39	1362	3	loaners
meager	9	45	1520	3	meager_
meagerly	14	4	400	3	meagerly
meander	10	4	997	3	meander_
meanders	11	6	883	3	meanders
meanest	9	3	1570	3	meanest
meanly	11	54	1204	3	mean_ly
meany	10	46	2048	3	mean__y
mercery	14	39	762	3	mercery
moaner	8	44	1511	3	moaner_
moaners	9	28	1355	3	moaners
napery	11	48	981	3	_napery
nearer	6	46	1889	3	nearer_
neater	6	44	2431	3	neater_
nunnery	10	35	530	3	nunnery
onery	8	4	1412	3	__onery
orangery	12	30	554	3	orangery
ornery	9	3	846	3	_ornery
panfry	14	45	641	3	_panfry
pantry	11	50	1410	3	_pantry
papery	13	48	1274	3	_papery
peavey	14	39	879	3	peave_y
pedantry	14	4	405	3	pedantry
pedlery	13	29	708	3	pedlery
peery	10	57	1944	3	pe__ery
penner	8	46	1666	3	penner_
penners	9	34	1418	3	penners
penury	11	4	810	3	pe_nury
peppery	13	28	625	3	peppery
pinery	11	52	1429	3	_pinery
planer	8	41	2265	3	planer_
planers	9	45	1794	3	planers
quavery	22	22	548	3	quavery
reader	7	36	2829	3	reader_
readerly	12	4	508	3	readerly
readers	8	38	2377	3	readers
realer	6	35	2859	3	realer_
reamer	8	43	2521	3	reamer_
reamers	9	42	2108	3	reamers
reaper	8	42	2314	3	reaper_
reapers	9	35	2045	3	reapers
rearer	6	49	2891	3	rearer_
rearers	7	43	2356	3	rearers
reaver	9	45	2473	3	reaver_
reavers	10	83	2074	3	reavers
reentry	10	3	803	3	reentry
refinery	14	44	719	3	refinery
revery	12	40	1421	3	re_very
sanely	9	31	1461	3	_sanely
saner	5	43	3432	3	_saner_
scenery	12	3	656	3	scenery
sealer	6	39	2896	3	sealer_
sealers	7	43	2355	3	sealers
seamer	8	42	2361	3	seamer_
seamers	9	47	1943	3	seamers
searer	6	54	3202	3	searer_
seater	6	45	3416	3	seater_
seaters	7	40	2894	3	seaters
seiner	6	46	2248	3	seiner_
seiners	7	42	1927	3	seiners
senary	9	37	1607	3	se_nary
sentry	9	29	1205	3	se_ntry
slavery	13	40	789	3	slavery
swannery	14	3	355	3	swannery
tannery	10	38	866	3	tannery
teaberry	13	4	329	3	teaberry
tearer	6	48	2290	3	tearer_
tearers	7	52	1823	3	tearers
teary	8	51	2405	3	tea__ry
teaser	6	54	2152	3	teaser_
teasers	7	53	1724	3	teasers
teener	6	47	1750	3	teener_
teeners	7	44	1545	3	teeners
tenantry	11	4	426	3	tenantry
tenner	6	41	1710	3	tenner_
tenners	7	40	1492	3	tenners
ternary	10	3	834	3	ternary
tracery	12	39	979	3	tracery
turnery	10	35	742	3	turnery
vealer	9	40	1654	3	vealer_
vealers	10	32	1429	3	vealers
veery	11	58	1625	3	ve__ery
veiner	9	45	1475	3	veiner_
veiners	10	41	1252	3	veiners
vinery	12	49	1260	3	_vinery
wafery	15	39	869	3	_wafery
waney	11	51	2032	3	_wane_y
watery	12	39	1449	3	_watery
wavery	15	46	1005	3	_wavery
weaker	13	40	1544	3	weaker_
weaned	10	38	1615	3	weane_d
wearer	9	43	1940	3	wearer_
wearers	10	46	1590	3	wearers
weary	11	56	2061	3	wea__ry
weasely	13	31	785	3	weasely
weaver	12	39	1661	3	weaver_
weavers	13	37	1446	3	weavers
weiner	9	42	1413	3	weiner_
weiners	10	39	1306	3	weiners
winery	12	50	1428	3	_winery
yeaned	10	38	1390	3	yeane_d
yearner	10	33	687	3	yearner_
yearners	11	34	637	3	yearners

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	134027	0.403	443402.0
2	DLD Change Limit	134027	385	5.956	22502.9
3	Display Results	385	385	0.140	2750.0
	(SQL Overall)	178691	385	6.499	27495.2