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

Here are the results of your fuzzy-string dictionary search for “fords” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

248 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
fords	9	53	2818	(None)
cords	8	60	3062	1	cords
fards	9	66	2984	1	fards
fiords	10	49	862	1	fiords
fjords	17	40	535	1	fjords
folds	9	52	2169	1	folds
fonds	9	58	2482	1	fonds
foods	9	59	2416	1	foods
forbs	10	57	2080	1	forbs
ford	8	68	3549	1	ford_
fordo	9	72	1865	1	fordo
fores	8	58	4710	1	fores
forks	12	53	2468	1	forks
forms	10	53	2705	1	forms
forts	8	60	3445	1	forts
lords	6	49	2350	1	lords
sords	6	45	2780	1	sords
words	9	54	2507	1	words
affords	14	3	502	2	affords
bards	8	71	3964	2	bards
birds	8	54	2133	2	birds
boards	9	46	1693	2	boards
bods	7	62	4471	2	bo_ds
bolds	8	58	2528	2	bolds
bonds	8	61	2684	2	bonds
boras	7	59	3830	2	boras
bores	7	64	4825	2	bores
borks	11	57	2770	2	borks
borts	7	67	3545	2	borts
burds	8	46	2606	2	burds
cards	8	51	3793	2	cards
chords	12	52	1463	2	chords
cods	7	68	4810	2	co_ds
coeds	8	59	2016	2	coeds
colds	8	57	2697	2	colds
cord	7	67	4092	2	cord_
cores	7	63	6185	2	cores
corks	11	60	2827	2	corks
corms	9	56	2622	2	corms
corns	7	60	3476	2	corns
corps	9	59	2704	2	corps
cors	6	66	5644	2	cor_s
curds	8	57	2561	2	curds
dorks	10	57	2444	2	dorks
dorms	8	57	2383	2	dorms
dorps	8	54	1922	2	dorps
dorrs	6	55	2059	2	dorrs
dors	5	67	4760	2	dor_s
fads	8	69	3987	2	f_ads
farads	10	47	1327	2	farads
fard	8	56	3906	2	fard_
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
feds	8	52	3431	2	f_eds
feeds	9	49	2114	2	feeds
fends	9	63	2497	2	fends
feods	9	95	1685	2	feods
feres	8	60	3818	2	feres
ferns	8	52	2008	2	ferns
feuds	9	59	1488	2	feuds
fids	8	70	3473	2	f_ids
finds	9	54	2482	2	finds
fiord	9	43	1334	2	fiord_
fires	8	57	4075	2	fires
firms	10	52	1742	2	firms
firns	8	60	1854	2	firns
firs	7	66	3771	2	fir_s
fjord	16	47	702	2	fjord_
floods	10	45	1165	2	floods
floras	9	47	1569	2	floras
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
fobs	9	60	3427	2	fo_bs
focus	10	58	1588	2	focus
foes	7	65	4344	2	fo_es
fogs	8	70	3500	2	fo_gs
fohns	11	73	1078	2	fohns
foils	8	50	2581	2	foils
foins	8	55	2338	2	foins
fold	8	65	2894	2	fold_
folks	12	60	1712	2	folks
fond	8	63	3095	2	fond_
fondu	9	60	1397	2	fondu
fondus	10	52	1094	2	fondus
fons	7	69	4389	2	fo_ns
fonts	8	61	2475	2	fonts
food	8	68	3057	2	food_
fools	8	68	2420	2	fools
foots	8	55	2828	2	foots
fops	9	65	3268	2	fo_ps
for	6	69	5207	2	for__
fora	7	59	3739	2	for_a
foram	10	51	2493	2	foram
forams	11	51	1591	2	forams
foray	11	50	2397	2	foray
forays	12	48	1300	2	forays
forb	9	71	3133	2	for_b
forbids	13	26	826	2	forbids
forby	13	53	1767	2	forby
force	10	53	2427	2	force
forces	11	44	2213	2	forces
forded	11	50	2039	2	forded
fordid	11	35	1205	2	fordid
fordoes	11	3	1196	2	fordoes
fore	7	83	5147	2	for_e
foredo	10	5	1082	2	foredo
forest	9	49	2674	2	forest
forge	9	51	2694	2	forge
forges	10	50	2426	2	forges
forgo	9	44	1833	2	forgo
fork	11	59	3094	2	for_k
forky	15	61	1964	2	forky
form	9	58	3687	2	for_m
forme	10	52	2599	2	forme
formes	11	46	2371	2	formes
fort	7	64	5644	2	for_t
forte	8	61	3146	2	forte
fortes	9	53	2718	2	fortes
forth	11	62	2267	2	forth
fortis	9	54	1861	2	fortis
forty	11	48	2427	2	forty
forum	10	83	1876	2	forum
forums	11	46	1184	2	forums
foss	7	64	3164	2	fo_ss
fouls	8	72	2143	2	fouls
founds	10	48	1419	2	founds
fours	8	55	2149	2	fours
fowls	11	55	1889	2	fowls
foxes	15	63	2109	2	foxes
foys	10	56	2829	2	fo_ys
froes	8	61	2669	2	froes
frogs	9	62	2077	2	frogs
fronds	10	64	1234	2	fronds
frons	8	61	2404	2	frons
frows	11	66	2310	2	frows
fuds	8	65	2856	2	f_uds
funds	9	41	1925	2	funds
furls	8	53	2205	2	furls
furs	7	67	3504	2	fur_s
girds	7	48	1699	2	girds
goads	7	70	2285	2	goads
gods	6	54	3804	2	go_ds
golds	7	54	2131	2	golds
goods	7	51	2448	2	goods
gores	6	57	4037	2	gores
gorms	8	56	1959	2	gorms
gorps	8	53	1699	2	gorps
gourds	8	10	825	2	gourds
gowds	10	58	1404	2	gowds
hards	9	64	3565	2	hards
herds	9	64	2468	2	herds
hoards	10	49	1262	2	hoards
hods	8	72	3986	2	ho_ds
holds	9	46	2324	2	holds
hoods	9	51	2408	2	hoods
horas	8	63	3309	2	horas
horde	9	46	2305	2	horde
hordes	10	49	2163	2	hordes
horns	8	61	2533	2	horns
hurds	9	52	1907	2	hurds
koras	9	59	2711	2	koras
kors	8	59	3301	2	kor_s
lards	6	53	3186	2	lards
loads	6	53	2337	2	loads
loids	6	62	2070	2	loids
lord	5	50	3208	2	lord_
lores	5	50	4540	2	lores
loris	5	53	2915	2	loris
mods	7	79	4505	2	mo_ds
molds	8	53	2483	2	molds
moods	8	52	2462	2	moods
moras	7	64	3876	2	moras
mores	7	62	4964	2	mores
morns	7	55	2744	2	morns
mors	6	59	5006	2	mor_s
morts	7	55	3356	2	morts
nards	6	59	2846	2	nards
nerds	6	57	1925	2	nerds
nods	5	58	3822	2	no_ds
noris	5	49	2827	2	noris
norms	7	60	1930	2	norms
nurds	6	55	1852	2	nurds
odds	6	89	1992	2	_odds
ods	4	75	4621	2	_o_ds
olds	5	59	2657	2	_olds
orbs	6	66	2625	2	_orbs
orcs	6	70	2543	2	_orcs
ordo	5	46	2235	2	_ordo
ordos	6	52	1620	2	_ordos
ores	4	60	5668	2	_ores
ors	3	57	5011	2	_or_s
orts	4	65	3833	2	_orts
ouds	5	64	3010	2	_ouds
oxfords	18	4	289	2	oxfords
pards	8	56	3433	2	pards
pods	7	65	4015	2	po_ds
ponds	8	53	2340	2	ponds
poods	8	51	2475	2	poods
pores	7	58	4903	2	pores
porks	11	51	2414	2	porks
porns	7	55	2734	2	porns
ports	7	59	3459	2	ports
prods	8	55	2355	2	prods
roads	6	65	2361	2	roads
rods	5	64	4206	2	ro_ds
roods	6	51	2528	2	roods
sards	6	47	3618	2	sards
sods	5	49	4021	2	so_ds
soras	5	50	4101	2	soras
sorbs	7	50	2210	2	sorbs
sord	5	62	3720	2	sord_
sores	5	54	5428	2	sores
sorns	5	50	2841	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
surds	6	56	2466	2	surds
swords	10	45	1079	2	swords
toads	6	56	2106	2	toads
tods	5	61	4184	2	to_ds
toras	5	55	4037	2	toras
torcs	7	51	2376	2	torcs
tores	5	53	5267	2	tores
toros	5	43	3619	2	toros
torrs	5	39	2356	2	torrs
tors	4	61	5738	2	tor_s
torts	5	61	3812	2	torts
torus	5	43	2976	2	torus
turds	6	50	2169	2	turds
urds	5	59	2242	2	_urds
voids	9	54	1467	2	voids
wards	9	77	3440	2	wards
woads	9	48	1844	2	woads
wolds	9	54	2018	2	wolds
woods	9	57	2303	2	woods
word	8	98	3200	2	word_
wordy	12	69	1616	2	wordy
works	12	56	2190	2	works
worlds	10	56	873	2	worlds
worms	10	53	2075	2	worms
worts	8	86	3118	2	worts
yards	9	53	2461	2	yards
yirds	9	66	1251	2	yirds
yods	8	65	3118	2	yo_ds
yores	8	50	3132	2	yores
zoris	14	53	2001	2	zoris

Search took 5 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	53800	0.203	880251.2
2	DLD Change Limit	53800	248	3.686	14595.8
3	Display Results	248	248	0.143	1734.3
	(SQL Overall)	178691	248	4.032	44318.2