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

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

279 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
fards	9	66	2984	(None)
bards	8	71	3964	1	bards
cards	8	51	3793	1	cards
fads	8	69	3987	1	fa_ds
farads	10	47	1327	1	farads
fard	8	56	3906	1	fard_
fares	8	58	5287	1	fares
farls	8	57	3111	1	farls
farms	10	63	2495	1	farms
faros	8	55	3202	1	faros
farts	8	83	3684	1	farts
fords	9	53	2818	1	fords
hards	9	64	3565	1	hards
lards	6	53	3186	1	lards
nards	6	59	2846	1	nards
pards	8	56	3433	1	pards
sards	6	47	3618	1	sards
wards	9	77	3440	1	wards
yards	9	53	2461	1	yards
adds	6	76	2245	2	_adds
ads	4	97	5573	2	_a_ds
afars	8	57	1651	2	afar_s
aids	5	78	4635	2	_aids
ands	5	78	3361	2	_ands
arbs	6	68	3473	2	_arbs
arcs	6	78	3478	2	_arcs
ares	4	58	7102	2	_ares
arfs	7	60	2996	2	_arfs
arks	8	59	3687	2	_arks
arms	6	61	3749	2	_arms
ars	3	76	7093	2	_ar_s
arts	4	96	5026	2	_arts
awards	10	71	1345	2	awards
bads	7	70	4886	2	ba_ds
balds	8	55	2464	2	balds
bands	8	52	3342	2	bands
barbs	9	59	2819	2	barbs
bard	7	56	4886	2	bard_
barde	8	53	3077	2	barde
bardes	9	50	2693	2	bardes
bares	7	54	5713	2	bares
barfs	10	48	2600	2	barfs
barks	11	57	3581	2	barks
barms	9	61	2846	2	barms
barns	7	63	3514	2	barns
bars	6	65	6409	2	bar_s
bauds	8	58	2104	2	bauds
bawds	11	61	1549	2	bawds
beards	9	41	1667	2	beards
birds	8	54	2133	2	birds
boards	9	46	1693	2	boards
brads	8	55	2829	2	brads
burds	8	46	2606	2	burds
cads	7	61	4452	2	ca_ds
caids	8	52	2642	2	caids
cairds	9	64	1151	2	cairds
carbs	9	60	3146	2	carbs
card	7	102	4587	2	card_
cares	7	73	6918	2	cares
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carns	7	59	3756	2	carns
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	car_s
carts	7	89	4629	2	carts
chards	12	51	1972	2	chards
cords	8	60	3062	2	cords
curds	8	57	2561	2	curds
dads	6	74	4277	2	da_ds
darbs	8	53	2326	2	darbs
dares	6	61	4670	2	dares
darks	10	67	2787	2	darks
darns	6	69	2789	2	darns
darts	6	76	3573	2	darts
earls	5	61	2751	2	earls
earns	5	59	2756	2	earns
ears	4	63	5659	2	ear_s
fabs	9	86	3586	2	fa_bs
faces	10	64	3943	2	faces
facts	10	70	2189	2	facts
fad	7	74	5241	2	fa_d_
faddy	13	55	1162	2	faddy
fade	8	57	3634	2	fa_de
fades	9	49	3286	2	fades
fado	8	72	2646	2	fa_do
fados	9	56	2073	2	fados
fags	8	69	3912	2	fa_gs
fails	8	56	3148	2	fails
fairs	8	58	2544	2	fairs
fakes	12	60	3248	2	fakes
falls	8	57	2765	2	falls
fames	10	57	3592	2	fames
fanes	8	46	3989	2	fanes
fangs	9	62	2407	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4736	2	fa_ns
far	6	77	6260	2	far__
farad	9	57	2067	2	farad
farce	10	49	2532	2	farce
farces	11	52	2332	2	farces
farci	10	59	1931	2	farci
farcy	13	52	1709	2	farcy
farded	11	45	1895	2	farded
fardel	10	47	1259	2	fardel
fardels	11	38	989	2	fardels
fare	7	63	5446	2	far_e
fared	9	58	4234	2	fared
farer	8	67	3314	2	farer
farers	9	59	2405	2	farers
farl	7	63	3855	2	far_l
farle	8	69	2924	2	farle
farles	9	60	2578	2	farles
farm	9	59	3453	2	far_m
faro	7	61	3692	2	far_o
fart	7	68	6056	2	far_t
fas	6	82	6293	2	fa__s
fasts	8	64	2968	2	fasts
fates	8	51	3923	2	fates
fats	7	62	5250	2	fa_ts
faulds	10	43	896	2	faulds
fauns	8	45	1675	2	fauns
favas	11	56	1859	2	favas
faves	11	53	3142	2	faves
favus	11	43	1173	2	favus
fawns	11	59	1426	2	fawns
faxes	15	57	2665	2	faxes
fays	10	85	3536	2	fa_ys
fazes	17	55	2721	2	fazes
fears	8	48	2939	2	fear_s
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
fiars	8	67	2083	2	fiar_s
fids	8	70	3473	2	f_ids
finds	9	54	2482	2	finds
fiords	10	49	862	2	fiords
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
fjords	17	40	535	2	fjords
flares	9	45	2170	2	flares
folds	9	52	2169	2	folds
fonds	9	58	2482	2	fonds
foods	9	59	2416	2	foods
forbs	10	57	2080	2	forbs
ford	8	68	3549	2	ford_
fordo	9	72	1865	2	fordo
fores	8	58	4710	2	fores
forks	12	53	2468	2	forks
forms	10	53	2705	2	forms
forts	8	60	3445	2	forts
frags	9	63	2216	2	frags
fraps	10	56	2055	2	fraps
frass	8	53	2112	2	frass
frats	8	68	2967	2	frats
frauds	10	3	675	2	frauds
frays	11	69	2010	2	frays
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
gads	6	78	4338	2	ga_ds
garbs	8	63	2141	2	garbs
garda	7	3	1676	2	garda
gars	5	57	5074	2	gar_s
gauds	7	57	1772	2	gauds
girds	7	48	1699	2	girds
grads	7	56	2575	2	grads
guards	8	46	1156	2	guards
hands	9	53	2738	2	hands
hard	8	54	4350	2	hard_
hardy	12	56	2206	2	hardy
hares	8	62	5554	2	hares
harks	12	63	3343	2	harks
harls	8	56	3450	2	harls
harms	10	68	2901	2	harms
harps	10	59	2686	2	harps
harts	8	84	4159	2	harts
herds	9	64	2468	2	herds
hoards	10	49	1262	2	hoards
hurds	9	52	1907	2	hurds
jarls	12	61	2096	2	jarls
jars	11	73	3835	2	jar_s
karns	9	66	2414	2	karns
karts	9	76	3011	2	karts
lads	5	65	4913	2	la_ds
lairds	7	47	1161	2	lairds
lands	6	54	2690	2	lands
lard	5	67	4200	2	lard_
lardy	9	61	1927	2	lardy
lares	5	48	5263	2	lares
laris	5	47	3746	2	laris
larks	9	52	2781	2	larks
lars	4	69	5657	2	lar_s
lauds	6	56	1848	2	lauds
liards	7	52	1261	2	liards
lords	6	49	2350	2	lords
mads	7	68	4536	2	ma_ds
maids	8	63	2714	2	maids
maras	7	54	4328	2	maras
marcs	9	57	2662	2	marcs
mares	7	64	5763	2	mares
marks	11	59	3348	2	marks
marls	7	55	3516	2	marls
mars	6	62	6186	2	mar_s
marts	7	74	4223	2	marts
mauds	8	55	1927	2	mauds
narcs	7	61	2202	2	narcs
nard	5	66	3445	2	nard_
nares	5	55	4415	2	nares
naris	5	57	3529	2	naris
narks	9	60	2603	2	narks
nerds	6	57	1925	2	nerds
nurds	6	55	1852	2	nurds
oars	4	68	4603	2	oar_s
pads	7	67	4295	2	pa_ds
paras	7	61	4304	2	paras
pard	7	64	4132	2	pard_
pardi	8	57	2395	2	pardi
pardy	11	55	2395	2	pardy
pares	7	71	6448	2	pares
paris	7	51	4594	2	paris
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
qaids	15	61	1631	2	qaids
rads	5	60	4660	2	ra_ds
raids	6	58	2751	2	raids
rands	6	59	3045	2	rands
rares	5	52	4744	2	rares
saids	6	53	2885	2	saids
sands	6	52	2858	2	sands
sard	5	53	4424	2	sard_
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
sarods	7	49	1857	2	sarods
saros	5	52	3806	2	saros
shards	10	43	1917	2	shards
sords	6	45	2780	2	sords
surds	6	56	2466	2	surds
swards	10	54	1513	2	swards
tads	5	71	4394	2	ta_ds
tardo	6	53	2110	2	tardo
tardy	9	47	2046	2	tardy
tares	5	74	5656	2	tares
tarns	5	64	3395	2	tarns
taros	5	56	4082	2	taros
tarps	7	65	2711	2	tarps
tars	4	67	6395	2	tar_s
tarts	5	72	4202	2	tarts
turds	6	50	2169	2	turds
urds	5	59	2242	2	_urds
varas	8	60	2819	2	varas
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
wads	8	73	4314	2	wa_ds
wands	9	64	2548	2	wands
ward	8	65	4225	2	ward_
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2685	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
wars	7	86	5980	2	war_s
warts	8	148	4040	2	warts
words	9	54	2507	2	words
yairds	10	44	802	2	yairds
yard	8	56	3325	2	yard_
yarns	8	56	2179	2	yarns
yauds	9	50	1322	2	yauds
yirds	9	66	1251	2	yirds
zarfs	17	47	1362	2	zarfs

Search took 3 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.093	1921408.6
2	DLD Change Limit	53800	279	1.826	29463.3
3	Display Results	279	279	0.080	3487.5
	(SQL Overall)	178691	279	1.999	89390.2