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

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

315 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
horror	9	8	872	(None)
horrors	10	7	869	1	horrors
borrow	11	43	1072	2	borrow
error	5	37	1223	2	_error
harbor	11	4	1072	2	harbor
harrow	12	26	1077	2	harrow
honor	8	57	1862	2	ho_nor
horrid	10	3	1156	2	horrid
hotrod	10	4	880	2	hotrod
mirror	8	4	800	2	mirror
morro	7	32	1695	2	morro_
morros	8	37	1467	2	morros
morrow	11	35	1009	2	morrow
sordor	7	3	1022	2	sordor
sorrow	9	33	944	2	sorrow
terror	6	38	1173	2	terror
torpor	8	3	919	2	torpor
abhorrer	13	4	340	3	abhorrer
arbor	7	48	1811	3	_arbor
ardor	6	46	1786	3	_ardor
armor	7	51	1805	3	_armor
arrow	8	34	1488	3	_arrow
barrow	11	45	1276	3	barrow
boor	6	61	3068	3	bo__or
border	9	44	1997	3	border
borer	7	51	3127	3	bo_rer
boron	7	67	2714	3	bo_ron
borrower	13	8	483	3	borrower
borrows	12	34	925	3	borrows
borzoi	17	3	662	3	borzoi
brrr	6	53	1229	3	_brr_r
burrer	8	37	1847	3	burrer
burro	7	50	1849	3	burro_
burros	8	51	1499	3	burros
burrow	11	46	1080	3	burrow
carrom	10	5	1340	3	carrom
carrot	8	4	2312	3	carrot
charro	11	42	1295	3	charro_
charros	12	43	1214	3	charros
chorion	12	3	1177	3	chorion
churro	11	44	835	3	churro_
churros	12	42	758	3	churros
color	7	61	2374	3	co_lor
condor	9	46	1697	3	condor
corder	9	43	2288	3	corder
cordon	9	50	1729	3	cordon
corer	7	55	3887	3	co_rer
corker	12	47	2085	3	corker
corner	8	46	2562	3	corner
cornrow	12	4	560	3	cornrow
corpora	11	3	935	3	corpora
corral	8	36	1625	3	corral
corridor	11	4	503	3	corridor
corrie	8	36	2123	3	corrie
corrode	10	13	1057	3	corrode
corrody	13	13	614	3	corrody
cruor	7	3	1045	3	_cruor
cursor	8	41	1029	3	cursor
dobro	8	44	1221	3	dobro_
dobros	9	39	1023	3	dobros
doctor	9	3	899	3	doctor
dolor	6	76	1796	3	do_lor
donor	6	44	1819	3	do_nor
door	5	69	2851	3	do__or
dormer	9	44	1590	3	dormer
dorper	9	43	1457	3	dorper
dorr	5	66	2772	3	do_r_r
dorrs	6	55	2059	3	dorr_s
dorser	7	48	1918	3	dorser
dourer	7	42	1527	3	dourer
errors	6	33	1131	3	_errors
farrow	12	30	997	3	farrow
fervor	12	3	564	3	fervor
foetor	9	3	956	3	foetor
forbore	12	24	967	3	forbore
forcer	11	49	1734	3	forcer
fordo	9	72	1865	3	fordo_
forger	10	48	2077	3	forger
forgo	9	44	1833	3	forgo_
forgoer	11	3	769	3	forgoer
forgot	10	43	1813	3	forgot
forker	13	47	1790	3	forker
forlorn	10	9	642	3	forlorn
former	11	42	2140	3	former
formol	11	29	1033	3	formol
forrit	9	19	1662	3	forrit
forworn	13	10	779	3	forworn
furor	8	3	1239	3	_furor
furrow	12	42	774	3	furrow
garron	7	31	1349	3	garron
gorger	8	61	1698	3	gorger
gorgon	8	3	1024	3	gorgon
gorier	7	37	1937	3	gorier
hadron	10	29	1375	3	hadron
harbors	12	4	1241	3	harbors
harbour	12	4	705	3	harbour
harder	10	50	2240	3	harder
harlot	9	44	2280	3	harlot
harmer	11	47	1955	3	harmer
harper	11	50	1840	3	harper
harrier	10	44	1775	3	harrier
harrower	14	4	636	3	harrower
harrows	13	26	1103	3	harrows
harry	11	53	2295	3	harr_y
havior	12	4	820	3	havior
hearer	9	43	2364	3	hearer
hector	11	33	1265	3	hector
herder	10	45	1646	3	herder
hereof	12	32	1237	3	hereof
hereon	9	39	1436	3	hereon
heriot	9	4	2234	3	heriot
heritor	10	3	1056	3	heritor
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
hirer	8	54	2312	3	h_irer
hoar	7	67	2916	3	ho__ar
hoard	9	49	1831	3	hoar_d
hoarder	11	32	923	3	hoarder
hoards	10	49	1262	3	hoards
hoarier	10	42	1174	3	hoarier
hoars	8	59	2555	3	hoar_s
hoarse	9	44	1132	3	hoarse
hoarser	10	38	839	3	hoarser
hoary	11	45	1676	3	hoar_y
hoaxer	16	34	856	3	hoaxer
hobber	13	41	1463	3	hobber
hobnob	13	3	513	3	hobnob
hobo	9	70	2608	3	ho_bo_
hobos	10	63	2135	3	ho_bos
hocker	15	51	1856	3	hocker
hoer	7	65	3398	3	ho__er
hoers	8	57	2492	3	hoer_s
hogger	11	46	1508	3	hogger
hokier	13	42	1403	3	hokier
holder	10	46	1965	3	holder
holier	9	49	2162	3	holier
holler	9	35	2061	3	holler
hollo	8	48	2216	3	hollo_
holloa	9	49	1482	3	holloa
holloo	9	44	1525	3	holloo
hollos	9	53	2063	3	hollos
hollow	12	42	1266	3	hollow
homer	10	58	2845	3	ho_mer
homier	11	64	1699	3	homier
hommos	13	12	850	3	hommos
homo	9	61	2647	3	ho_mo_
homos	10	59	2178	3	ho_mos
honer	8	53	3209	3	ho_ner
honker	13	41	1746	3	honker
honorer	10	3	967	3	honorer
honors	9	48	1679	3	honors
honour	9	47	1086	3	honour
hood	8	51	3233	3	ho__od
hoodoo	10	10	998	3	hoodoo
hoof	10	60	3658	3	ho__of
hoofer	12	40	1495	3	hoofer
hook	11	61	3328	3	ho__ok
hooker	13	48	2017	3	hooker
hoop	9	61	2998	3	ho__op
hooper	11	45	1831	3	hooper
hoopoe	11	9	1123	3	hoopoe
hoopoo	11	9	875	3	hoopoo
hoorah	12	44	1111	3	hoorah
hooray	12	30	1137	3	hooray
hoot	7	57	5210	3	ho__ot
hooter	9	41	2393	3	hooter
hoover	12	43	1443	3	hoover
hoper	10	58	2914	3	ho_per
hopper	13	42	1848	3	hopper
hora	7	61	3656	3	ho_r_a
horah	11	79	2205	3	ho_rah
horahs	12	63	1387	3	horahs
horal	8	63	2868	3	ho_ral
horary	12	3	1038	3	horary
horas	8	63	3310	3	ho_ras
horde	9	46	2305	3	ho_rde
horded	11	54	2048	3	horded
hordes	10	49	2163	3	hordes
horizon	19	5	576	3	horizon
hormone	12	4	1050	3	hormone
horn	7	67	3561	3	ho_r_n
horned	10	57	1870	3	horned
hornet	9	49	2643	3	hornet
hornier	10	30	1246	3	hornier
horns	8	61	2533	3	ho_rns
hornworm	16	4	525	3	hornworm
hornwort	14	4	779	3	hornwort
horny	11	56	1962	3	ho_rny
horrent	10	3	1355	3	horrent
horrider	12	3	653	3	horrider
horrify	16	3	502	3	horrify
horse	8	61	3265	3	ho_rse
horsed	10	53	2108	3	horsed
horses	9	47	2934	3	horses
horsey	12	51	1540	3	horsey
horsier	10	30	1324	3	horsier
horst	8	58	3351	3	ho_rst
horste	9	48	1741	3	horste
horsts	9	58	1751	3	horsts
horsy	11	63	1839	3	ho_rsy
hoser	8	115	2976	3	ho_ser
hosier	9	42	1961	3	hosier
hotbox	18	3	570	3	hotbox
hotdog	11	3	480	3	hotdog
hotrods	11	4	828	3	hotrods
hotter	9	47	2008	3	hotter
hour	7	58	2731	3	ho__ur
houri	8	59	1525	3	hour_i
houris	9	45	1458	3	houris
hourly	12	36	962	3	hourly
hours	8	54	2239	3	hour_s
houser	9	53	2228	3	houser
hover	11	55	2413	3	ho_ver
hoverer	13	31	982	3	hoverer
howler	12	35	1431	3	howler
humor	10	11	1051	3	h_umor
hurler	9	47	1722	3	hurler
hurrah	12	36	918	3	hurrah
hurray	12	45	991	3	hurray
hurrier	10	34	1294	3	hurrier
hurry	11	49	1718	3	hurr_y
hurter	9	39	1585	3	hurter
hydro	12	25	942	3	hydro_
hydros	13	27	936	3	hydros
juror	12	3	956	3	_juror
karroo	10	4	1001	3	karroo
kouroi	10	3	651	3	kouroi
kouros	10	3	918	3	kouros
kronor	10	41	723	3	kronor
lorry	8	63	1567	3	lorr_y
marrer	8	37	1667	3	marrer
marron	8	37	1754	3	marron
marrow	11	28	1260	3	marrow
mirrors	9	3	862	3	mirrors
moor	6	66	2855	3	mo__or
morion	8	62	1773	3	morion
moron	7	69	2542	3	mo_ron
morrion	9	5	900	3	morrion
morris	8	38	1473	3	morris
morrows	12	31	872	3	morrows
mortar	8	38	1204	3	mortar
motor	7	53	1729	3	mo_tor
narrow	9	26	914	3	narrow
odor	5	57	1809	3	_o_dor
orator	6	3	1453	3	_orator
order	6	50	1936	3	_order
ordo	5	46	2235	3	_ordo_
ordos	6	52	1620	3	_ordos
orlon	5	4	1500	3	_orlon
orlop	7	4	1090	3	_orlop
ormer	7	52	1837	3	_ormer
orra	4	61	2072	3	_orr_a
orrery	9	3	678	3	_orrery
orris	5	45	1655	3	_orris
orzo	13	45	1678	3	_orzo_
orzos	14	33	1125	3	_orzos
parlor	8	3	1267	3	parlor
parrot	8	3	2066	3	parrot
perron	8	32	1662	3	perron
pogrom	11	3	859	3	pogrom
poor	6	56	3022	3	po__or
poorer	8	26	1399	3	poorer
porker	12	49	1754	3	porker
porno	7	51	2065	3	porno_
pornos	8	50	1525	3	pornos
porter	8	42	2441	3	porter
pourer	8	45	1604	3	pourer
prior	7	43	1617	3	_prior
pyrrol	11	3	627	3	pyrrol
roarer	6	39	1433	3	roarer
rotor	5	55	1973	3	ro_tor
sartor	6	3	1388	3	sartor
shnorrer	11	4	352	3	shnorrer
shorter	10	35	1550	3	shorter
soarer	6	45	2224	3	soarer
sopor	7	40	1649	3	so_por
sordors	8	3	1001	3	sordors
sorer	5	62	3659	3	so_rer
sorgo	6	47	1972	3	sorgo_
sorgos	7	45	1466	3	sorgos
sorner	6	47	2039	3	sorner
sorrel	6	4	1355	3	sorrel
sorrier	7	23	1373	3	sorrier
sorrower	11	6	504	3	sorrower
sorrows	10	27	840	3	sorrows
sorry	8	46	1825	3	sorr_y
sorter	6	44	2509	3	sorter
sourer	6	36	2021	3	sourer
termor	8	44	1251	3	termor
terrors	7	31	1221	3	terrors
thoro	8	62	1787	3	tho_ro_
thoron	9	47	1390	3	tho_ron
torero	6	3	1320	3	torero_
toreros	7	3	1134	3	toreros
toro	4	80	4568	3	to_ro_
toros	5	43	3619	3	to_ros
torot	5	61	3994	3	to_rot
torpors	9	3	938	3	torpors
torr	4	56	3090	3	to_r_r
torrid	7	3	1185	3	torrid
torrs	5	39	2356	3	torr_s
torso	5	69	2214	3	torso_
torsos	6	48	1573	3	torsos
tourer	6	41	1507	3	tourer
turgor	7	3	686	3	turgor
warrior	10	4	536	3	warrior
worker	13	47	1511	3	worker
wormer	11	45	1491	3	wormer
worrier	10	23	1168	3	worrier
worrit	9	23	1331	3	worrit
worry	11	61	1433	3	worr_y
worser	9	51	1752	3	worser
yarrow	12	28	793	3	yarrow

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.390	458182.1
2	DLD Change Limit	112716	315	5.346	21084.2
3	Display Results	315	315	0.093	3387.1
	(SQL Overall)	178691	315	5.829	30655.5