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

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

386 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
bateau	8	8	1056	(None)
bateaux	16	9	388	1	bateaux
batteau	9	3	634	1	batteau
gateau	7	7	811	1	gateau
bandeau	10	3	852	2	bandeau
bate	6	65	5242	2	bate__
bated	8	59	3553	2	bate_d
bates	7	58	4634	2	bate_s
batman	10	52	1406	2	batman
batteaux	17	4	250	2	batteaux
battu	7	52	1661	2	bat_tu
beau	6	61	3727	2	b__eau
bureau	8	7	1252	2	bureau
chateau	12	3	627	2	chateau
coteau	8	3	1108	2	coteau
gateaus	8	6	633	2	gateaus
gateaux	15	7	312	2	gateaux
manteau	9	3	786	2	manteau
plateau	9	3	740	2	plateau
abate	7	66	2784	3	abate__
abated	9	59	1845	3	abate_d
abater	8	55	1812	3	abate_r
abaters	9	51	1520	3	abaters
abates	8	58	2503	3	abate_s
abeam	9	3	1653	3	_abeam
aboiteau	10	4	271	3	aboiteau
ahead	9	68	1705	3	_ahead
anear	5	54	2032	3	_anear
apeak	11	55	1345	3	_apeak
area	4	58	4339	3	_area_
areae	5	52	2974	3	_areae
areal	5	59	2873	3	_areal
areas	5	59	3577	3	_areas
asea	4	63	2718	3	_asea_
atap	6	67	2245	3	_at_ap
ate	3	70	5924	3	_ate__
ates	4	50	4792	3	_ate_s
atlas	5	58	2158	3	_atlas
atma	6	81	2177	3	_atma_
atman	7	55	2014	3	_atman
atmas	7	57	2101	3	_atmas
attar	5	65	1669	3	_attar
baa	5	106	5042	3	ba__a_
baaed	8	52	1816	3	baae_d
baal	6	70	3311	3	ba__al
baas	6	68	4467	3	ba__as
baba	8	88	2835	3	ba_ba_
babas	9	63	2573	3	ba_bas
babe	8	68	3582	3	babe__
babel	9	58	2169	3	babe_l
babels	10	52	1672	3	babels
babes	9	58	3411	3	babe_s
babka	13	78	1291	3	babka_
babkas	14	60	1014	3	babkas
babu	8	58	2923	3	ba__bu
bacca	11	10	1218	3	bacca_
baccae	12	11	970	3	baccae
bade	7	51	4088	3	bade__
badman	11	38	1384	3	badman
bagel	8	51	1679	3	bage_l
bagels	9	57	1231	3	bagels
bagman	11	46	1381	3	bagman
baited	9	53	1924	3	baite_d
baiter	8	44	2255	3	baite_r
baiters	9	46	1930	3	baiters
baiza	16	48	1322	3	baiza_
baizas	17	38	1082	3	baizas
bake	10	56	3751	3	bake__
baked	12	61	3077	3	bake_d
baker	11	56	2954	3	bake_r
bakers	12	53	2345	3	bakers
bakery	15	59	1100	3	bakery
bakes	11	70	3537	3	bake_s
balas	7	69	3721	3	ba_las
bale	6	63	5384	3	bale__
baled	8	54	3644	3	bale_d
baleen	8	6	1305	3	baleen
baleful	12	3	800	3	baleful
baler	7	56	3527	3	bale_r
balers	8	56	2693	3	balers
bales	7	62	5008	3	bale_s
ballad	9	43	1532	3	ballad
balneal	9	3	657	3	balneal
balsa	7	79	2041	3	balsa_
balsam	10	56	1223	3	balsam
balsas	8	64	1752	3	balsas
banal	7	59	2599	3	ba_nal
banda	8	52	2310	3	banda_
bandas	9	51	2054	3	bandas
bandeaus	11	4	650	3	bandeaus
bandeaux	18	4	329	3	bandeaux
bane	6	52	5043	3	bane__
baned	8	54	3635	3	bane_d
baneful	12	3	789	3	baneful
banes	7	49	4558	3	bane_s
banian	8	3	1538	3	banian
banjax	22	3	476	3	banjax
bantam	10	3	1406	3	bantam
banteng	10	4	636	3	banteng
banter	8	48	2533	3	bante_r
banters	9	46	2311	3	banters
banyan	11	3	948	3	banyan
banzai	17	3	765	3	banzai
baobab	9	4	640	3	baobab
barbal	10	40	1666	3	barbal
barca	9	13	1943	3	barca_
barcas	10	10	1660	3	barcas
bare	6	54	6052	3	bare__
bared	8	51	4448	3	bare_d
barege	9	47	1354	3	barege
barely	11	47	1679	3	barely
barer	7	45	3580	3	bare_r
bares	7	54	5713	3	bare_s
barest	8	53	2769	3	barest
barman	10	35	1970	3	barman
bartend	10	3	875	3	bartend
barter	8	55	2537	3	barte_r
barters	9	42	2303	3	barters
basal	7	57	2228	3	ba_sal
base	6	48	4702	3	base__
based	8	53	3158	3	base_d
basely	11	44	1231	3	basely
baseman	11	3	855	3	baseman
baser	7	48	2892	3	base_r
bases	7	56	4435	3	base_s
basest	8	47	2049	3	basest
bashaw	14	34	930	3	bashaw
baste	7	48	2998	3	baste__
basted	9	52	2723	3	baste_d
baster	8	53	3359	3	baste_r
basters	9	49	3030	3	basters
bastes	8	53	3038	3	baste_s
bat	5	109	8895	3	bat___
batboy	13	8	753	3	batboy
batch	12	46	2010	3	bat_ch
bath	9	59	4008	3	bat__h
bathe	10	58	2288	3	bat_he
bathed	12	55	1874	3	bathed
bather	11	53	2251	3	bather
bathers	12	47	2036	3	bathers
bathes	11	65	2483	3	bathes
bathmat	14	5	1014	3	bathmat
bathos	11	62	1563	3	bathos
baths	10	59	2292	3	bat_hs
bathtub	14	4	269	3	bathtub
bathyal	15	4	482	3	bathyal
batik	11	6	1473	3	bat_ik
batiks	12	3	937	3	batiks
bating	9	51	3225	3	bating
batmen	10	44	1430	3	batmen
baton	7	58	2242	3	bat_on
batons	8	55	1942	3	batons
bats	6	69	6233	3	bat__s
batsman	11	5	799	3	batsman
batt	6	50	5387	3	bat__t
batted	9	56	2365	3	batted
batten	8	52	1712	3	batten
battens	9	53	1326	3	battens
batter	8	49	2887	3	batter
batters	9	46	2601	3	batters
battery	12	49	1181	3	battery
battik	12	3	809	3	battik
battle	8	52	1786	3	battle
batts	7	67	2756	3	bat_ts
battue	8	43	1100	3	battue
batty	10	54	2224	3	bat_ty
bayed	11	54	2302	3	baye_d
bayman	13	37	1270	3	bayman
bayou	10	5	1236	3	ba_you
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	ba_zar
bead	7	59	3792	3	b__ead
beak	10	65	3438	3	b__eak
beam	8	69	3923	3	b__eam
bean	6	64	4386	3	b__ean
bear	6	68	4464	3	b__ear
beat	6	61	6830	3	b__eat
beaten	8	46	1706	3	beate_n
beater	8	47	2939	3	beate_r
beaters	9	49	2504	3	beaters
beaus	7	51	2711	3	b__eaus
beaut	7	51	3521	3	b__eaut
beaux	14	65	1321	3	b__eaux
bedu	7	59	2369	3	b__edu
behead	12	3	992	3	behead
beleap	10	4	1028	3	beleap
bemean	10	4	1068	3	bemean
bestead	10	38	912	3	bestead
beta	6	62	3413	3	bet_a_
betas	7	55	2876	3	bet_as
betel	7	44	1990	3	bete_l
betels	8	45	1506	3	betels
betray	11	15	1144	3	betray
betta	7	49	1684	3	betta_
bettas	8	49	1392	3	bettas
bite	6	65	4700	3	bite__
biter	7	50	3003	3	bite_r
biters	8	39	2524	3	biters
bites	7	56	4117	3	bite_s
bitmap	12	3	561	3	bitmap
blate	7	59	3378	3	blate__
bleak	11	59	1538	3	b_leak
blear	7	59	1868	3	b_lear
bleat	7	57	3700	3	b_leat
boated	9	42	2197	3	boate_d
boatel	8	43	1409	3	boate_l
boatels	9	35	1023	3	boatels
boater	8	46	2209	3	boate_r
boaters	9	34	1924	3	boaters
boatman	11	4	705	3	boatman
bohea	10	50	1373	3	bohea_
boheas	11	40	1321	3	boheas
boreal	8	48	1721	3	boreal
boreas	8	54	2173	3	boreas
bota	6	62	3650	3	bot_a_
botas	7	53	2878	3	bot_as
botel	7	51	2186	3	bote_l
botels	8	48	1580	3	botels
bracteal	12	4	556	3	bracteal
bread	8	55	2311	3	b_read
break	11	53	1940	3	b_reak
bream	9	51	2181	3	b_ream
bureaus	9	7	929	3	bureaus
bureaux	16	6	459	3	bureaux
bute	6	67	3967	3	bute__
butene	8	3	1262	3	butene
buteo	7	54	1989	3	bute_o
buteos	8	49	1341	3	buteos
butes	7	145	3587	3	bute_s
byte	9	65	2181	3	byte__
bytes	10	52	1749	3	byte_s
cate	6	62	5460	3	cate__
catechu	14	4	447	3	catechu
catena	8	3	1248	3	catena
catenae	9	3	1137	3	catenae
catenas	9	3	1311	3	catenas
cater	7	48	4072	3	cate_r
cateran	9	3	1377	3	cateran
caters	8	53	3650	3	caters
cates	7	59	5189	3	cate_s
cathead	13	3	875	3	cathead
catnap	10	9	838	3	catnap
caveat	11	4	1772	3	caveat
chapeau	14	3	552	3	chapeau
chateaus	13	4	601	3	chateaus
chateaux	20	4	307	3	chateaux
coteaux	16	4	372	3	coteaux
couteau	9	3	883	3	couteau
data	5	60	2665	3	dat_a_
date	5	64	4332	3	date__
dated	7	55	3099	3	date_d
dater	6	53	3231	3	date_r
daters	7	48	2737	3	daters
dates	6	56	3915	3	date_s
eaten	5	53	2305	3	eate_n
eater	5	46	3984	3	eate_r
eaters	6	55	3595	3	eaters
eatery	9	53	1635	3	eatery
eau	3	74	5094	3	___eau
fatal	8	48	1937	3	fat_al
fate	7	54	4428	3	fate__
fated	9	56	3213	3	fate_d
fateful	13	9	751	3	fateful
fates	8	51	3923	3	fate_s
fathead	14	3	786	3	fathead
fatwa	11	6	806	3	fatwa_
fatwas	12	4	905	3	fatwas
galea	6	47	2294	3	galea_
galeae	7	47	1745	3	galeae
galeas	7	46	1851	3	galeas
gate	5	57	4657	3	gate__
gated	7	53	2977	3	gate_d
gateman	10	5	747	3	gateman
gater	6	45	3365	3	gate_r
gaters	7	47	2864	3	gaters
gates	6	59	3951	3	gate_s
gateway	14	3	493	3	gateway
haleru	9	42	1207	3	haleru
hate	7	84	5017	3	hate__
hated	9	57	3402	3	hate_d
hateful	13	10	768	3	hateful
hater	8	50	3475	3	hate_r
haters	9	49	3040	3	haters
hates	8	67	4257	3	hate_s
jambeau	18	4	377	3	jambeau
kata	8	56	2602	3	kat_a_
katas	9	59	2209	3	kat_as
lacteal	9	6	682	3	lacteal
lactean	9	5	648	3	lactean
landau	7	3	1061	3	landau
late	4	75	6048	3	late__
lated	6	52	4067	3	late_d
lateen	6	40	1486	3	lateen
lately	9	34	1384	3	lately
laten	5	43	2834	3	late_n
latens	6	46	2021	3	latens
latent	6	41	2430	3	latent
later	5	48	4392	3	late_r
laterad	8	3	1084	3	laterad
lateral	7	3	1357	3	lateral
latest	6	38	2270	3	latest
latex	12	47	1711	3	late_x
latu	4	79	3418	3	lat__u
lutea	5	48	1907	3	lutea_
luteal	6	44	1148	3	luteal
manteaus	10	3	638	3	manteaus
manteaux	17	4	288	3	manteaux
mate	6	51	5422	3	mate__
mated	8	55	3778	3	mate_d
mater	7	44	3886	3	mate_r
maters	8	50	3239	3	maters
mates	7	52	5136	3	mate_s
matey	10	70	2266	3	mate_y
mateys	11	56	1094	3	mateys
matsah	11	3	823	3	matsah
matza	16	3	1181	3	matza_
matzah	20	3	596	3	matzah
matzas	17	4	970	3	matzas
natal	5	39	2149	3	nat_al
nates	5	52	3833	3	nate_s
oaten	5	52	2240	3	oate_n
oater	5	54	3373	3	oate_r
oaters	6	50	2979	3	oaters
oatmeal	9	4	497	3	oatmeal
osteal	6	3	1296	3	osteal
outeat	6	28	2453	3	outeat
paean	7	72	2272	3	pa_ean
palea	7	50	2866	3	palea_
paleae	8	48	2029	3	paleae
paleal	8	47	1667	3	paleal
pareu	7	49	2874	3	pare_u
pate	6	53	5046	3	pate__
pated	8	52	3784	3	pate_d
paten	7	48	2734	3	pate_n
patens	8	48	2086	3	patens
patent	8	45	2492	3	patent
pater	7	47	4072	3	pate_r
paters	8	49	3583	3	paters
pates	7	60	4789	3	pate_s
plateaus	10	3	553	3	plateaus
plateaux	17	4	287	3	plateaux
ratal	5	50	2511	3	rat_al
ratan	5	37	2266	3	rat_an
ratbag	9	5	656	3	ratbag
rate	4	54	5876	3	rate__
rated	6	54	4138	3	rate_d
ratel	5	42	2488	3	rate_l
ratels	6	45	1821	3	ratels
rater	5	49	4328	3	rate_r
raters	6	39	3658	3	raters
rates	5	53	5201	3	rate_s
rattan	6	36	1360	3	rattan
reseau	6	42	1621	3	reseau
reteam	8	32	1453	3	reteam
retear	6	31	1548	3	retear
satay	8	47	1846	3	sat_ay
sate	4	55	5610	3	sate__
sated	6	62	3853	3	sate_d
sateen	6	38	1501	3	sateen
satem	7	60	2146	3	sate_m
sates	5	49	4932	3	sate_s
satrap	8	62	1255	3	satrap
stead	6	55	2027	3	_stead
steak	9	52	1980	3	_steak
steal	5	61	2547	3	_steal
steam	7	63	2293	3	_steam
tableau	9	6	628	3	tableau
tatar	5	61	2206	3	tat_ar
tate	4	47	4860	3	tate__
tater	5	41	3861	3	tate_r
taters	6	49	3220	3	taters
tates	5	54	4498	3	tate_s
tau	3	68	5690	3	__t_au
tea	3	73	5332	3	__tea_
teak	8	59	3084	3	__teak
teal	4	55	4650	3	__teal
team	6	62	3865	3	__team
tear	4	52	4288	3	__tear
teas	4	58	5149	3	__teas
teat	4	59	6363	3	__teat
uptear	8	9	678	3	uptear
vatu	7	65	2433	3	vat__u
watap	10	21	1167	3	wat_ap
water	8	47	3331	3	wate_r
waters	9	50	3063	3	waters
watery	12	39	1449	3	watery

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	112716	0.420	425454.8
2	DLD Change Limit	112716	386	5.190	21717.9
3	Display Results	386	386	0.110	3509.1
	(SQL Overall)	178691	386	5.720	31239.7