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

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

328 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
barrows	12	34	1168	(None)
arrows	9	28	1348	1	_arrows
barlows	12	25	997	1	barlows
barrow	11	45	1276	1	barrow_
borrows	12	34	925	1	borrows
burrows	12	39	909	1	burrows
farrows	13	25	978	1	farrows
harrows	13	26	1103	1	harrows
marrows	12	29	1182	1	marrows
narrows	10	25	884	1	narrows
yarrows	13	27	785	1	yarrows
arrow	8	34	1488	2	_arrow_
arrowy	12	28	827	2	_arrowy
barhops	14	28	811	2	barhops
barlow	11	29	1142	2	barlow_
barons	8	50	2538	2	ba_rons
barrels	9	45	1436	2	barrels
barrens	9	44	1432	2	barrens
barres	8	44	2754	2	barr_es
barrets	9	49	1710	2	barrets
barrios	9	3	1077	2	barrios
barroom	11	3	937	2	barroom
barrooms	12	3	789	2	barrooms
baryons	12	10	1047	2	baryons
borrow	11	43	1072	2	borrow_
brows	10	54	2598	2	b__rows
burros	8	51	1499	2	burro_s
burrow	11	46	1080	2	burrow_
carroms	11	5	1240	2	carroms
carrots	9	7	1462	2	carrots
farrow	12	30	997	2	farrow_
furrows	13	32	779	2	furrows
garrons	8	27	1346	2	garrons
harrow	12	26	1077	2	harrow_
karroos	11	3	931	2	karroos
marrons	9	32	1697	2	marrons
marrow	11	28	1260	2	marrow_
marrowy	15	23	608	2	marrowy
morrows	12	31	872	2	morrows
narrow	9	26	914	2	narrow_
parrots	9	3	1274	2	parrots
sorrows	10	27	840	2	sorrows
sparrows	13	4	480	2	sparrows
yarrow	12	28	793	2	yarrow_
across	8	3	1264	3	_across
allows	9	45	1768	3	_allows
aprons	8	3	1699	3	_aprons
arbors	8	47	1788	3	_arbors
ardors	7	44	1687	3	_ardors
argols	7	45	1461	3	_argols
argons	7	50	1820	3	_argons
argots	7	41	1603	3	_argots
armors	8	50	1781	3	_armors
arras	5	56	2613	3	_arr_as
arrays	9	53	1168	3	_arrays
arris	5	68	2468	3	_arr_is
arroba	8	9	866	3	_arroba
arrobas	9	6	921	3	_arrobas
arrowed	11	4	810	3	_arrowed
arroyo	9	3	696	3	_arroyo
arroyos	10	3	653	3	_arroyos
arsons	6	39	1721	3	_arsons
arvos	8	60	1566	3	_arvo_s
aurous	6	41	1926	3	_aurous
avows	11	49	1098	3	_a_vows
babools	11	31	945	3	babools
baboons	11	32	1108	3	baboons
baboos	10	35	1701	3	ba_boos
bacons	10	49	1758	3	ba_cons
bailors	9	32	1241	3	bailors
bairns	8	67	1087	3	bair_ns
balboas	11	37	1007	3	balboas
ballons	9	39	1696	3	ballons
ballots	9	41	1603	3	ballots
bamboos	13	4	875	3	bamboos
bancos	10	47	1389	3	banco_s
bandogs	11	3	836	3	bandogs
banjoes	16	31	731	3	banjoes
banjos	15	37	889	3	banjo_s
barbarous	13	4	562	3	barbarous
barbels	11	45	1443	3	barbels
barbers	11	43	1750	3	barbers
barbes	10	45	2623	3	ba_rbes
barbets	11	49	1584	3	barbets
barbies	11	45	1959	3	barbies
barbs	9	59	2819	3	ba_r_bs
barbuts	11	43	984	3	barbuts
barcas	10	10	1660	3	ba_rcas
bardes	9	50	2693	3	ba_rdes
bards	8	71	3964	3	ba_r_ds
bareges	10	52	1203	3	bareges
bares	7	54	5713	3	ba_r_es
barfs	10	48	2600	3	ba_r_fs
bargees	10	54	1587	3	bargees
barges	9	45	2825	3	ba_rges
barhop	13	31	964	3	barho_p
barites	9	43	2233	3	barites
bariums	11	3	914	3	bariums
barkers	13	43	1851	3	barkers
barks	11	57	3581	3	ba_r_ks
barless	9	43	1700	3	barless
barleys	12	50	1184	3	barleys
barms	9	61	2846	3	ba_r_ms
barneys	12	56	956	3	barneys
barns	7	63	3514	3	ba_r_ns
baron	7	81	3124	3	ba_ro_n
barong	9	60	1582	3	ba_rong
barongs	10	53	1083	3	barongs
barony	11	59	1530	3	ba_rony
barques	18	25	964	3	barques
barrack	15	3	825	3	barrack
barracks	16	3	688	3	barracks
barrage	10	7	1084	3	barrage
barrages	11	7	1108	3	barrages
barrators	11	4	839	3	barrators
barre	7	59	2954	3	barr__e
barred	9	57	2579	3	barr_ed
barrel	8	45	1787	3	barr_el
barren	8	53	1761	3	barr_en
barret	8	49	3048	3	barr_et
barretors	11	4	624	3	barretors
barrier	9	40	1773	3	barrier
barriers	10	43	1188	3	barriers
barring	10	40	2159	3	barring
barrio	8	3	1257	3	barr_io
bars	6	65	6409	3	ba_r__s
barters	9	42	2303	3	barters
baryes	11	62	1850	3	ba_ryes
baryon	11	12	1161	3	baryo_n
barytas	12	37	828	3	barytas
barytes	12	46	1115	3	barytes
barytons	13	4	557	3	barytons
bashaws	15	34	771	3	bashaws
basions	9	42	1395	3	basions
bassos	8	53	1370	3	basso_s
batboys	14	6	583	3	batboys
batfowl	15	4	359	3	batfowl
batfowls	16	4	277	3	batfowls
bathos	11	62	1563	3	batho_s
batons	8	55	1942	3	ba_tons
baudrons	11	3	576	3	baudrons
bayous	11	4	1115	3	ba_yous
bazooms	20	28	538	3	bazooms
bazoos	17	32	1262	3	ba_zoos
becrowd	15	5	517	3	becrowd
becrowds	16	8	377	3	becrowds
bellows	12	43	1330	3	bellows
belows	11	46	1418	3	b_elows
berries	9	44	2355	3	berries
besnows	12	4	515	3	besnows
bestows	12	4	886	3	bestows
bestrows	13	3	704	3	bestrows
bicrons	11	34	1047	3	bicrons
billows	12	36	1129	3	billows
biros	7	53	2513	3	b_iro_s
birrs	7	49	1710	3	birr__s
bizarros	19	4	271	3	bizarro_s
blows	10	54	2383	3	b__lows
borons	8	55	2054	3	b_orons
borrowed	14	6	504	3	borrowed
borrower	13	8	483	3	borrower
borrowers	14	7	402	3	borrowers
borzois	18	3	583	3	borzois
bows	9	62	4286	3	b___ows
bowwows	14	5	412	3	bowwows
bravoes	12	41	853	3	bravoes
bravos	11	47	1139	3	bravo_s
braws	10	64	2519	3	b__raws
brews	10	56	1707	3	b__rews
brios	7	47	2572	3	b_rio_s
broods	9	54	1638	3	b_roods
brooks	12	58	1388	3	b_rooks
brooms	10	49	1587	3	b_rooms
broos	7	51	2641	3	b__roos
bros	6	56	3566	3	b__ro_s
brow	9	72	2844	3	b__row_
brown	10	56	1953	3	b__rown
browns	11	64	1563	3	b__rowns
browse	11	57	1385	3	b__rowse
burbots	11	6	867	3	burbots
burgoos	10	3	712	3	burgoos
burnous	9	3	882	3	burnous
burrers	9	38	1449	3	burrers
burro	7	50	1849	3	burro__
burrowed	14	4	444	3	burrowed
burrower	13	7	426	3	burrower
burrowers	14	8	349	3	burrowers
burrs	7	49	2565	3	burr__s
burtons	9	3	1085	3	burtons
cahows	14	39	912	3	ca_hows
carbons	11	54	1894	3	carbons
carbos	10	51	2226	3	carbo_s
carboys	14	47	1178	3	carboys
cardons	10	45	1993	3	cardons
cargoes	10	44	1522	3	cargoes
cargos	9	46	1918	3	cargo_s
carhops	14	32	970	3	carhops
carious	9	33	2028	3	carious
carobs	10	48	1810	3	ca_robs
carols	8	51	2498	3	ca_rols
caroms	10	56	1957	3	ca_roms
carrels	9	51	1730	3	carrels
carries	9	43	2801	3	carries
carrions	10	3	1245	3	carrions
carroch	14	3	709	3	carroch
carrom	10	5	1340	3	carro_m
carrot	8	4	2312	3	carro_t
carroty	12	4	894	3	carroty
carrs	7	57	3085	3	carr__s
carryons	13	3	710	3	carryons
cartons	9	41	2247	3	cartons
charros	12	43	1214	3	charro_s
cirrous	9	31	1106	3	cirrous
cornrows	13	4	531	3	cornrows
crows	10	57	2731	3	__crows
dacrons	10	32	1103	3	dacrons
eardrops	11	6	530	3	eardrops
errors	6	33	1131	3	_errors
escrows	12	3	580	3	escrows
fallows	13	37	1397	3	fallows
faros	8	55	3202	3	fa_ro_s
farrowed	15	4	528	3	farrowed
ferrous	10	4	979	3	ferrous
frows	11	66	2310	3	__frows
furrow	12	42	774	3	furrow_
furrowy	16	38	447	3	furrowy
gallows	11	35	1351	3	gallows
garcons	10	24	1164	3	garcons
garrets	8	44	1362	3	garrets
garron	7	31	1349	3	garro_n
garrote	8	5	1010	3	garrote
garrotes	9	6	936	3	garrotes
grows	9	55	2392	3	__grows
hadrons	11	33	1430	3	hadrons
hallows	13	44	1739	3	hallows
harbors	12	4	1241	3	harbors
harlots	10	34	1329	3	harlots
harries	10	35	2549	3	harries
harrowed	15	5	626	3	harrowed
harrower	14	4	636	3	harrower
harrowers	15	5	568	3	harrowers
haymows	18	8	381	3	haymows
horrors	10	7	869	3	horrors
jargons	15	5	820	3	jargons
jarrahs	17	3	545	3	jarrahs
karoos	10	24	1580	3	ka_roos
kaross	10	19	1001	3	ka_ross
karroo	10	4	1001	3	karro_o
ladrons	8	38	1319	3	ladrons
lardons	8	39	1449	3	lardons
largos	7	48	1506	3	largo_s
larrups	9	3	473	3	larrups
macrons	11	35	1489	3	macrons
macros	10	40	1701	3	macro_s
mallows	12	37	1432	3	mallows
marmots	11	3	1151	3	marmots
maroons	9	26	1555	3	maroons
marrams	11	3	1012	3	marrams
marrers	9	34	1431	3	marrers
marries	9	38	2528	3	marries
marron	8	37	1754	3	marro_n
marrowed	14	4	597	3	marrowed
matrons	9	35	1763	3	matrons
mirrors	9	3	862	3	mirrors
morros	8	37	1467	3	morro_s
morrow	11	35	1009	3	morrow_
narcos	8	67	1420	3	narco_s
narrowed	12	3	520	3	narrowed
narrower	11	4	506	3	narrower
narrowest	12	4	428	3	narrowest
narrowish	15	4	374	3	narrowish
narrowly	14	4	290	3	narrowly
natrons	7	32	1566	3	natrons
outrows	10	3	1140	3	outrows
pardons	10	38	1762	3	pardons
pareos	8	70	2377	3	pareo_s
pargos	9	57	1904	3	pargo_s
parlors	9	3	1291	3	parlors
parlous	9	4	1429	3	parlous
parols	8	47	2261	3	pa_rols
parous	8	40	2416	3	pa_rous
parrals	9	44	1457	3	parrals
parrels	9	47	1349	3	parrels
parries	9	39	2584	3	parries
parrot	8	3	2066	3	parro_t
parroty	12	4	786	3	parroty
parrs	7	59	2867	3	parr__s
parsons	9	35	1687	3	parsons
partons	9	46	2051	3	partons
parvos	11	66	1475	3	parvo_s
patrols	9	35	1351	3	patrols
patrons	9	38	1810	3	patrons
perrons	9	31	1548	3	perrons
prows	10	63	2701	3	__prows
pyrrols	12	3	540	3	pyrrols
ramrods	10	3	658	3	ramrods
regrows	11	26	915	3	regrows
rows	7	59	4175	3	___rows
safrols	10	3	686	3	safrols
sallows	10	39	1555	3	sallows
sarcous	9	3	1293	3	sarcous
sargos	7	43	1827	3	sargo_s
sarods	7	49	1857	3	sa_rods
saros	5	52	3806	3	sa_ro_s
sartors	7	3	1496	3	sartors
serows	9	60	1639	3	_serows
sorrow	9	33	944	3	sorrow_
sparrow	12	3	426	3	sparrow_
strows	9	67	1827	3	_strows
tallows	10	33	1374	3	tallows
tarocs	8	46	1566	3	ta_rocs
taroks	10	61	1528	3	ta_roks
taros	5	56	4082	3	ta_ro_s
tarots	6	64	2299	3	ta_rots
tarpons	9	26	1221	3	tarpons
tarres	6	47	2304	3	tarr_es
tarries	7	33	2426	3	tarries
terrors	7	31	1221	3	terrors
throws	12	97	1523	3	_throws
trows	8	88	2618	3	__trows
upgrows	13	3	432	3	upgrows
various	10	31	1310	3	various
varooms	12	4	888	3	varooms
vrows	11	61	1526	3	__vrows
wallows	13	36	1353	3	wallows
warrens	10	38	1089	3	warrens
warriors	11	3	536	3	warriors
warsaws	13	3	576	3	warsaws

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.140	1276364.3
2	DLD Change Limit	134027	328	6.220	21547.7
3	Display Results	328	328	0.126	2603.2
	(SQL Overall)	178691	328	6.486	27550.3