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

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

321 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
hazard	19	3	840	(None)
hazards	20	3	746	1	hazards
mazard	18	3	876	1	mazard
award	9	71	1804	2	_award
bayard	12	44	1166	2	bayard
bazar	16	38	1600	2	bazar_
bazars	17	46	1311	2	bazars
canard	9	3	1476	2	canard
gazar	15	46	1298	2	gazar_
gazars	16	48	1155	2	gazars
haar	7	73	2349	2	ha_ar_
haars	8	56	2047	2	ha_ars
haggard	13	37	718	2	haggard
halyard	14	7	697	2	halyard
hard	8	54	4350	2	h__ard
hayward	17	3	641	2	hayward
hazan	17	38	1361	2	haza_n
hazans	18	34	1165	2	hazans
hazarded	22	4	364	2	hazarded
hazarder	21	4	360	2	hazarder
hazed	18	52	2220	2	haz_ed
hazer	17	48	2023	2	hazer_
hazers	18	46	1595	2	hazers
heard	9	52	2275	2	h_eard
hoard	9	49	1831	2	h_oard
holard	10	4	1057	2	holard
izzard	15	13	524	2	izzard
lazar	14	41	1364	2	lazar_
lazars	15	38	1239	2	lazars
lizard	16	36	923	2	lizard
mazards	19	3	770	2	mazards
mazzard	18	4	446	2	mazzard
tabard	9	3	1333	2	tabard
vaward	13	49	872	2	vaward
vizard	19	45	885	2	vizard
wizard	19	37	771	2	wizard
aboard	9	3	1261	3	aboard
acari	7	50	2028	3	_acari
acarid	9	50	1706	3	_acarid
afar	7	67	2078	3	_afar_
afars	8	57	1651	3	_afars
afeard	10	5	826	3	afeard
agar	5	87	2641	3	_agar_
agars	6	61	2064	3	_agars
ahead	9	68	1705	3	ahea_d
ajar	11	62	1770	3	_ajar_
aland	6	55	2641	3	_aland
alar	4	63	4007	3	_alar_
alarm	7	66	2142	3	_alarm
alary	8	61	2344	3	_alary
apart	7	43	3067	3	_apart
awards	10	71	1345	3	_awards
aware	8	64	2002	3	_aware
azan	13	65	2178	3	_aza_n
azans	14	65	1688	3	_azans
azure	14	9	1148	3	_azure
baaed	8	52	1816	3	ba_aed
bard	7	56	4886	3	__bard
bastard	10	30	1242	3	bastard
bayards	13	37	968	3	bayards
bazaar	17	30	640	3	bazaar
bazaars	18	27	588	3	bazaars
beard	8	60	2496	3	_beard
biohazard	24	5	113	3	~~bio~~hazard
board	8	55	2300	3	_board
boyard	12	54	1128	3	boyard
briard	9	43	1129	3	briard
buzzard	18	4	427	3	buzzard
caird	8	57	1723	3	ca_ird
canards	10	3	1120	3	canards
canary	11	3	1469	3	canary
card	7	102	4587	3	__card
chadar	12	3	934	3	chadar_
chadars	13	3	827	3	chadars
chard	11	61	2474	3	_chard
chazan	20	26	913	3	chaza_n
chazans	21	26	812	3	chazans
coward	12	4	1167	3	coward
czar	15	60	1313	3	_czar_
czars	16	48	1291	3	_czars
damar	8	41	1773	3	damar_
damars	9	38	1499	3	damars
dastard	9	27	970	3	dastard
datary	10	3	1024	3	datary
dazed	16	59	1936	3	daz_ed
dotard	8	3	905	3	dotard
echard	12	4	922	3	echard
farad	9	57	2067	3	fara_d
fard	8	56	3906	3	__fard
fazed	18	62	2296	3	faz_ed
gabbard	13	3	655	3	gabbard
gazabo	18	3	483	3	gazabo
gazed	16	55	2033	3	gaz_ed
gazer	15	57	2007	3	gazer_
gazers	16	45	1629	3	gazers
gizzard	17	11	420	3	gizzard
guard	7	44	1554	3	_guard
haaf	10	62	2773	3	ha_a_f
haafs	11	57	1116	3	ha_afs
hacked	16	49	2351	3	hacked
had	7	76	5876	3	h__a_d
hadal	9	55	1812	3	hada_l
hadarim	13	11	742	3	hadarim
haded	10	52	2762	3	ha_ded
haed	8	63	3858	3	h__aed
haftara	13	13	609	3	haftara
hafted	13	47	1383	3	hafted
haggards	14	36	676	3	haggards
hagged	12	43	1770	3	hagged
haha	10	78	2106	3	haha__
hahas	11	71	1844	3	haha_s
hailed	10	41	2274	3	hailed
hair	7	63	3014	3	ha_ir_
hairdo	10	3	643	3	ha_irdo
haired	10	51	1717	3	haired
hairs	8	62	2517	3	ha_irs
hairy	11	53	1683	3	ha_iry
halal	8	56	2359	3	hala_l
halala	9	47	1509	3	halala
halals	9	50	1831	3	halals
halberd	13	3	604	3	halberd
haled	9	53	3582	3	ha_led
haler	8	50	3352	3	haler_
halers	9	49	2691	3	halers
haleru	9	42	1207	3	haleru
halid	9	44	2497	3	ha_lid
halliard	12	12	596	3	halliard
haloed	10	47	1759	3	haloed
haloid	10	43	1775	3	haloid
halted	10	50	1960	3	halted
halved	13	48	1390	3	halved
halyards	15	7	624	3	halyards
hamada	12	3	991	3	hamada
hamal	10	46	2310	3	hama_l
hamals	11	48	1681	3	hamals
hamate	11	33	1982	3	hamate
hamaul	11	42	1086	3	hamaul
hammed	14	41	1697	3	hammed
hamza	19	13	977	3	hamza__
hamzah	23	13	555	3	hamza_h
hamzahs	24	13	437	3	hamzahs
hamzas	20	11	901	3	hamza_s
hand	8	68	3370	3	h__and
handed	11	49	1998	3	handed
hangar	10	41	1450	3	hangar_
hangared	13	3	756	3	hangared
hangars	11	43	1348	3	hangars
hanged	11	42	2239	3	hanged
hanked	14	42	2060	3	hanked
hanted	10	41	2431	3	hanted
hapax	17	3	932	3	hapa_x
haphazard	27	5	154	3	~~hap~~hazard
happed	14	48	2010	3	happed
harass	9	3	1394	3	harass
hards	9	64	3565	3	h__ards
hardy	12	56	2206	3	h__ardy
hare	7	62	5573	3	h__are
hared	9	57	4218	3	ha_red
hark	11	52	3739	3	h__ark
harked	14	54	2255	3	harked
harl	7	57	4000	3	h__arl
harm	9	56	3779	3	h__arm
harmed	12	52	1883	3	harmed
harp	9	61	3428	3	h__arp
harped	12	44	1840	3	harped
harry	11	53	2295	3	ha_rry
hart	7	68	6577	3	h__art
hashed	13	60	2194	3	hashed
hasped	12	50	1444	3	hasped
hasted	10	51	2528	3	hasted
hatband	13	4	682	3	hatband
hated	9	57	3402	3	ha_ted
hater	8	50	3475	3	hater_
haters	9	49	3039	3	haters
hatred	10	48	1433	3	hatred
hatted	10	49	2151	3	hatted
hauled	10	44	1521	3	hauled
haulyard	15	8	322	3	haulyard
havarti	13	4	505	3	havarti
haver	11	51	2446	3	haver_
havered	14	40	1145	3	havered
havers	12	47	2148	3	havers
hawala	12	36	891	3	hawala
hawed	12	60	2542	3	ha_wed
hawked	17	47	1267	3	hawked
hayed	12	58	2201	3	ha_yed
hayer	11	46	2024	3	hayer_
hayers	12	44	1594	3	hayers
haywards	18	4	587	3	haywards
hazanim	21	6	460	3	hazanim
hazarders	22	4	302	3	hazard~~ers~~
hazarding	23	4	340	3	hazard~~ing~~
hazardous	22	4	310	3	hazard~~ous~~
haze	16	48	3339	3	haz__e
hazel	17	64	1481	3	haz_el
hazels	18	57	1008	3	hazels
hazes	17	49	2832	3	haz_es
hazier	18	47	1240	3	hazier
hazily	21	7	906	3	hazily
hazing	19	42	1855	3	hazing
hazmat	20	3	1226	3	hazmat
hazmats	21	3	660	3	hazmats
hazy	19	181	1919	3	haz__y
hazzan	17	23	680	3	hazzan
hazzans	18	21	578	3	hazzans
head	8	71	3717	3	h_ea_d
hear	7	61	4388	3	h_ear_
hears	8	67	3737	3	h_ears
heart	8	54	4074	3	h_eart
hegari	10	3	951	3	hegari
herald	10	3	1134	3	herald
herd	8	49	3306	3	h__erd
hexad	16	49	1062	3	hexa_d
hilar	8	54	1814	3	hilar_
hoar	7	67	2916	3	h_oar_
hoards	10	49	1262	3	h_oards
hoars	8	59	2554	3	h_oars
hoary	11	45	1676	3	h_oary
hodad	10	3	1135	3	hoda_d
holards	11	4	843	3	holards
horary	12	3	1038	3	horary
huzzaed	19	4	310	3	huzzaed
inward	10	3	1033	3	inward
izar	13	66	1601	3	_izar_
izars	14	51	1293	3	_izars
izzards	16	14	396	3	izzards
jazzed	22	41	629	3	jazzed
kabar	11	48	1555	3	kabar_
kabars	12	45	1395	3	kabars
laari	5	44	1571	3	la_ari
labara	8	37	1289	3	labara
laggard	10	34	762	3	laggard
lahar	8	31	1426	3	lahar_
lahars	9	40	1316	3	lahars
laird	6	54	1779	3	la_ird
laniard	8	6	852	3	laniard
lanyard	11	6	729	3	lanyard
lard	5	67	4200	3	__lard
lazaret	16	4	1178	3	lazaret
lazed	15	49	2584	3	laz_ed
lazied	16	46	1065	3	lazied
liard	6	54	1859	3	_liard
lizards	17	42	761	3	lizards
lyard	9	51	1321	3	_lyard
maar	6	60	2505	3	ma_ar_
maars	7	46	2163	3	ma_ars
makar	11	56	1497	3	makar_
makars	12	46	1263	3	makars
malar	7	64	2444	3	malar_
malars	8	50	2068	3	malars
mallard	10	3	1027	3	mallard
mansard	10	4	931	3	mansard
manward	13	4	909	3	manward
maraud	9	3	894	3	maraud
mazed	17	55	2387	3	maz_ed
mazer	16	57	2242	3	mazer_
mazers	17	39	1709	3	mazers
mazzards	19	4	394	3	mazzards
naiad	6	3	1340	3	naia_d
nard	5	66	3445	3	__nard
navaid	10	3	764	3	navaid
navar	8	39	1273	3	navar_
navars	9	28	1057	3	navars
onward	10	3	905	3	onward
pard	7	64	4132	3	__pard
pazazz	15	5	402	3	pazazz
petard	9	50	1380	3	petard
placard	12	3	678	3	placard
radar	6	13	1672	3	radar_
radars	7	13	1466	3	radars
razed	15	50	2798	3	raz_ed
razeed	16	37	1001	3	razeed
razer	14	48	2427	3	razer_
razers	15	49	1961	3	razers
razor	14	30	1260	3	razor_
razored	17	3	633	3	razored
razors	15	47	1165	3	razors
razzed	15	47	828	3	razzed
regard	8	52	1577	3	regard
retard	7	50	1893	3	retard
reward	10	60	1763	3	reward
ritard	7	48	1208	3	ritard
safari	9	11	1022	3	safari
saggard	10	35	895	3	saggard
salad	6	53	2183	3	sala_d
salary	9	5	1521	3	salary
samara	8	3	1385	3	samara
sard	5	53	4424	3	__sard
satara	6	3	1553	3	satara
seaward	11	4	817	3	seaward
shaird	10	28	870	3	sha_ird
shard	9	61	2596	3	_shard
shazam	20	4	660	3	shaza_m
sizar	14	52	1499	3	sizar_
sizars	15	48	1262	3	sizars
sward	9	42	2146	3	_sward
tabards	10	3	1038	3	tabards
talar	5	62	2538	3	talar_
talars	6	60	2168	3	talars
tamari	8	3	1338	3	tamari
tankard	12	6	726	3	tankard
tanyard	11	6	718	3	tanyard
tatar	5	61	2206	3	tatar_
tatars	6	46	1979	3	tatars
toward	10	3	1106	3	toward
tzar	13	63	1537	3	_tzar_
tzars	14	49	1427	3	_tzars
uakari	10	4	686	3	uakari
upward	12	14	716	3	upward
vagary	13	3	733	3	vagary
vanward	14	5	694	3	vanward
vawards	14	45	757	3	vawards
visard	10	39	1012	3	visard
vizards	20	37	726	3	vizards
ward	8	65	4225	3	__ward
wayward	17	3	605	3	wayward
weazand	20	4	361	3	weazand
wizards	20	32	640	3	wizards
yaird	9	61	1191	3	ya_ird
yard	8	56	3325	3	__yard
zarf	16	69	2912	3	__zarf

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.283	631417.0
2	DLD Change Limit	112716	321	7.686	14665.1
3	Display Results	321	321	0.110	2918.2
	(SQL Overall)	178691	321	8.079	22118.0