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

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

319 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
farrow	12	30	998	(None)
arrow	8	34	1489	1	_arrow
barrow	11	45	1277	1	barrow
farrows	13	25	979	1	farrows
furrow	12	42	774	1	furrow
harrow	12	26	1078	1	harrow
marrow	11	28	1261	1	marrow
narrow	9	26	915	1	narrow
yarrow	12	28	794	1	yarrow
arrows	9	28	1349	2	_arrows
arrowy	12	28	828	2	_arrowy
barlow	11	29	1143	2	barlow
barrows	12	34	1169	2	barrows
borrow	11	43	1073	2	borrow
burrow	11	46	1081	2	burrow
carrom	10	5	1340	2	carrom
carrot	8	4	2312	2	carrot
fallow	12	47	1385	2	fallow
faro	7	61	3692	2	fa_ro_
faros	8	55	3202	2	fa_ros
farrowed	15	4	530	2	farrowed
frow	10	64	2505	2	f__row
furrows	13	32	779	2	furrows
furrowy	16	38	447	2	furrowy
garron	7	31	1349	2	garron
harrows	13	26	1104	2	harrows
karroo	10	4	1002	2	karroo
marron	8	37	1754	2	marron
marrows	12	29	1183	2	marrows
marrowy	15	23	609	2	marrowy
morrow	11	35	1009	2	morrow
narrows	10	25	885	2	narrows
parrot	8	3	2066	2	parrot
sorrow	9	33	944	2	sorrow
sparrow	12	3	427	2	sparrow
yarrows	13	27	786	2	yarrows
aarrgh	10	78	630	3	aarrgh
aero	4	54	3534	3	_aero_
aglow	9	47	1197	3	_aglow
allow	8	54	2066	3	_allow
alow	7	53	2859	3	_a_low
apron	7	3	1883	3	_apron
arbor	7	48	1811	3	_arbor
arco	6	83	3154	3	_arco_
ardor	6	46	1786	3	_ardor
argol	6	53	1726	3	_argol
argon	6	55	2059	3	_argon
argot	6	77	2865	3	_argot
armor	7	51	1806	3	_armor
arras	5	56	2614	3	_arras
array	8	63	1715	3	_array
arris	5	68	2468	3	_arris
arroba	8	9	866	3	_arroba
arrowed	11	4	813	3	_arrowed
arroyo	9	3	696	3	_arroyo
arson	5	51	1883	3	_arson
arvo	7	60	2343	3	_arvo_
arvos	8	60	1567	3	_arvos
avow	10	78	1646	3	_a_vow
barhop	13	31	964	3	barhop
barlows	12	25	998	3	barlows
baron	7	81	3124	3	ba_ron
barre	7	59	2955	3	barr_e
barred	9	57	2580	3	barred
barrel	8	45	1788	3	barrel
barren	8	53	1762	3	barren
barres	8	44	2755	3	barres
barret	8	49	3049	3	barret
barrio	8	3	1258	3	barrio
barrios	9	3	1078	3	barrios
barroom	11	3	938	3	barroom
baryon	11	12	1161	3	baryon
borrows	12	34	926	3	borrows
brow	9	72	2844	3	__brow
burro	7	50	1849	3	burro_
burros	8	51	1499	3	burros
burrows	12	39	910	3	burrows
cahow	13	51	1094	3	ca_how
callow	11	47	1466	3	callow
carbo	9	49	2384	3	carbo_
carbon	10	49	1904	3	carbon
carbos	10	51	2226	3	carbos
carboy	13	49	1418	3	carboy
cardon	9	41	2085	3	cardon
cargo	8	53	2207	3	cargo_
cargos	9	46	1918	3	cargos
carhop	13	36	1076	3	carhop
carob	9	53	2522	3	ca_rob
carol	7	51	2861	3	ca_rol
carom	9	50	2556	3	ca_rom
carr	6	54	3470	3	carr__
carrel	8	47	1863	3	carrel
carrion	9	3	1267	3	carrion
carroch	14	3	709	3	carroch
carroms	11	5	1240	3	carroms
carrots	9	7	1462	3	carrots
carroty	12	4	894	3	carroty
carrs	7	57	3085	3	carr_s
carry	10	58	2378	3	carr_y
carryon	12	3	703	3	carryon
carton	8	45	2266	3	carton
cartop	10	42	1356	3	cartop
charro	11	42	1296	3	charro_
charros	12	43	1215	3	charros
cornrow	12	4	560	3	cornrow
crow	9	64	2813	3	__crow
dacron	9	43	1069	3	dacron
eardrop	10	6	522	3	eardrop
error	5	37	1223	3	_error
escrow	11	3	591	3	escrow
fabric	13	3	783	3	fabric
factor	11	9	1146	3	factor
fado	8	72	2647	3	fa_do_
fados	9	56	2073	3	fa_dos
faerie	9	35	1468	3	faerie
faery	11	60	1548	3	faer_y
faggot	11	3	905	3	faggot
fagot	9	3	2340	3	fa_got
fair	7	63	3252	3	fair__
faired	10	59	1577	3	faired
fairer	9	52	1206	3	fairer
fairly	12	56	1001	3	fairly
fairs	8	58	2544	3	fair_s
fairy	11	53	1828	3	fair_y
falcon	11	3	1029	3	falcon
fallows	13	37	1397	3	fallows
fandom	12	21	1089	3	fandom
fanion	9	45	1432	3	fanion
fano	7	58	3169	3	fa_no_
fanon	8	46	1901	3	fa_non
fanos	8	59	2650	3	fa_nos
fantod	10	20	1003	3	fantod
fantom	11	21	1080	3	fantom
far	6	77	6260	3	fa_r__
farad	9	57	2068	3	fa_rad
farads	10	47	1327	3	farads
farce	10	49	2532	3	fa_rce
farced	12	52	1653	3	farced
farcer	11	50	1608	3	farcer
farces	11	52	2332	3	farces
farci	10	59	1931	3	fa_rci
farcie	11	48	1647	3	farcie
farcy	13	52	1709	3	fa_rcy
fard	8	56	3906	3	fa_r_d
farded	11	45	1895	3	farded
fardel	10	47	1259	3	fardel
fards	9	66	2984	3	fa_rds
fare	7	63	5446	3	fa_r_e
farebox	19	4	382	3	farebox
fared	9	58	4234	3	fa_red
farer	8	67	3314	3	fa_rer
farers	9	59	2405	3	farers
fares	8	58	5287	3	fa_res
farfal	12	34	1019	3	farfal
farfel	12	43	1043	3	farfel
farina	9	46	1823	3	farina
faring	10	52	3128	3	faring
farl	7	63	3855	3	fa_r_l
farle	8	69	2924	3	fa_rle
farles	9	60	2578	3	farles
farls	8	57	3111	3	fa_rls
farm	9	59	3454	3	fa_r_m
farmed	12	51	1766	3	farmed
farmer	11	50	1738	3	farmer
farms	10	63	2496	3	fa_rms
farrago	11	4	492	3	farrago
farrier	10	35	1489	3	farrier
farrowing	16	4	587	3	farrow~~ing~~
fart	7	68	6056	3	fa_r_t
farted	10	51	2178	3	farted
farts	8	83	3684	3	fa_rts
fathom	14	3	747	3	fathom
fatso	8	51	1349	3	fatso_
fatsos	9	38	942	3	fatsos
favor	11	47	1245	3	fa_vor
favors	12	42	1140	3	favors
fellow	12	37	1274	3	fellow
ferrel	9	28	1020	3	ferrel
ferret	9	30	2117	3	ferret
ferric	11	3	999	3	ferric
ferrous	10	4	980	3	ferrous
ferrum	11	4	745	3	ferrum
ferry	11	60	2080	3	ferr_y
fervor	12	3	564	3	fervor
firry	11	57	1353	3	firr_y
flow	10	59	2492	3	f__low
fogbow	15	4	478	3	fogbow
follow	12	40	1035	3	follow
fordo	9	72	1865	3	fordo_
forgo	9	44	1833	3	forgo_
forgot	10	43	1813	3	forgot
formol	11	29	1033	3	formol
forrit	9	19	1662	3	forrit
fro	6	55	3064	3	f__ro_
froe	7	53	2999	3	f__roe
frog	8	56	2436	3	f__rog
from	9	69	2392	3	f__rom
frore	8	62	1880	3	f_rore
frown	11	54	1597	3	f__rown
frows	11	66	2310	3	f__rows
furor	8	3	1239	3	f_uror
furore	9	4	1001	3	furore
furors	9	3	1095	3	furors
furred	10	45	1443	3	furred
furrowed	15	6	385	3	furrowed
furrower	14	6	404	3	furrower
furry	11	67	1928	3	furr_y
garcon	9	29	1248	3	garcon
garred	8	52	1741	3	garred
garret	7	44	2656	3	garret
garrons	8	27	1346	3	garrons
garrote	8	5	1011	3	garrote
grow	8	61	2730	3	__grow
hadron	10	29	1375	3	hadron
hallow	12	48	1832	3	hallow
harbor	11	4	1072	3	harbor
harlot	9	44	2280	3	harlot
harrowed	15	5	628	3	harrowed
harrower	14	4	637	3	harrower
harry	11	53	2295	3	harr_y
haymow	17	7	368	3	haymow
horror	9	8	872	3	horror
jargon	14	4	882	3	jargon
jarrah	16	3	669	3	jarrah
jarred	14	46	1325	3	jarred
karoo	9	25	1959	3	ka_roo
karoos	10	24	1581	3	karoos
karroos	11	3	931	3	karroos
ladron	7	34	1332	3	ladron
lardon	7	44	1506	3	lardon
largo	6	53	1978	3	largo_
largos	7	48	1506	3	largos
larrup	8	3	571	3	larrup
macro	9	47	1817	3	macro_
macron	10	36	1567	3	macron
macros	10	40	1701	3	macros
mallow	11	40	1474	3	mallow
marmot	10	3	1875	3	marmot
maroon	8	31	1820	3	maroon
marram	10	3	1389	3	marram
marred	9	54	2104	3	marred
marrer	8	37	1667	3	marrer
marrons	9	32	1697	3	marrons
marrowed	14	4	599	3	marrowed
marry	10	48	2169	3	marr_y
matron	8	39	1831	3	matron
mirror	8	4	800	3	mirror
morro	7	32	1695	3	morro_
morros	8	37	1467	3	morros
morrows	12	31	872	3	morrows
narco	7	67	1824	3	narco_
narcos	8	67	1420	3	narcos
narrowed	12	3	523	3	narrowed
narrower	11	4	507	3	narrower
narrowly	14	4	291	3	narrowly
natron	6	41	1602	3	natron
outrow	9	3	1118	3	outrow
pardon	9	46	1873	3	pardon
pareo	7	46	3260	3	pareo_
pareos	8	70	2377	3	pareos
pargo	8	67	2372	3	pargo_
pargos	9	57	1904	3	pargos
parlor	8	3	1268	3	parlor
parol	7	48	2627	3	pa_rol
parr	6	57	3115	3	parr__
parral	8	55	1754	3	parral
parred	9	50	2407	3	parred
parrel	8	45	1598	3	parrel
parrots	9	3	1274	3	parrots
parroty	12	4	786	3	parroty
parrs	7	59	2867	3	parr_s
parry	10	53	2375	3	parr_y
parson	8	38	1790	3	parson
parton	8	47	2099	3	parton
parvo	10	77	1918	3	parvo_
parvos	11	66	1475	3	parvos
patrol	8	32	1302	3	patrol
patron	8	40	1804	3	patron
perron	8	32	1662	3	perron
prow	9	70	3038	3	__prow
pyrrol	11	3	627	3	pyrrol
ramrod	9	3	683	3	ramrod
regrow	10	30	988	3	regrow
row	6	74	5367	3	___row
safrol	9	3	728	3	safrol
sallow	9	43	1575	3	sallow
sargo	6	54	2441	3	sargo_
sargos	7	43	1827	3	sargos
sarod	6	53	2587	3	sa_rod
saros	5	52	3806	3	sa_ros
sartor	6	3	1388	3	sartor
serow	8	67	2044	3	_serow
sorrows	10	27	840	3	sorrows
sparrows	13	4	481	3	sparrows
strow	8	89	2057	3	_strow
tallow	9	37	1420	3	tallow
tardo	6	53	2110	3	tardo_
taro	4	68	4691	3	ta_ro_
taroc	7	57	2164	3	ta_roc
tarok	9	79	2107	3	ta_rok
taros	5	56	4082	3	ta_ros
tarot	5	59	4393	3	ta_rot
tarpon	8	28	1280	3	tarpon
tarre	5	58	2563	3	tarr_e
tarred	7	47	2028	3	tarred
tarres	6	47	2304	3	tarres
tarry	8	54	2251	3	tarr_y
terror	6	38	1173	3	terror
throw	11	87	1973	3	_throw
trow	7	80	3142	3	__trow
upgrow	12	3	427	3	upgrow
vagrom	12	3	594	3	vagrom
varoom	11	4	1141	3	varoom
vrow	10	58	1747	3	__vrow
wallow	12	39	1351	3	wallow
warred	10	40	1985	3	warred
warren	9	50	1286	3	warren
warrior	10	4	536	3	warrior
warsaw	12	3	620	3	warsaw

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	112716	0.436	409841.7
2	DLD Change Limit	112716	319	5.766	19548.4
3	Display Results	319	319	0.110	2900.0
	(SQL Overall)	178691	319	6.312	28309.7