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

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

282 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
lards	6	53	3186	(None)
bards	8	71	3964	1	bards
cards	8	51	3793	1	cards
fards	9	66	2984	1	fards
hards	9	64	3565	1	hards
lads	5	65	4913	1	la_ds
lairds	7	47	1161	1	lairds
lands	6	54	2690	1	lands
lard	5	67	4200	1	lard_
lardy	9	61	1927	1	lardy
lares	5	48	5263	1	lares
laris	5	47	3746	1	laris
larks	9	52	2781	1	larks
lars	4	69	5657	1	lar_s
lauds	6	56	1848	1	lauds
liards	7	52	1261	1	liards
lords	6	49	2350	1	lords
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
aids	5	78	4635	2	_aids
alands	7	54	1837	2	alands
alarms	8	59	1305	2	alarms
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
blares	8	50	2163	2	blares
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	1973	2	chards
clads	8	57	2273	2	cla_ds
claros	8	40	1511	2	claros
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
elands	7	49	1477	2	elands
fads	8	69	3987	2	fa_ds
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
flares	9	45	2170	2	flares
fords	9	53	2818	2	fords
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
glads	7	56	2061	2	gla_ds
glands	8	53	1440	2	glands
glares	7	55	1886	2	glares
grads	7	56	2575	2	grads
guards	8	46	1157	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	2687	2	harps
harts	8	84	4159	2	harts
herds	9	64	2468	2	herds
hoards	10	49	1262	2	hoards
holards	11	4	843	2	holards
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
labs	6	71	4512	2	la_bs
laces	7	61	4176	2	laces
lacks	11	61	2920	2	lacks
lacs	6	69	4248	2	la_cs
lad	4	81	6570	2	la_d_
lade	5	63	4598	2	la_de
lades	6	51	4127	2	lades
lady	8	65	2715	2	la_dy
lags	5	65	4622	2	la_gs
laics	7	64	1925	2	laics
laid	5	64	3914	2	laid_
laird	6	54	1779	2	laird_
lairs	5	54	2587	2	lairs
lakes	9	57	3765	2	lakes
lakhs	12	52	1034	2	lakhs
lalls	5	53	2413	2	lalls
lamas	7	55	3279	2	lamas
lambs	9	59	2141	2	lambs
lameds	9	48	1203	2	lameds
lames	7	54	4554	2	lames
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	la_ms
land	5	63	3731	2	land_
lanes	5	49	4679	2	lanes
lapis	7	62	2315	2	lapis
laps	6	68	4887	2	la_ps
lar	3	79	6753	2	lar__
larch	10	59	1979	2	larch
larded	8	43	1909	2	larded
larder	7	37	2097	2	larder
larders	8	35	1694	2	larders
lardon	7	44	1506	2	lardon
lardons	8	39	1449	2	lardons
laree	5	60	3629	2	laree
larees	6	53	2311	2	larees
large	6	53	2546	2	large
larges	7	48	2423	2	larges
largo	6	53	1978	2	largo
largos	7	48	1506	2	largos
lari	4	58	3915	2	lar_i
lark	8	57	3386	2	lar_k
larky	12	52	1887	2	larky
larum	7	43	1797	2	larum
larums	8	36	1053	2	larums
larva	8	3	1248	2	larva
larvas	9	3	1023	2	larvas
las	3	72	8147	2	la__s
lases	5	49	4476	2	lases
lass	4	74	4454	2	la_ss
lasts	5	77	3126	2	lasts
laths	8	60	2240	2	laths
lats	4	59	6270	2	la_ts
laud	5	65	2772	2	laud_
lauras	6	34	1433	2	lauras
lavas	8	54	2222	2	lavas
laves	8	60	3915	2	laves
lavs	7	67	3415	2	la_vs
lawns	8	52	1542	2	lawns
laws	7	64	4168	2	la_ws
laxes	12	54	3009	2	laxes
lays	7	60	4325	2	la_ys
lazes	14	51	2957	2	lazes
leads	6	60	2849	2	leads
learns	6	55	1374	2	learns
lears	5	59	3873	2	lear_s
lends	6	53	2625	2	lends
leuds	6	62	1481	2	leuds
liard	6	54	1859	2	liard_
liars	5	47	2316	2	liar_s
lids	5	63	3645	2	l_ids
liras	5	60	2198	2	liras
lizards	17	42	761	2	lizards
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
lures	5	61	3853	2	lures
lurks	9	52	1874	2	lurks
lyard	9	51	1321	2	lyard_
lyres	8	50	1996	2	lyres
mads	7	68	4537	2	ma_ds
maids	8	63	2714	2	maids
maras	7	54	4329	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	6187	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
plaids	9	43	1244	2	plaids
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 2 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.313	570897.8
2	DLD Change Limit	53800	282	1.466	36698.5
3	Display Results	282	282	0.080	3525.0
	(SQL Overall)	178691	282	1.859	96122.1