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

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

241 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
brewery	15	37	696	(None)
brewer	11	48	1255	1	brewer_
brewers	12	38	1106	1	brewers
beery	10	52	2012	2	b_e_ery
beweary	15	3	622	2	b_eweary
bowery	14	60	1211	2	b_owery
bravery	15	42	813	2	bravery
brawer	11	42	1633	2	brawer_
breezy	20	29	585	2	bre_ezy
brewed	12	54	1187	2	brewe_d
bribery	14	42	649	2	bribery
briery	11	45	1077	2	br_iery
revery	12	40	1421	2	_revery
archery	15	47	806	3	archery
artery	9	9	1145	3	ar_tery
bakery	15	59	1100	3	b_akery
battery	12	49	1181	3	battery
bawdry	15	51	646	3	b_awdry
beanery	12	3	756	3	beanery
beefy	13	53	1383	3	b_e_efy
beeper	10	37	1409	3	beeper_
beepers	11	36	1238	3	beepers
beer	6	56	3599	3	b_e_er_
beers	7	56	2839	3	b_e_ers
beezer	17	40	1052	3	beezer_
beezers	18	34	924	3	beezers
belfry	14	3	507	3	b_elfry
bergere	10	6	891	3	bergere
berry	10	45	2177	3	b_e_rry
berserk	13	3	491	3	berserk
beware	11	3	1371	3	b_eware
beweep	13	14	725	3	b_eweep
bewept	13	4	1032	3	b_ewept
beworm	13	3	999	3	b_eworm
beworry	15	4	374	3	b_eworry
bewray	14	14	773	3	b_ewray
bibbery	13	42	654	3	bibbery
bindery	13	45	983	3	bindery
bleary	11	51	1255	3	ble_ary
blower	11	53	1657	3	blower_
blowers	12	43	1359	3	blowers
bobbery	13	43	835	3	bobbery
bootery	12	3	898	3	bootery
bower	10	73	2818	3	b_ower_
bowers	11	55	2370	3	b_owers
bracer	10	46	2058	3	bracer_
bracero	11	42	874	3	bracero
bracers	11	46	1670	3	bracers
bravely	15	42	823	3	bravely
braver	11	47	1904	3	braver_
bravers	12	47	1552	3	bravers
brawest	12	38	1048	3	brawest
brawler	12	43	1023	3	brawler_
brawlers	13	40	864	3	brawlers
brawly	14	43	1235	3	braw_ly
brawny	14	47	1060	3	braw_ny
brayer	11	53	1531	3	brayer_
brayers	12	45	1190	3	brayers
brazer	17	49	1753	3	brazer_
brazers	18	45	1394	3	brazers
bready	12	45	1118	3	bre_ady
breaker	13	39	1292	3	breaker_
breakers	14	38	1097	3	breakers
breathy	15	32	803	3	breathy
brede	8	55	2050	3	brede__
bredes	9	48	1847	3	brede_s
bree	6	72	4126	3	bre_e__
breech	13	34	826	3	bre_ech
breed	8	55	2669	3	bre_e_d
breeder	10	32	1004	3	breeder_
breeders	11	36	889	3	breeders
breeds	9	49	1488	3	bre_eds
breeks	12	53	1079	3	bre_eks
brees	7	56	3255	3	bre_e_s
breeze	17	29	896	3	bre_eze
breve	10	53	1705	3	breve__
breves	11	55	1642	3	breve_s
brevet	11	57	1733	3	breve_t
brevetcy	18	4	172	3	brevetcy
brevets	12	51	939	3	brevets
breviary	16	4	261	3	breviary
brevier	12	3	776	3	brevier_
breviers	13	3	592	3	breviers
brevity	15	3	478	3	brevity
brew	9	50	2356	3	brew___
brewage	13	4	718	3	brewage
breweries	14	4	758	3	breweries
brewing	13	34	1115	3	brewing
brewis	11	46	998	3	brew_is
brewpub	16	4	153	3	brewpub
brews	10	56	1707	3	brew__s
brewski	16	10	192	3	brewski
briary	11	49	1200	3	br_iary
briber	10	47	1405	3	briber_
bribers	11	41	1150	3	bribers
briefer	12	3	556	3	briefer_
briefers	13	3	514	3	briefers
brier	7	45	2740	3	br_ier_
briers	8	53	1973	3	br_iers
briner	8	45	1904	3	briner_
briners	9	43	1563	3	briners
broguery	14	4	331	3	broguery
broidery	14	35	608	3	broidery
broker	12	43	1424	3	broker_
brokers	13	31	1191	3	brokers
browed	12	52	1639	3	browe_d
browner	12	49	1164	3	browner_
browny	14	45	1004	3	brow_ny
browser	12	49	1114	3	browser_
browsers	13	44	920	3	browsers
brutely	12	3	593	3	brutely
buggery	14	36	793	3	buggery
butlery	12	36	942	3	butlery
buttery	12	43	1119	3	buttery
celery	11	3	962	3	_celery
cheery	14	49	1315	3	che_ery
chewer	14	55	1262	3	chewer_
chewers	15	41	1114	3	chewers
creamery	15	38	598	3	creamery
creepy	13	41	880	3	cre_epy
crepey	13	51	1093	3	crepe_y
crewed	12	53	1656	3	crewe_d
crewel	11	43	1048	3	crewe_l
crewels	12	43	849	3	crewels
crower	11	41	1756	3	crower_
crowers	12	46	1490	3	crowers
dowery	13	43	1166	3	_dowery
drapery	13	38	794	3	drapery
drawer	10	47	1136	3	drawer_
drawers	11	36	1007	3	drawers
dreary	10	46	1167	3	dre_ary
eery	7	61	2962	3	__e_ery
emery	10	48	1433	3	__emery
every	11	52	1545	3	__every
ewer	7	75	2398	3	__ewer_
ewers	8	60	1882	3	__ewers
fernery	13	3	581	3	fernery
fewer	11	52	1612	3	_fewer_
flowery	16	32	778	3	flowery
freely	12	3	1096	3	fre_ely
freer	8	60	2124	3	fre_er_
freers	9	47	1730	3	fre_ers
freeway	16	3	560	3	freeway
grapery	13	45	795	3	grapery
greedy	11	51	885	3	gre_edy
greenery	12	26	592	3	greenery
greeny	10	48	1145	3	gre_eny
greyer	10	45	1009	3	greyer_
grocery	13	33	676	3	grocery
grower	10	46	1493	3	grower_
growers	11	36	1272	3	growers
hewer	11	57	1993	3	_hewer_
hewers	12	37	1527	3	_hewers
jewelry	20	4	199	3	_jewelry
krewe	12	3	819	3	krewe__
krewes	13	3	792	3	krewe_s
leery	8	59	1913	3	_le_ery
lowery	12	41	1271	3	_lowery
mercery	14	39	762	3	mercery
newer	8	57	1746	3	_newer_
ornery	9	3	846	3	or_nery
orrery	9	3	678	3	or_rery
peery	10	57	1944	3	_pe_ery
predry	12	3	787	3	pre_dry
prefer	11	38	1320	3	prefer_
prefers	12	37	1333	3	prefers
preterm	11	3	1016	3	preterm
preverb	14	31	706	3	preverb
prewar	11	47	1258	3	prewar_
prewarm	14	47	961	3	prewarm
prewarn	12	44	1015	3	prewarn
prewire	12	43	1114	3	prewire
prework	16	42	1091	3	prework
preworn	12	47	1122	3	preworn
preyer	11	44	1373	3	preyer_
preyers	12	44	1236	3	preyers
prower	11	42	1812	3	prower_
prudery	13	3	524	3	prudery
rawer	8	46	2373	3	_rawer_
rebury	11	34	921	3	_rebury
redefy	13	38	876	3	_redefy
redeny	10	27	1273	3	_redeny
redry	9	43	1436	3	_re_dry
reedy	9	100	2029	3	_re_edy
reefy	11	42	1770	3	_re_efy
reeky	12	54	1626	3	_re_eky
refer	8	48	2214	3	_refer_
refers	9	39	2108	3	_refers
refry	11	44	1246	3	_re_fry
rekey	12	40	1473	3	_reke_y
remedy	12	3	787	3	_remedy
reperk	12	25	1177	3	_reperk
retry	8	47	1808	3	_re_try
revelry	13	3	569	3	_revelry
reverb	11	39	1257	3	_reverb
revere	9	46	2125	3	_revere
revers	9	45	2963	3	_revers
revert	9	35	2911	3	_revert
reward	10	60	1764	3	_reward
rewarm	11	59	1349	3	_rewarm
rewear	9	30	1200	3	_rewear
rewears	10	29	1104	3	_rewears
rewed	9	54	2545	3	_rewe_d
reweds	10	44	1230	3	_reweds
reweld	10	37	1111	3	_reweld
rewet	8	51	3515	3	_rewe_t
rewets	9	46	1721	3	_rewets
rewire	9	54	2141	3	_rewire
reword	10	63	2141	3	_reword
rewore	9	380	3016	3	_rewore
rework	13	66	1979	3	_rework
reworn	9	81	2220	3	_reworn
rezero	15	7	887	3	_rezero
ropery	11	43	1387	3	_ropery
rosery	9	38	1328	3	_rosery
rower	8	54	3049	3	_rower_
rowers	9	49	2457	3	_rowers
rudery	10	41	903	3	_rudery
scenery	12	3	656	3	scenery
screwer	12	44	1007	3	screwer_
screwers	13	35	806	3	screwers
sewer	8	44	2622	3	_sewer_
sewers	9	47	1972	3	_sewers
shewer	12	45	1511	3	shewer_
shewers	13	43	1205	3	shewers
showery	16	43	724	3	showery
skewer	13	51	961	3	skewer_
skewers	14	49	838	3	skewers
sneery	9	36	1041	3	sne_ery
spewer	11	51	1215	3	spewer_
spewers	12	42	1066	3	spewers
strewer	10	43	1041	3	strewer_
strewers	11	40	906	3	strewers
towery	12	40	1209	3	_towery
tracery	12	39	979	3	tracery
ureter	6	3	1320	3	ureter_
ureters	7	3	1182	3	ureters
veery	11	58	1625	3	_ve_ery
venery	12	37	1066	3	_venery
viewer	12	3	721	3	viewer_
viewers	13	3	717	3	viewers

Search took 8 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.423	422437.4
2	DLD Change Limit	134027	241	6.563	20421.6
3	Display Results	241	241	0.090	2677.8
	(SQL Overall)	178691	241	7.076	25253.1