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

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

331 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
harrow	12	26	1077	(None)
arrow	8	34	1488	1	_arrow
barrow	11	45	1276	1	barrow
farrow	12	30	997	1	farrow
harrows	13	26	1103	1	harrows
marrow	11	28	1260	1	marrow
narrow	9	26	914	1	narrow
yarrow	12	28	793	1	yarrow
arrows	9	28	1348	2	_arrows
arrowy	12	28	827	2	_arrowy
barlow	11	29	1142	2	barlow
barrows	12	34	1168	2	barrows
borrow	11	43	1072	2	borrow
burrow	11	46	1080	2	burrow
carrom	10	5	1340	2	carrom
carrot	8	4	2312	2	carrot
charro	11	42	1295	2	charro_
charros	12	43	1214	2	charros
farrows	13	25	978	2	farrows
furrow	12	42	774	2	furrow
garron	7	31	1349	2	garron
hadron	10	29	1375	2	hadron
hallow	12	48	1832	2	hallow
harbor	11	4	1072	2	harbor
harlot	9	44	2280	2	harlot
harrowed	15	5	626	2	harrowed
harrower	14	4	636	2	harrower
harry	11	53	2295	2	harr_y
haymow	17	7	368	2	haymow
horror	9	8	872	2	horror
karroo	10	4	1001	2	karroo
marron	8	37	1754	2	marron
marrows	12	29	1182	2	marrows
marrowy	15	23	608	2	marrowy
morrow	11	35	1009	2	morrow
narrows	10	25	884	2	narrows
parrot	8	3	2066	2	parrot
sorrow	9	33	944	2	sorrow
sparrow	12	3	426	2	sparrow
yarrows	13	27	785	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	1805	3	_armor
arras	5	56	2613	3	_arras
array	8	63	1714	3	_array
arris	5	68	2468	3	_arris
arroba	8	9	866	3	_arroba
arrowed	11	4	810	3	_arrowed
arroyo	9	3	696	3	_arroyo
arson	5	51	1883	3	_arson
arvo	7	60	2343	3	_arvo_
arvos	8	60	1566	3	_arvos
avow	10	78	1646	3	_a_vow
barhop	13	31	964	3	barhop
barlows	12	25	997	3	barlows
baron	7	81	3124	3	ba_ron
barre	7	59	2954	3	barr_e
barred	9	57	2579	3	barred
barrel	8	45	1787	3	barrel
barren	8	53	1761	3	barren
barres	8	44	2754	3	barres
barret	8	49	3048	3	barret
barrio	8	3	1257	3	barrio
barrios	9	3	1077	3	barrios
barroom	11	3	937	3	barroom
baryon	11	12	1161	3	baryon
borrows	12	34	925	3	borrows
brow	9	72	2844	3	__brow
burro	7	50	1849	3	burro_
burros	8	51	1499	3	burros
burrows	12	39	909	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
chariot	12	3	1621	3	chariot
charpoy	17	3	571	3	charpoy
charr	10	48	2178	3	charr__
charred	13	46	1448	3	charred
charrs	11	52	1919	3	charr_s
charry	14	50	1211	3	charr_y
churro	11	44	835	3	churro_
churros	12	42	758	3	churros
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
fallow	12	47	1385	3	fallow
faro	7	61	3692	3	fa_ro_
faros	8	55	3202	3	fa_ros
farrowed	15	4	528	3	farrowed
frow	10	64	2505	3	__frow
furrows	13	32	779	3	furrows
furrowy	16	38	447	3	furrowy
garcon	9	29	1248	3	garcon
garred	8	52	1740	3	garred
garret	7	44	2655	3	garret
garrons	8	27	1346	3	garrons
garrote	8	5	1010	3	garrote
gharri	10	38	616	3	gharr_i
gharris	11	30	643	3	gharris
gharry	13	54	627	3	gharr_y
grow	8	61	2730	3	__grow
haar	7	73	2349	3	haar__
haars	8	56	2047	3	haar_s
haboob	13	7	788	3	haboob
hadrons	11	33	1430	3	hadrons
haeres	9	40	1703	3	haeres
hagdon	11	8	828	3	hagdon
hagrode	12	3	644	3	hagrode
hair	7	63	3014	3	hair__
hairdo	10	3	643	3	hairdo
hairdos	11	3	682	3	hairdos
haired	10	51	1717	3	haired
hairs	8	62	2517	3	hair_s
hairy	11	53	1683	3	hair_y
hallo	8	51	2755	3	hallo_
halloa	9	49	1812	3	halloa
halloo	9	51	1897	3	halloo
hallos	9	54	2510	3	hallos
hallot	9	54	2678	3	hallot
hallows	13	44	1739	3	hallows
halo	7	64	3732	3	ha_lo_
halon	8	61	2486	3	ha_lon
halos	8	52	3025	3	ha_los
hansom	11	21	915	3	hansom
hao	6	72	5112	3	ha__o_
harass	9	3	1394	3	harass
harbors	12	4	1241	3	harbors
harbour	12	4	705	3	harbour
hard	8	54	4350	3	ha_r_d
harden	10	57	1853	3	harden
harder	10	50	2240	3	harder
hardly	13	51	1283	3	hardly
hards	9	64	3565	3	ha_rds
hardtop	13	4	505	3	hardtop
hardy	12	56	2206	3	ha_rdy
hare	7	62	5573	3	ha_r_e
hared	9	57	4218	3	ha_red
hareem	11	43	1206	3	hareem
harem	10	49	2445	3	ha_rem
harems	11	55	1382	3	harems
hares	8	62	5554	3	ha_res
haricot	12	3	1196	3	haricot
haring	10	42	3300	3	haring
hark	11	52	3739	3	ha_r_k
harked	14	54	2255	3	harked
harken	13	51	1634	3	harken
harks	12	63	3343	3	ha_rks
harl	7	57	4000	3	ha_r_l
harlots	10	34	1329	3	harlots
harls	8	56	3450	3	ha_rls
harm	9	56	3779	3	ha_r_m
harmed	12	52	1883	3	harmed
harmer	11	47	1955	3	harmer
harmin	11	31	1739	3	harmin
harmony	15	3	817	3	harmony
harms	10	68	2901	3	ha_rms
harp	9	61	3429	3	ha_r_p
harped	12	44	1840	3	harped
harper	11	50	1840	3	harper
harpin	11	36	1438	3	harpin
harpoon	12	3	831	3	harpoon
harps	10	59	2687	3	ha_rps
harpy	13	64	1821	3	ha_rpy
harried	11	38	1553	3	harried
harrier	10	44	1775	3	harrier
harries	10	35	2549	3	harries
harrowers	15	5	568	3	harrow~~ers~~
harrowing	16	4	643	3	harrow~~ing~~
harsh	11	64	1805	3	ha_rsh
hart	7	68	6577	3	ha_r_t
hartal	9	4	1547	3	hartal
harts	8	84	4159	3	ha_rts
hatbox	18	3	513	3	hatbox
hatred	10	48	1433	3	hatred
havior	12	4	820	3	havior
havoc	13	3	718	3	ha_voc
haw	9	71	5327	3	ha___w
haymows	18	8	381	3	haymows
hereof	12	32	1237	3	hereof
hereon	9	39	1436	3	hereon
heriot	9	4	2234	3	heriot
hero	7	46	3578	3	h_ero_
heron	8	50	2550	3	h_eron
heros	8	49	3086	3	h_eros
herry	11	49	2247	3	herr_y
hollow	12	42	1266	3	hollow
horrid	10	3	1156	3	horrid
horrors	10	7	869	3	horrors
hotrod	10	4	880	3	hotrod
how	9	72	5243	3	h___ow
hurrah	12	36	918	3	hurrah
hurray	12	45	991	3	hurray
hurry	11	49	1718	3	hurr_y
hydro	12	25	942	3	hydro_
hydros	13	27	936	3	hydros
jargon	14	4	882	3	jargon
jarrah	16	3	668	3	jarrah
jarred	14	46	1325	3	jarred
karoo	9	25	1958	3	ka_roo
karoos	10	24	1580	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	1874	3	marmot
maroon	8	31	1820	3	maroon
marram	10	3	1388	3	marram
marred	9	54	2104	3	marred
marrer	8	37	1667	3	marrer
marrons	9	32	1697	3	marrons
marrowed	14	4	597	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	520	3	narrowed
narrower	11	4	506	3	narrower
narrowly	14	4	290	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	1267	3	parlor
parol	7	48	2627	3	pa_rol
parr	6	57	3115	3	parr__
parral	8	55	1753	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
pharaoh	15	4	503	3	pharaoh
pharos	11	3	1206	3	pha_ros
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	1387	3	sartor
serow	8	67	2044	3	_serow
shadow	13	3	725	3	sha_dow
shallow	13	38	887	3	shallow
sorrows	10	27	840	3	sorrows
sparrows	13	4	480	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	1984	3	warred
warren	9	50	1285	3	warren
warrior	10	4	536	3	warrior
warsaw	12	3	619	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.140	1276364.3
2	DLD Change Limit	112716	331	5.750	19602.8
3	Display Results	331	331	0.093	3559.1
	(SQL Overall)	178691	331	5.983	29866.5