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

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

397 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
barrio	8	3	1257	(None)
barrios	9	3	1077	1	barrios
arris	5	68	2468	2	_arris
bagnio	9	3	752	2	bagnio
barbie	10	50	1835	2	barbie
bardic	11	3	1292	2	bardic
baric	9	61	2569	2	ba_ric
barmie	10	38	1639	2	barmie
barre	7	59	2954	2	barr_e
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
barring	10	40	2159	2	barring
barroom	11	3	937	2	barroom
barrow	11	45	1276	2	barrow
brio	6	54	3249	2	b__rio
burrito	9	3	622	2	burrito
burro	7	50	1849	2	burr_o
cardio	9	9	1567	2	cardio
carrion	9	3	1267	2	carrion
karroo	10	4	1001	2	karroo
warrior	10	4	536	2	warrior
aarrgh	10	78	630	3	aarrgh
abri	6	55	2221	3	_abri_
abris	7	57	2260	3	_abris
acrid	8	69	2010	3	_acrid
aerie	5	46	3460	3	_aerie
aero	4	54	3534	3	_aer_o
afrit	8	3	2317	3	_afrit
agio	5	78	2845	3	_a_gio
agria	6	55	1714	3	_agria
amnio	7	52	1804	3	_amnio
arco	6	83	3154	3	_a_rco
areic	7	32	1939	3	_areic
argil	6	51	1688	3	_argil
aria	4	62	4542	3	_a_ria
arid	5	76	4271	3	_a_rid
aril	4	58	4302	3	_a_ril
aroid	6	54	2833	3	_aroid
arras	5	56	2613	3	_arras
array	8	63	1714	3	_array
arriba	8	6	767	3	_arriba
arrive	9	13	1179	3	_arrive
arrow	8	34	1488	3	_arrow
arroyo	9	3	696	3	_arroyo
arsino	6	41	1351	3	_arsino
arsis	5	57	2242	3	_arsis
arvo	7	60	2343	3	_a_rvo
atria	5	60	2233	3	_atria
atrip	7	53	1574	3	_atrip
audio	6	29	1710	3	_audio
auric	7	45	2172	3	_auric
auris	5	53	3152	3	_auris
baalim	10	3	847	3	baalim
baboo	9	43	1950	3	ba_boo
baddie	10	41	1403	3	baddie
baggie	10	29	1219	3	baggie
bagnios	10	3	607	3	bagnios
bagwig	13	4	308	3	bagwig
bail	6	50	4280	3	ba__il
bailie	8	38	1836	3	bailie
bairn	7	75	1553	3	bair_n
bairns	8	67	1087	3	bairns
bait	6	65	5600	3	ba__it
baldric	12	16	640	3	baldric
bambino	13	3	647	3	bambino
bamboo	12	3	1001	3	bamboo
banco	9	40	1939	3	ba_nco
bandit	9	38	2113	3	bandit
bandito	10	37	1004	3	bandito
bani	6	53	3495	3	ba_ni_
banjo	14	38	1244	3	ba_njo
bankit	12	36	1704	3	bankit
bar	5	80	7055	3	ba_r__
barb	8	52	4006	3	ba_r_b
barbal	10	40	1666	3	barbal
barbaric	14	4	636	3	barbaric
barbe	9	53	2828	3	ba_rbe
barbed	11	51	2131	3	barbed
barbel	10	43	1707	3	barbel
barber	10	44	1932	3	barber
barbes	10	45	2623	3	barbes
barbet	10	44	2788	3	barbet
barbies	11	45	1959	3	barbies
barbing	12	37	1699	3	barbing
barbs	9	59	2819	3	ba_rbs
barbut	10	46	1700	3	barbut
barca	9	13	1943	3	ba_rca
barcas	10	10	1660	3	barcas
bard	7	56	4886	3	ba_r_d
barde	8	53	3077	3	ba_rde
barded	10	54	2642	3	barded
bardes	9	50	2693	3	bardes
barding	11	38	2289	3	barding
bards	8	71	3964	3	ba_rds
bare	6	54	6052	3	ba_r_e
bared	8	51	4448	3	ba_red
barefit	12	4	972	3	barefit
barege	9	47	1354	3	barege
barely	11	47	1679	3	barely
barer	7	45	3580	3	ba_rer
bares	7	54	5713	3	ba_res
barest	8	53	2769	3	barest
barf	9	58	4440	3	ba_r_f
barfed	12	54	1638	3	barfed
barfing	13	46	1509	3	barfing
barfly	14	33	965	3	barfly
barfs	10	48	2600	3	ba_rfs
bargain	10	7	906	3	bargain
barge	8	56	3102	3	ba_rge
barged	10	58	2264	3	barged
bargee	9	46	2444	3	bargee
barges	9	45	2825	3	barges
barging	11	40	1848	3	barging
barhop	13	31	964	3	barhop
baring	9	51	3585	3	baring
barite	8	42	2481	3	barite
barium	10	3	1351	3	barium
bark	10	62	4215	3	ba_r_k
barked	13	50	2731	3	barked
barker	12	48	2286	3	barker
barkier	13	38	1448	3	barkier
barking	14	47	2418	3	barking
barks	11	57	3581	3	ba_rks
barky	14	57	2161	3	ba_rky
barley	11	51	1676	3	barley
barlow	11	29	1142	3	barlow
barm	8	67	3960	3	ba_r_m
barmaid	12	3	819	3	barmaid
barman	10	35	1970	3	barman
barmen	10	54	1853	3	barmen
barmier	11	43	1304	3	barmier
barms	9	61	2846	3	ba_rms
barmy	12	52	1876	3	ba_rmy
barn	6	64	4464	3	ba_r_n
barned	9	56	2358	3	barned
barney	11	53	1445	3	barney
barnier	9	32	1367	3	barnier
barning	10	43	2035	3	barning
barns	7	63	3514	3	ba_rns
barny	10	58	2173	3	ba_rny
baron	7	81	3124	3	ba_ron
barong	9	60	1582	3	barong
barons	8	50	2538	3	barons
barony	11	59	1530	3	barony
barque	17	23	955	3	barque
barrack	15	3	825	3	barrack
barrage	10	7	1084	3	barrage
barranco	12	4	494	3	barranco
barrator	10	4	840	3	barrator
barrels	9	45	1436	3	barrels
barrens	9	44	1432	3	barrens
barretor	10	4	671	3	barretor
barrets	9	49	1710	3	barrets
barricado	14	5	304	3	barri~~cad~~o
barriers	10	43	1188	3	barriers
barrooms	12	3	789	3	barrooms
barrows	12	34	1168	3	barrows
bars	6	65	6409	3	ba_r_s
barter	8	55	2537	3	barter
barye	10	50	2149	3	ba_rye
baryes	11	62	1850	3	baryes
baryon	11	12	1161	3	baryon
baryta	11	43	1029	3	baryta
baryte	11	53	1288	3	baryte
barytic	14	3	782	3	barytic
baryton	12	4	600	3	baryton
basic	9	62	2052	3	ba_sic
basil	7	51	2227	3	ba_sil
basin	7	50	2692	3	ba_sin
basion	8	43	1585	3	ba_sion
basis	7	54	2986	3	ba_sis
bassi	7	70	1932	3	bassi_
basso	7	60	1728	3	ba_sso
bastion	9	3	1247	3	bastion
batik	11	6	1473	3	ba_tik
battik	12	3	809	3	battik
bawdric	15	16	458	3	bawdric
bawtie	11	38	1214	3	bawtie
bayamo	13	3	560	3	bayamo
bazoo	16	38	1567	3	ba_zoo
bedrid	10	3	994	3	bedrid
begrim	11	11	833	3	begrim
berlin	8	31	1637	3	berlin
berried	10	37	1404	3	berried
berries	9	44	2355	3	berries
berry	10	45	2176	3	berr_y
bio	5	78	4607	3	b___io
birdie	9	40	1378	3	birdie
birkie	12	41	1013	3	birkie
biro	6	61	3120	3	b_ir_o
birr	6	60	2235	3	birr__
birred	9	47	1320	3	birred
birring	10	37	1306	3	birring
birrs	7	49	1710	3	birr_s
bizarro	18	4	333	3	bizarr_o
boric	9	80	2422	3	b_oric
borrow	11	43	1072	3	borrow
borzoi	17	3	662	3	borzoi
braid	8	58	2226	3	b_raid
brail	7	55	2555	3	b_rail
brain	7	62	2938	3	b_rain
brasil	8	7	1386	3	brasil
bravi	10	47	1575	3	bravi_
bravo	10	52	1434	3	b_ravo
brazil	17	7	962	3	brazil
brie	6	58	3790	3	b__rie
brig	7	65	2803	3	b__rig
brim	8	56	2937	3	b__rim
brin	6	70	3819	3	b__rin
brios	7	47	2572	3	b__rios
bris	6	55	3961	3	b__ris
brit	6	63	5015	3	b__rit
bro	5	62	3660	3	b__r_o
broil	7	49	1822	3	b_roil
bromo	9	52	1720	3	b_romo
broo	6	51	2982	3	b__roo
brr	5	69	2192	3	b_rr__
brrr	6	53	1229	3	b_rr_r
bruin	7	58	1833	3	b_ruin
bruit	7	61	2672	3	b_ruit
burdie	9	36	1502	3	burdie
burgoo	9	3	893	3	burgoo
burin	7	56	2606	3	b_urin
burnie	8	37	1541	3	burnie
burr	6	56	3123	3	burr__
burred	9	58	2072	3	burred
burrer	8	37	1847	3	burrer
burrier	9	36	1354	3	burrier
burring	10	40	1699	3	burring
burritos	10	4	447	3	burritos
burros	8	51	1499	3	burros
burrow	11	46	1080	3	burrow
burrs	7	49	2565	3	burr_s
burry	10	52	2156	3	burr_y
byrnie	11	34	857	3	byrnie
capric	12	4	1179	3	capric
capris	10	4	1507	3	capris
carbo	9	49	2384	3	ca_rbo
cardia	9	9	1637	3	cardia
cargo	8	53	2207	3	ca_rgo
carlin	8	44	2182	3	carlin
carnie	8	44	2109	3	carnie
carpi	9	43	1939	3	carpi_
carr	6	54	3470	3	carr__
carrel	8	47	1863	3	carrel
carried	10	37	1715	3	carried
carrier	9	36	1958	3	carrier
carries	9	43	2801	3	carries
carriole	10	8	986	3	carriole
carrions	10	3	1244	3	carrions
carrom	10	5	1340	3	carrom
carrot	8	4	2312	3	carrot
carrs	7	57	3085	3	carr_s
carry	10	58	2378	3	carr_y
carryon	12	3	703	3	carryon
charro	11	42	1295	3	charr_o
cirri	7	7	1072	3	cirri_
corrie	8	36	2121	3	corrie
curio	7	42	2120	3	_curio
currie	8	43	1725	3	currie
daimio	9	3	746	3	daimio
danio	6	3	1978	3	da_nio
daric	8	56	2311	3	da_ric
darkie	11	37	1401	3	darkie
derris	7	36	1527	3	derris
durrie	7	37	1325	3	durrie
earring	8	35	1901	3	earring
earwig	10	11	470	3	earwig
fabric	13	3	783	3	fabric
faerie	9	35	1468	3	faerie
farci	10	59	1931	3	farci_
farcie	11	48	1647	3	farcie
faro	7	61	3692	3	fa_r_o
farrago	11	4	492	3	farrago
farrier	10	35	1488	3	farrier
farrow	12	30	997	3	farrow
ferric	11	3	999	3	ferric
forrit	9	19	1662	3	forrit
garlic	9	3	1004	3	garlic
garni	6	3	1570	3	garni_
garred	8	52	1740	3	garred
garret	7	44	2655	3	garret
garring	9	31	1671	3	garring
garrison	9	4	398	3	garrison
garron	7	31	1349	3	garron
gharri	10	38	616	3	gharri_
gharris	11	30	643	3	gharris
hairdo	10	3	643	3	hairdo
harmin	11	31	1739	3	harmin
harpin	11	36	1438	3	harpin
harried	11	38	1553	3	harried
harrier	10	44	1775	3	harrier
harries	10	35	2549	3	harries
harrow	12	26	1077	3	harrow
harry	11	53	2295	3	harr_y
horrid	10	3	1155	3	horrid
iatric	8	3	1215	3	iatric
jarrah	16	3	668	3	jarrah
jarred	14	46	1325	3	jarred
jarring	15	36	1319	3	jarring
jerrid	14	25	914	3	jerrid
karmic	14	3	811	3	karmic
karoo	9	25	1958	3	ka_roo
karroos	11	3	931	3	karroos
kauri	9	38	1184	3	kauri_
kauris	10	36	1152	3	kauris
kerria	10	33	991	3	kerria
laari	5	44	1571	3	laari_
largo	6	53	1978	3	la_rgo
lari	4	58	3915	3	la_ri_
laris	5	47	3746	3	la_ris
larrup	8	3	571	3	larrup
latria	6	23	1358	3	latria
macro	9	47	1817	3	macr_o
margin	9	40	1684	3	margin
maria	7	50	3288	3	ma_ria
marlin	8	42	2090	3	marlin
marram	10	3	1388	3	marram
marrano	9	3	942	3	marrano
marred	9	54	2104	3	marred
marrer	8	37	1667	3	marrer
married	10	47	1530	3	married
marrier	9	38	1752	3	marrier
marries	9	38	2528	3	marries
marring	10	33	1954	3	marring
marron	8	37	1754	3	marron
marrow	11	28	1260	3	marrow
marry	10	48	2169	3	marr_y
martin	8	41	2252	3	martin
matrix	15	3	983	3	matrix
morrion	9	5	900	3	morrion
morris	8	38	1472	3	morris
morro	7	32	1695	3	morr_o
narco	7	67	1824	3	na_rco
naric	7	68	2417	3	na_ric
naris	5	57	3529	3	na_ris
narrow	9	26	914	3	narrow
orris	5	45	1655	3	_orris
padri	8	58	1516	3	padri_
paramo	10	26	1464	3	paramo
pardi	8	57	2395	3	pardi_
pardie	9	60	2144	3	pardie
pareo	7	46	3260	3	pa_reo
pargo	8	67	2372	3	pa_rgo
paris	7	51	4594	3	pa_ris
parr	6	57	3115	3	parr__
parral	8	55	1753	3	parral
parred	9	50	2407	3	parred
parrel	8	45	1598	3	parrel
parried	10	36	1572	3	parried
parrier	9	37	1765	3	parrier
parries	9	39	2584	3	parries
parring	10	32	2206	3	parring
parrot	8	3	2066	3	parrot
parrs	7	59	2867	3	parr_s
parry	10	53	2375	3	parr_y
parvis	11	61	1480	3	parvis
parvo	10	77	1918	3	pa_rvo
patio	7	44	2635	3	pa_tio
patriot	9	3	1453	3	patriot
pernio	8	5	1314	3	pernio
radio	6	49	2249	3	ra_dio
ratio	5	52	2758	3	ra_tio
sargo	6	54	2441	3	sa_rgo
sari	4	54	4404	3	sa_ri_
sarin	5	52	3925	3	sa_rin
saris	5	45	4495	3	sa_ris
tardo	6	53	2110	3	ta_rdo
taro	4	68	4691	3	ta_r_o
tarre	5	58	2563	3	tarr_e
tarred	7	47	2028	3	tarred
tarres	6	47	2304	3	tarres
tarried	8	39	1413	3	tarried
tarrier	7	43	2317	3	tarrier
tarries	7	33	2426	3	tarries
tarring	8	33	1830	3	tarring
tarry	8	54	2251	3	tarr_y
tarsi	5	52	2217	3	tarsi_
tarsia	6	55	1427	3	tarsia
territ	6	34	2137	3	territ
torrid	7	3	1185	3	torrid
trio	4	52	3334	3	__trio
urari	5	46	1996	3	urari_
uraris	6	38	1727	3	uraris
varia	8	58	2420	3	va_ria
varix	15	43	1350	3	va_rix
vibrio	11	3	622	3	vibrio
warred	10	40	1984	3	warred
warren	9	50	1285	3	warren
warring	11	37	1797	3	warring
warriors	11	3	536	3	warriors
worrit	9	23	1331	3	worrit
yarrow	12	28	793	3	yarrow

Search took 9 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.203	880251.2
2	DLD Change Limit	112716	397	8.250	13662.5
3	Display Results	397	397	0.250	1588.0
	(SQL Overall)	178691	397	8.703	20532.1