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

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

376 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
barer	7	45	3580	(None)
baker	11	56	2954	1	baker
baler	7	56	3527	1	baler
barber	10	44	1932	1	barber
bare	6	54	6052	1	bare_
bared	8	51	4448	1	bared
bares	7	54	5713	1	bares
barker	12	48	2286	1	barker
barre	7	59	2954	1	barre
barter	8	55	2537	1	barter
baser	7	48	2892	1	baser
bearer	8	53	2391	1	bearer
borer	7	51	3127	1	borer
carer	7	49	4233	1	carer
darer	6	52	3079	1	darer
farer	8	67	3314	1	farer
parer	7	58	3990	1	parer
rarer	5	47	3170	1	rarer
yarer	8	43	2157	1	yarer
abaser	8	64	1434	2	abaser
abater	8	55	1812	2	abater
abler	7	56	2431	2	abler
ager	5	59	3584	2	_ager
airer	5	49	2789	2	airer
aper	6	63	3623	2	_aper
are	3	78	7457	2	_are_
area	4	58	4339	2	_area
ares	4	58	7102	2	_ares
armer	7	69	2444	2	_armer
aver	7	59	3188	2	_aver
baaed	8	52	1816	2	baaed
babe	8	68	3581	2	babe_
babel	9	58	2169	2	babel
babes	9	58	3411	2	babes
babier	10	35	1556	2	babier
backer	14	45	2552	2	backer
badder	10	38	1751	2	badder
bade	7	51	4088	2	bade_
badger	10	54	1507	2	badger
bagel	8	51	1679	2	bagel
bagger	10	46	1920	2	bagger
bailer	8	54	2525	2	bailer
baiter	8	44	2255	2	baiter
bake	10	56	3751	2	bake_
baked	12	61	3077	2	baked
bakers	12	53	2345	2	bakers
bakery	15	59	1100	2	bakery
bakes	11	70	3537	2	bakes
balder	9	53	1886	2	balder
bale	6	63	5384	2	bale_
baled	8	54	3644	2	baled
balers	8	56	2693	2	balers
bales	7	62	5008	2	bales
balker	12	45	1916	2	balker
baller	8	38	2520	2	baller
bander	9	39	2822	2	bander
bane	6	52	5042	2	bane_
baned	8	54	3635	2	baned
banes	7	49	4558	2	banes
banger	9	44	2363	2	banger
banker	12	42	2273	2	banker
banner	8	44	2150	2	banner
banter	8	48	2533	2	banter
bar	5	80	7055	2	ba__r
barb	8	52	4006	2	bar_b
barbe	9	53	2828	2	barbe
barbed	11	51	2131	2	barbed
barbel	10	43	1707	2	barbel
barbers	11	43	1750	2	barbers
barbes	10	45	2623	2	barbes
barbet	10	44	2788	2	barbet
barbs	9	59	2819	2	barbs
barca	9	13	1943	2	barca
bard	7	56	4886	2	bar_d
barde	8	53	3077	2	barde
barded	10	54	2642	2	barded
bardes	9	50	2693	2	bardes
bards	8	71	3964	2	bards
barege	9	47	1354	2	barege
barely	11	47	1679	2	barely
barest	8	53	2769	2	barest
barf	9	58	4440	2	bar_f
barfed	12	54	1638	2	barfed
barfs	10	48	2600	2	barfs
barge	8	56	3102	2	barge
barged	10	58	2264	2	barged
bargee	9	46	2444	2	bargee
barges	9	45	2825	2	barges
baric	9	61	2569	2	baric
bark	10	62	4215	2	bar_k
barked	13	50	2731	2	barked
barkers	13	43	1851	2	barkers
barkier	13	38	1448	2	barkier
barks	11	57	3581	2	barks
barky	14	57	2161	2	barky
barley	11	51	1676	2	barley
barm	8	67	3960	2	bar_m
barmen	10	54	1853	2	barmen
barmier	11	43	1304	2	barmier
barms	9	61	2846	2	barms
barmy	12	52	1876	2	barmy
barn	6	64	4464	2	bar_n
barned	9	56	2358	2	barned
barney	11	53	1445	2	barney
barnier	9	32	1367	2	barnier
barns	7	63	3514	2	barns
barny	10	58	2173	2	barny
baron	7	81	3124	2	baron
barred	9	57	2579	2	barred
barrel	8	45	1787	2	barrel
barren	8	53	1761	2	barren
barres	8	44	2754	2	barres
barret	8	49	3048	2	barret
barrier	9	40	1773	2	barrier
bars	6	65	6409	2	bar_s
barters	9	42	2303	2	barters
barye	10	50	2149	2	barye
baryes	11	62	1850	2	baryes
base	6	48	4702	2	base_
based	8	53	3158	2	based
bases	7	56	4435	2	bases
basher	11	51	2381	2	basher
baster	8	53	3359	2	baster
bate	6	65	5242	2	bate_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bather	11	53	2251	2	bather
batter	8	49	2887	2	batter
bawler	11	43	1505	2	bawler
bayed	11	54	2302	2	bayed
bazar	16	38	1600	2	bazar
beader	9	46	2379	2	beader
beaker	12	55	2069	2	beaker
bearers	9	46	1959	2	bearers
beater	8	47	2939	2	beater
beaver	11	48	1925	2	beaver
beer	6	56	3599	2	b_eer
beret	7	49	4636	2	beret
bider	8	57	2837	2	bider
bier	6	55	3182	2	b_ier
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
birder	9	49	1549	2	birder
birler	8	57	1508	2	birler
birr	6	60	2235	2	bir_r
biter	7	50	3003	2	biter
blader	9	36	1858	2	blader
blamer	10	44	1714	2	blamer
blare	7	58	2623	2	blare_
blared	9	50	1824	2	blared
blares	8	50	2163	2	blares
blazer	17	44	1402	2	blazer
bluer	7	49	1849	2	bluer
boarder	10	39	1032	2	boarder
boater	8	46	2209	2	boater
boner	7	51	3308	2	boner
border	9	44	1997	2	border
bore	6	60	5133	2	bore_
bored	8	50	3430	2	bored
borers	8	51	2268	2	borers
bores	7	64	4825	2	bores
bower	10	73	2818	2	bower
boxer	14	50	1652	2	boxer
bracer	10	46	2058	2	bracer
brae	6	56	3911	2	brae_
braes	7	57	3505	2	braes
braver	11	47	1904	2	braver
brawer	11	42	1633	2	brawer
brayer	11	53	1531	2	brayer
brazer	17	49	1753	2	brazer
bred	7	51	3097	2	b_red
bree	6	72	4126	2	b_ree
bren	6	56	2956	2	b_ren
brew	9	50	2356	2	b_rew
brier	7	45	2740	2	brier
brr	5	69	2192	2	b_r_r
brrr	6	53	1229	2	b_rrr
buret	7	74	4401	2	buret
burger	9	40	2079	2	burger
burier	8	43	2465	2	burier
burker	12	52	2117	2	burker
burler	8	47	2383	2	burler
burner	8	38	1920	2	burner
burr	6	56	3123	2	bur_r
burrer	8	37	1847	2	burrer
buyer	10	50	1309	2	buyer
byre	9	50	2385	2	byre_
byres	10	44	2138	2	byres
caber	9	51	2683	2	caber
cager	8	52	2922	2	cager
caner	7	53	3477	2	caner
caper	9	48	3162	2	caper
carder	9	45	2418	2	carder
care	6	69	6837	2	care_
cared	8	60	5009	2	cared
career	8	58	2224	2	career
carers	8	51	3395	2	carers
cares	7	73	6918	2	cares
caret	7	53	6056	2	caret
carex	14	48	2229	2	carex
carper	10	49	2363	2	carper
carr	6	54	3470	2	car_r
carter	8	49	3227	2	carter
carver	11	44	2014	2	carver
cater	7	48	4070	2	cater
caver	10	56	2906	2	caver
corer	7	55	3887	2	corer
curer	7	50	3075	2	curer
dare	5	58	4886	2	dare_
dared	7	59	3501	2	dared
darers	7	59	2187	2	darers
dares	6	61	4670	2	dares
darker	11	47	1869	2	darker
darner	7	40	1730	2	darner
darter	7	53	2036	2	darter
dater	6	53	3231	2	dater
dearer	7	48	2280	2	dearer
direr	6	49	2707	2	direr
eager	6	55	2696	2	eager
eared	6	51	3950	2	eared
earner	6	36	1722	2	earner
eater	5	46	3984	2	eater
facer	10	55	2505	2	facer
fader	9	44	2151	2	fader
fairer	9	52	1206	2	fairer
faker	12	48	2459	2	faker
farcer	11	50	1608	2	farcer
fare	7	63	5446	2	fare_
fared	9	58	4234	2	fared
farers	9	59	2405	2	farers
fares	8	58	5287	2	fares
farmer	11	50	1737	2	farmer
fearer	9	48	2018	2	fearer
firer	8	112	2925	2	firer
gager	7	47	2629	2	gager
gamer	8	49	2894	2	gamer
gaper	8	61	2512	2	gaper
garner	7	39	1700	2	garner
garter	7	44	2051	2	garter
gater	6	45	3364	2	gater
gayer	9	45	1919	2	gayer
gazer	15	57	2007	2	gazer
haler	8	50	3352	2	haler
harder	10	50	2240	2	harder
hare	7	62	5573	2	hare_
hared	9	57	4218	2	hared
harem	10	49	2445	2	harem
hares	8	62	5554	2	hares
harmer	11	47	1955	2	harmer
harper	11	50	1840	2	harper
hater	8	50	3475	2	hater
haver	11	51	2446	2	haver
hayer	11	46	2024	2	hayer
hazer	17	48	2023	2	hazer
hearer	9	43	2364	2	hearer
hirer	8	54	2312	2	hirer
jager	13	43	1813	2	jager
japer	14	62	1888	2	japer
lacer	7	58	3375	2	lacer
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
laker	9	54	3287	2	laker
lamer	7	52	3370	2	lamer
larder	7	37	2097	2	larder
laree	5	60	3629	2	laree
lares	5	48	5263	2	lares
larger	7	44	1751	2	larger
larker	10	45	1924	2	larker
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
lurer	5	46	2531	2	lurer
macer	9	121	2694	2	macer
maker	11	41	2781	2	maker
mare	6	47	5932	2	mare_
mares	7	64	5763	2	mares
marker	12	44	2039	2	marker
marrer	8	37	1667	2	marrer
maser	7	50	2997	2	maser
mater	7	44	3886	2	mater
mazer	16	57	2242	2	mazer
merer	7	51	2623	2	merer
namer	7	56	2210	2	namer
nares	5	55	4415	2	nares
nearer	6	46	1889	2	nearer
oared	6	50	3065	2	oared
oater	5	54	3373	2	oater
pacer	9	61	3161	2	pacer
pager	8	47	2820	2	pager
paler	7	54	3693	2	paler
paper	9	51	2866	2	paper
pare	6	67	6084	2	pare_
pared	8	69	4676	2	pared
pareo	7	46	3260	2	pareo
parers	8	55	3074	2	parers
pares	7	71	6448	2	pares
pareu	7	49	2874	2	pareu
parker	12	41	2137	2	parker
parr	6	57	3115	2	par_r
parser	8	48	2237	2	parser
pater	7	47	4072	2	pater
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
purer	7	51	2790	2	purer
racer	7	52	3302	2	racer
raker	9	45	2979	2	raker
raper	7	49	3275	2	raper
rare	4	53	4843	2	rare_
rared	6	57	3832	2	rared
rares	5	52	4744	2	rares
raser	5	56	3341	2	raser
rater	5	49	4328	2	rater
raver	8	56	3149	2	raver
rawer	8	46	2373	2	rawer
razer	14	48	2427	2	razer
rearer	6	49	2891	2	rearer
roarer	6	39	1433	2	roarer
saber	7	53	3024	2	saber
safer	8	47	2181	2	safer
sager	6	54	3205	2	sager
saker	9	51	3202	2	saker
saner	5	43	3432	2	saner
saree	5	50	4466	2	saree
saver	8	48	3125	2	saver
sawer	8	50	2621	2	sawer
sayer	8	49	2655	2	sayer
scarer	8	45	2460	2	scarer
searer	6	54	3202	2	searer
serer	5	59	3550	2	serer
sharer	9	50	2548	2	sharer
snarer	6	46	2084	2	snarer
soarer	6	45	2224	2	soarer
sorer	5	62	3657	2	sorer
sparer	8	45	2496	2	sparer
starer	6	40	2736	2	starer
surer	5	48	3309	2	surer
taber	7	38	2582	2	taber
taker	9	52	2900	2	taker
taler	5	60	3486	2	taler
tamer	7	52	3010	2	tamer
taper	7	48	2977	2	taper
tare	4	59	5762	2	tare_
tared	6	93	4005	2	tared
tares	5	74	5656	2	tares
tarre	5	58	2563	2	tarre
tarter	6	40	2356	2	tarter
tater	5	41	3861	2	tater
tawer	8	52	2344	2	tawer
taxer	12	50	1936	2	taxer
tearer	6	48	2290	2	tearer
varier	9	46	1935	2	varier
wader	9	53	2536	2	wader
wafer	11	44	1764	2	wafer
wager	9	59	2505	2	wager
waker	12	55	2659	2	waker
waler	8	42	2926	2	waler
warder	10	40	2027	2	warder
ware	7	62	5472	2	ware_
wared	9	63	3987	2	wared
wares	8	82	5058	2	wares
warier	9	37	2289	2	warier
warmer	11	38	1673	2	warmer
warner	9	37	1722	2	warner
warper	11	40	1558	2	warper
water	8	47	3331	2	water
waver	11	50	2570	2	waver
waxer	15	43	1748	2	waxer
wearer	9	43	1940	2	wearer
wirer	8	51	2495	2	wirer
yager	9	56	1675	2	yager
yarder	10	38	1397	2	yarder
yare	7	56	3694	2	yare_
yarner	9	33	1306	2	yarner

Search took 6 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	53800	0.203	880251.2
2	DLD Change Limit	53800	376	4.283	12561.3
3	Display Results	376	376	0.233	1613.7
	(SQL Overall)	178691	376	4.719	37866.3