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

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

417 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
fjords	17	40	535	(None)
fiords	10	49	862	1	fiords
fjord	16	47	702	1	fjord_
fords	9	53	2818	1	f_ords
affords	14	3	502	2	affords
chords	12	52	1463	2	chords
cords	8	60	3062	2	_cords
fards	9	66	2984	2	f_ards
feods	9	95	1685	2	feo_ds
fiord	9	43	1334	2	fiord_
fjelds	17	41	447	2	fjelds
fjordic	20	4	238	2	fjordic
floods	10	45	1165	2	floods
floras	9	47	1569	2	floras
folds	9	52	2169	2	f_olds
fonds	9	58	2482	2	f_onds
foods	9	59	2416	2	f_oods
forbs	10	57	2080	2	f_orbs
ford	8	68	3549	2	f_ord_
fordo	9	72	1865	2	f_ordo
fores	8	58	4710	2	f_ores
forks	12	53	2468	2	f_orks
forms	10	53	2705	2	f_orms
forts	8	60	3445	2	f_orts
fronds	10	64	1234	2	fronds
lords	6	49	2350	2	_lords
sords	6	45	2780	2	_sords
swords	10	45	1080	2	swords
words	9	54	2507	2	_words
aborts	8	49	1618	3	aborts
accords	12	4	724	3	accords
acorns	8	50	1301	3	acorns
adores	7	44	2072	3	adores
adorns	7	42	1261	3	adorns
afford	13	4	649	3	afford_
agoras	7	6	1334	3	agoras
aholds	10	46	948	3	aholds
apods	8	63	1634	3	apo_ds
aroids	7	51	1822	3	aroids
avoids	10	44	1020	3	avoids
awards	10	71	1345	3	awards
bards	8	71	3964	3	_bards
beards	9	41	1667	3	beards
birds	8	54	2133	3	_birds
blonds	9	52	1334	3	blonds
bloods	9	46	1484	3	bloods
boards	9	46	1693	3	boards
bods	7	62	4471	3	_bo_ds
bolds	8	58	2528	3	_bolds
bonds	8	61	2684	3	_bonds
boors	7	43	2501	3	boor_s
boras	7	59	3830	3	_boras
bores	7	64	4825	3	_bores
borks	11	57	2770	3	_borks
borts	7	67	3545	3	_borts
broads	9	45	1515	3	broads
broods	9	54	1638	3	broods
burds	8	46	2606	3	_burds
bywords	16	3	428	3	bywords
cairds	9	64	1151	3	cairds
cards	8	51	3793	3	_cards
ceorls	8	4	816	3	ceorls
chards	12	51	1973	3	chards
chord	11	59	1726	3	chord_
chores	11	48	2802	3	chores
chorus	11	50	1477	3	chorus
clods	8	53	2086	3	clo_ds
clouds	9	46	1235	3	clouds
cods	7	68	4810	3	_co_ds
coeds	8	59	2016	3	_coeds
colds	8	57	2697	3	_colds
cord	7	67	4092	3	_cord_
cores	7	63	6185	3	_cores
corks	11	60	2827	3	_corks
corms	9	56	2622	3	_corms
corns	7	60	3476	3	_corns
corps	9	59	2704	3	_corps
cors	6	66	5644	3	_cor_s
crores	8	61	2116	3	crores
crowds	12	49	1076	3	crowds
curds	8	57	2561	3	_curds
doors	6	50	2213	3	door_s
dorks	10	57	2444	3	_dorks
dorms	8	57	2384	3	_dorms
dorps	8	54	1922	3	_dorps
dorrs	6	55	2059	3	_dorrs
dors	5	67	4760	3	_dor_s
droids	8	47	1258	3	droids
efforts	13	3	470	3	efforts
fads	8	69	3987	3	f__ads
fairs	8	58	2544	3	fair_s
farads	10	47	1327	3	farads
fard	8	56	3906	3	f_ard_
fares	8	58	5287	3	f_ares
farls	8	57	3111	3	f_arls
farms	10	63	2495	3	f_arms
faros	8	55	3202	3	f_aros
farts	8	83	3684	3	f_arts
faulds	10	43	896	3	faulds
favors	12	42	1140	3	favor_s
fears	8	48	2939	3	fear_s
fedoras	11	3	792	3	fedoras
feds	8	52	3431	3	f__eds
feeds	9	49	2114	3	f_eeds
felids	10	31	1162	3	felids
fends	9	63	2497	3	f_ends
feod	8	155	2300	3	feo_d_
feoffs	11	6	370	3	feoffs
feres	8	60	3818	3	f_eres
ferns	8	52	2008	3	f_erns
fetors	9	10	1447	3	fetor_s
feuds	9	59	1488	3	f_euds
fiars	8	67	2083	3	fiar_s
fibres	11	43	1212	3	fibres
fids	8	70	3473	3	f__ids
fields	10	42	1104	3	fields
fiends	10	41	1029	3	fiends
finds	9	54	2482	3	f_inds
fires	8	57	4075	3	f_ires
firms	10	52	1742	3	f_irms
firns	8	60	1854	3	f_irns
firs	7	66	3771	3	f_ir_s
fjeld	16	46	558	3	fjeld_
flares	9	45	2170	3	flares
flirs	8	55	1893	3	flir_s
flirts	9	54	1148	3	flirts
floats	9	68	1625	3	floats
flocks	15	47	1353	3	flocks
flocs	10	55	1923	3	flo_cs
floes	8	55	2814	3	flo_es
flogs	9	59	1996	3	flo_gs
flongs	10	50	1049	3	flongs
flood	9	52	1560	3	flood_
floors	9	41	1235	3	floors
flops	10	59	2014	3	flo_ps
flora	8	53	1710	3	flor_a
florae	9	47	1388	3	florae
floral	9	43	1381	3	floral
florals	10	42	1006	3	florals
floret	9	3	2112	3	floret
florets	10	3	985	3	florets
florid	10	3	1145	3	florid
florin	9	3	1265	3	florin
florins	10	3	1164	3	florins
florist	10	3	1424	3	florist
floss	8	51	1826	3	flo_ss
flotas	9	40	1300	3	flotas
flours	9	44	1405	3	flours
flouts	9	43	1527	3	flouts
flows	11	58	2236	3	flo_ws
fluids	10	34	942	3	fluids
fluorids	12	4	549	3	fluorids
fluors	9	43	1137	3	fluor_s
foals	8	57	2169	3	f_oals
foams	10	50	1795	3	f_oams
fobs	9	60	3427	3	f_o_bs
focus	10	58	1588	3	f_ocus
foes	7	65	4344	3	f_o_es
fogs	8	70	3500	3	f_o_gs
fohns	11	73	1078	3	f_ohns
foils	8	50	2581	3	f_oils
foins	8	55	2338	3	f_oins
fold	8	65	2894	3	f_old_
folks	12	60	1712	3	f_olks
fond	8	63	3095	3	f_ond_
fondu	9	60	1397	3	f_ondu
fondus	10	52	1094	3	f_ondus
fons	7	69	4389	3	f_o_ns
fonts	8	61	2475	3	f_onts
food	8	68	3057	3	f_ood_
fools	8	68	2420	3	f_ools
foots	8	55	2828	3	f_oots
fops	9	65	3268	3	f_o_ps
for	6	69	5207	3	f_or__
fora	7	59	3739	3	f_or_a
foram	10	51	2493	3	f_oram
forams	11	51	1591	3	f_orams
foray	11	50	2397	3	f_oray
forays	12	48	1300	3	f_orays
forb	9	71	3133	3	f_or_b
forbids	13	26	826	3	f_orbids
forby	13	53	1767	3	f_orby
force	10	53	2427	3	f_orce
forces	11	44	2213	3	f_orces
forded	11	50	2039	3	f_orded
fordid	11	35	1205	3	f_ordid
fordoes	11	3	1196	3	f_ordoes
fore	7	83	5147	3	f_or_e
foredo	10	5	1082	3	f_oredo
forest	9	49	2674	3	f_orest
forge	9	51	2694	3	f_orge
forges	10	50	2426	3	f_orges
forgo	9	44	1833	3	f_orgo
fork	11	59	3094	3	f_or_k
forky	15	61	1964	3	f_orky
form	9	58	3687	3	f_or_m
forme	10	52	2599	3	f_orme
formes	11	46	2371	3	f_ormes
fort	7	64	5644	3	f_or_t
forte	8	61	3146	3	f_orte
fortes	9	53	2718	3	f_ortes
forth	11	62	2267	3	f_orth
fortis	9	54	1861	3	f_ortis
forty	11	48	2427	3	f_orty
forum	10	83	1876	3	f_orum
forums	11	46	1184	3	f_orums
foss	7	64	3164	3	f_o_ss
fouls	8	72	2143	3	f_ouls
founds	10	48	1419	3	founds
fours	8	55	2149	3	f_ours
fowls	11	55	1889	3	f_owls
foxes	15	63	2109	3	f_oxes
foys	10	56	2829	3	f_o_ys
frauds	10	3	675	3	frauds
freres	9	47	1617	3	freres
frocks	15	41	1121	3	frocks
froes	8	61	2669	3	fro_es
frogs	9	62	2077	3	fro_gs
frond	9	53	1634	3	frond_
frons	8	61	2404	3	fro_ns
fronts	9	44	1579	3	fronts
frore	8	62	1880	3	fror_e
frosts	9	42	1462	3	frosts
froths	12	54	1144	3	froths
frowns	12	60	1139	3	frowns
frows	11	66	2310	3	fro_ws
fucoids	13	3	566	3	fucoids
fuds	8	65	2856	3	f__uds
funds	9	41	1925	3	f_unds
furls	8	53	2205	3	f_urls
furores	10	3	1003	3	furores
furors	9	3	1095	3	furors
furs	7	67	3504	3	f_ur_s
geoids	8	36	984	3	geoids
girds	7	48	1699	3	_girds
goads	7	70	2285	3	_goads
gods	6	54	3804	3	_go_ds
golds	7	54	2131	3	_golds
goods	7	51	2448	3	_goods
gores	6	57	4037	3	_gores
gorms	8	56	1959	3	_gorms
gorps	8	53	1699	3	_gorps
gourds	8	10	825	3	gourds
gowds	10	58	1404	3	_gowds
guards	8	46	1157	3	guards
hards	9	64	3565	3	_hards
herds	9	64	2468	3	_herds
hoards	10	49	1262	3	hoards
hods	8	72	3986	3	_ho_ds
holds	9	46	2324	3	_holds
hoods	9	51	2408	3	_hoods
horas	8	63	3310	3	_horas
horde	9	46	2305	3	_horde
hordes	10	49	2163	3	_hordes
horns	8	61	2533	3	_horns
hurds	9	52	1907	3	_hurds
hyoids	13	7	767	3	hyoids
ixoras	13	3	719	3	ixoras
jarls	12	61	2096	3	_jarls
jars	11	73	3835	3	_jar_s
jerids	14	28	1094	3	_jerids
jerks	16	65	1489	3	_jerks
jobs	13	65	2943	3	_jo_bs
jocks	18	51	1808	3	_jocks
joes	11	66	3589	3	_jo_es
joeys	15	51	804	3	_joeys
jogs	12	71	2933	3	_jo_gs
johns	15	39	871	3	_johns
joins	12	58	1841	3	_joins
jokes	16	54	2333	3	_jokes
joles	12	52	3083	3	_joles
jolts	12	50	1888	3	_jolts
jones	12	50	2818	3	_jones
joram	14	58	1698	3	_joram
jorams	15	48	1053	3	_jorams
jordan	14	6	806	3	_jordan
jordans	15	6	683	3	_jordans
jorum	14	55	1374	3	_jorum
jorums	15	40	809	3	_jorums
joss	11	59	2559	3	_jo_ss
jotas	12	57	1744	3	_jotas
jots	11	63	3614	3	_jo_ts
jouks	16	56	1234	3	_jouks
jowls	15	62	1452	3	_jowls
jows	14	66	3209	3	_jo_ws
joys	14	66	2466	3	_jo_ys
koras	9	59	2711	3	_koras
kors	8	59	3301	3	_kor_s
lairds	7	47	1161	3	lairds
lards	6	53	3186	3	_lards
liards	7	52	1261	3	liards
loads	6	53	2337	3	_loads
loids	6	62	2070	3	_loids
lord	5	50	3208	3	_lord_
lores	5	50	4540	3	_lores
loris	5	53	2915	3	_loris
majors	15	45	1109	3	major_s
milords	10	11	785	3	milords
mods	7	79	4505	3	_mo_ds
molds	8	53	2483	3	_molds
moods	8	52	2462	3	_moods
moors	7	49	2314	3	moor_s
moras	7	64	3877	3	_moras
mores	7	62	4964	3	_mores
morns	7	55	2744	3	_morns
mors	6	59	5006	3	_mor_s
morts	7	55	3356	3	_morts
nards	6	59	2846	3	_nards
nerds	6	57	1925	3	_nerds
nods	5	58	3822	3	_no_ds
noris	5	49	2827	3	_noris
norms	7	60	1931	3	_norms
nurds	6	55	1852	3	_nurds
odds	6	89	1992	3	__odds
odors	6	45	1428	3	odor_s
ods	4	75	4621	3	__o_ds
olds	5	59	2657	3	__olds
orbs	6	66	2625	3	__orbs
orcs	6	70	2543	3	__orcs
ordo	5	46	2235	3	__ordo
ordos	6	52	1620	3	__ordos
ores	4	60	5668	3	__ores
ors	3	57	5011	3	__or_s
orts	4	65	3833	3	__orts
ouds	5	64	3010	3	__ouds
ovoids	10	45	692	3	ovoids
oxfords	18	4	289	3	oxfords
pards	8	56	3433	3	_pards
plods	8	57	1929	3	plo_ds
pods	7	65	4015	3	_po_ds
ponds	8	53	2340	3	_ponds
poods	8	51	2475	3	_poods
pooris	8	39	1684	3	pooris
pores	7	58	4903	3	_pores
porks	11	51	2414	3	_porks
porns	7	55	2734	3	_porns
ports	7	59	3459	3	_ports
prods	8	55	2355	3	pro_ds
quods	15	46	1022	3	quo_ds
records	10	52	1392	3	records
rewords	11	54	1397	3	rewords
roads	6	65	2362	3	_roads
rods	5	64	4206	3	_ro_ds
roods	6	51	2528	3	_roods
sards	6	47	3618	3	_sards
sarods	7	49	1857	3	sarods
scolds	9	50	1123	3	scolds
scores	8	47	2592	3	scores
scorns	8	57	1302	3	scorns
scrods	9	41	1160	3	scrods
shards	10	43	1917	3	shards
sherds	10	56	1472	3	sherds
shores	9	48	3041	3	shores
shorls	9	45	1620	3	shorls
shorts	9	53	2174	3	shorts
skorts	10	42	1130	3	skorts
sloids	7	37	1269	3	sloids
slojds	14	34	547	3	slojds
sloyds	10	34	629	3	sloyds
snoods	7	43	1245	3	snoods
snores	6	43	2432	3	snores
snorts	6	41	1650	3	snorts
sods	5	49	4021	3	_so_ds
soras	5	50	4101	3	_soras
sorbs	7	50	2210	3	_sorbs
sord	5	62	3720	3	_sord_
sores	5	54	5428	3	_sores
sorns	5	50	2842	3	_sorns
sorts	5	45	3666	3	_sorts
sorus	5	45	2758	3	_sorus
spores	8	47	2661	3	spores
sports	8	46	1918	3	sports
stores	6	55	3366	3	stores
storks	10	61	1595	3	storks
storms	8	58	1463	3	storms
surds	6	56	2466	3	_surds
swards	10	54	1513	3	swards
sword	9	52	1411	3	sword_
thirds	10	43	860	3	thirds
thorns	9	53	1410	3	thorns
thorps	11	36	1089	3	thorps
toads	6	56	2107	3	_toads
tods	5	61	4184	3	_to_ds
toras	5	55	4037	3	_toras
torcs	7	51	2376	3	_torcs
tores	5	53	5267	3	_tores
toros	5	43	3619	3	_toros
torrs	5	39	2356	3	_torrs
tors	4	61	5738	3	_tor_s
torts	5	61	3812	3	_torts
torus	5	43	2976	3	_torus
tsores	6	51	1366	3	tsores
tsoris	6	34	1119	3	tsoris
turds	6	50	2169	3	_turds
urds	5	59	2242	3	__urds
voids	9	54	1467	3	_voids
wards	9	77	3440	3	_wards
weirds	10	47	805	3	weirds
whores	12	56	1710	3	whores
whorls	12	44	1016	3	whorls
whorts	12	51	1143	3	whorts
woads	9	48	1844	3	_woads
wolds	9	54	2018	3	_wolds
woods	9	57	2303	3	_woods
word	8	98	3200	3	_word_
wordy	12	69	1616	3	_wordy
works	12	56	2190	3	_works
worlds	10	56	873	3	_worlds
worms	10	53	2076	3	_worms
worts	8	86	3118	3	_worts
yairds	10	44	802	3	yairds
yards	9	53	2461	3	_yards
yirds	9	66	1251	3	_yirds
yods	8	65	3118	3	_yo_ds
yores	8	50	3132	3	_yores
zooids	16	3	709	3	zooids
zoris	14	53	2001	3	_zoris

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.156	1145455.1
2	DLD Change Limit	112716	417	5.923	19030.2
3	Display Results	417	417	0.123	3390.2
	(SQL Overall)	178691	417	6.202	28811.8