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

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

277 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
lath	7	66	4038	(None)
bath	9	59	4008	1	bath
eath	7	57	3566	1	eath
hath	10	59	3391	1	hath
laith	8	57	2210	1	laith
lakh	11	49	1995	1	lakh
lash	7	65	3965	1	lash
lat	3	75	9340	1	lat_
latch	10	46	2046	1	latch
late	4	75	6048	1	late
lathe	8	56	2671	1	lathe
lathi	8	54	1720	1	lathi
laths	8	60	2240	1	laths
lathy	11	52	1506	1	lathy
lati	4	64	3827	1	lati
lats	4	59	6270	1	lats
latu	4	79	3418	1	latu
loath	8	49	1860	1	loath
loth	7	61	3213	1	loth
math	9	54	3745	1	math
oath	7	61	3215	1	oath
path	9	91	3491	1	path
rath	7	60	3766	1	rath
aah	6	162	5296	2	_aah
ah	5	138	6879	2	_a_h
alate	5	53	4032	2	alate
alt	3	64	6796	2	alt_
altho	8	63	1260	2	altho
alto	4	78	3126	2	alto
alts	4	66	3990	2	alts
ash	6	79	4460	2	_ash
at	2	123	9340	2	_at_
ate	3	70	5924	2	_ate
att	3	54	5465	2	_att
bach	11	61	3139	2	bach
bah	8	77	5535	2	ba_h
baht	9	67	4001	2	baht
baith	10	80	2313	2	baith
bash	9	152	4016	2	bash
bat	5	109	8895	2	bat_
batch	12	46	2010	2	batch
bate	6	65	5242	2	bate
bathe	10	58	2288	2	bathe
baths	10	59	2292	2	baths
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
beth	9	66	2923	2	beth
blah	9	86	2506	2	bla_h
blat	6	65	5095	2	blat_
blate	7	59	3378	2	blate
blats	7	51	3250	2	blats
both	9	65	3343	2	both
caph	11	66	2329	2	caph
cash	9	66	3628	2	cash
cat	5	82	8234	2	cat_
catch	12	51	2037	2	catch
cate	6	62	5460	2	cate
cats	6	63	5634	2	cats
clach	12	46	1782	2	clach
clash	10	62	1903	2	clash
cloth	10	58	1754	2	cloth
dah	7	81	4898	2	da_h
dash	8	70	3163	2	dash
data	5	60	2665	2	data
date	5	64	4332	2	date
dato	5	61	2994	2	dato
death	9	48	2252	2	death
doth	8	62	2571	2	doth
each	9	55	3058	2	each
earth	8	50	2305	2	earth
eat	3	69	8905	2	eat_
eats	4	70	5487	2	eats
elate	5	53	3588	2	elate
eth	6	66	3098	2	_eth
faith	11	56	2085	2	faith
fash	10	72	3229	2	fash
fat	6	81	7808	2	fat_
fate	7	54	4428	2	fate
fats	7	62	5250	2	fats
flash	11	57	1621	2	flash
flat	7	71	4782	2	flat_
flats	8	64	2974	2	flats
garth	9	47	2022	2	garth
gash	8	68	3302	2	gash
gat	4	68	8051	2	gat_
gate	5	57	4657	2	gate
gats	5	67	5344	2	gats
goth	8	68	2508	2	goth
hah	9	106	5522	2	ha_h
hash	10	69	3650	2	hash
hat	6	72	8996	2	hat_
hatch	13	57	1959	2	hatch
hate	7	84	5017	2	hate
hats	7	68	5825	2	hats
heath	11	57	2428	2	heath
heth	10	70	2802	2	heth
jato	11	58	2268	2	jato
kaph	13	58	1575	2	kaph
kat	7	74	6829	2	kat_
kata	8	56	2602	2	kata
kats	8	59	4433	2	kats
kith	11	58	2636	2	kith
klatch	15	44	593	2	klatch
la	2	192	6163	2	la__
lab	5	88	6478	2	la_b
labs	6	71	4512	2	labs
lac	5	101	5582	2	la_c
lace	6	68	4847	2	lace
lack	10	58	3768	2	lack
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
lad	4	81	6570	2	la_d
lade	5	63	4598	2	lade
lads	5	65	4913	2	lads
lady	8	65	2715	2	lady
lag	4	78	6212	2	la_g
lags	5	65	4622	2	lags
laic	6	59	3156	2	laic
laich	10	59	2071	2	laich
laid	5	64	3914	2	laid
laigh	9	55	1592	2	laigh
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
laity	8	53	1890	2	laity
lake	8	57	4160	2	lake
lakhs	12	52	1034	2	lakhs
laky	11	67	2582	2	laky
lall	4	55	3131	2	lall
lam	5	76	6671	2	la_m
lama	6	66	3529	2	lama
lamb	8	68	3214	2	lamb
lame	6	68	4929	2	lame
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3738	2	lang
lank	8	47	3445	2	lank
lap	5	85	6527	2	la_p
laps	6	68	4887	2	laps
lar	3	79	6753	2	la_r
larch	10	59	1979	2	larch
lard	5	67	4200	2	lard
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lase	4	61	4851	2	lase
lass	4	74	4454	2	lass
last	4	62	6032	2	last
lasts	5	77	3126	2	lasts
lated	6	52	4067	2	lated
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lathed	10	47	1845	2	lathed
lather	9	51	2435	2	lather
lathes	9	51	2749	2	lathes
lathis	9	55	1617	2	lathis
latish	9	24	1617	2	latish
latke	9	48	1709	2	latke
latte	5	54	2630	2	latte
laud	5	65	2772	2	laud
laugh	9	44	1437	2	laugh
lav	6	68	4734	2	la_v
lava	7	67	2542	2	lava
lave	7	56	4214	2	lave
lavs	7	67	3415	2	lavs
law	6	86	5664	2	la_w
lawn	7	59	2563	2	lawn
laws	7	64	4168	2	laws
lax	10	76	5152	2	la_x
lay	6	88	6535	2	la_y
lays	7	60	4325	2	lays
laze	13	62	3505	2	laze
lazy	16	64	2307	2	lazy
leach	10	54	2252	2	leach
leash	8	55	1921	2	leash
lech	9	68	2544	2	lech
let	3	64	8147	2	let_
letch	10	52	1580	2	letch
lethe	8	57	1730	2	lethe
lets	4	71	4794	2	lets
lich	9	62	3084	2	lich
lit	3	93	7731	2	lit_
lite	4	70	5454	2	lite
lithe	8	49	2201	2	lithe
litho	8	65	1378	2	litho
lits	4	62	5249	2	lits
litu	4	76	3156	2	litu
loach	10	51	1636	2	loach
loathe	9	42	1138	2	loathe
loch	9	55	2713	2	loch
lot	3	81	7926	2	lot_
lota	4	72	3350	2	lota
lotah	8	53	1585	2	lotah
loti	4	64	3184	2	loti
lots	4	76	5209	2	lots
lush	7	53	2769	2	lush
lute	4	63	4101	2	lute
lutz	13	68	2632	2	lutz
lych	12	60	1576	2	lych
mach	11	61	3448	2	mach
mash	9	60	3940	2	mash
mat	5	80	8394	2	mat_
match	12	56	2110	2	match
mate	6	51	5422	2	mate
maths	10	56	2402	2	maths
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
meth	9	58	2784	2	meth
moth	9	67	3133	2	moth
myth	12	67	1543	2	myth
nah	6	98	4700	2	na_h
natch	10	50	1822	2	natch
neath	8	60	2028	2	neath
nth	6	63	2059	2	_nth
oat	3	98	8826	2	oat_
oaths	8	61	1731	2	oaths
oats	4	65	5421	2	oats
pah	8	88	5359	2	pa_h
pash	9	56	3813	2	pash
pat	5	80	8946	2	pat_
patch	12	52	2122	2	patch
pate	6	53	5046	2	pate
paths	10	55	2138	2	paths
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
pith	9	54	3269	2	pith
plash	10	46	1656	2	plash
plat	6	60	4887	2	plat_
plate	7	46	3511	2	plate
plats	7	55	3137	2	plats
platy	10	50	2166	2	platy
qat	12	52	5333	2	qat_
qats	13	53	3134	2	qats
rah	6	80	5240	2	ra_h
rash	7	60	3993	2	rash
rat	3	78	9274	2	rat_
ratch	10	42	2136	2	ratch
rate	4	54	5876	2	rate
rathe	8	58	2192	2	rathe
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
ruth	7	68	2599	2	ruth
saith	8	58	2655	2	saith
sash	7	72	3530	2	sash
sat	3	62	8848	2	sat_
sate	4	55	5610	2	sate
sati	4	55	3933	2	sati
sith	7	54	3515	2	sith
slash	8	47	1968	2	slash
slat	4	69	5902	2	slat_
slatch	11	45	1053	2	slatch
slate	5	54	3828	2	slate
slats	5	54	3690	2	slats
slaty	8	65	2315	2	slaty
sloth	8	50	1945	2	sloth
snath	8	64	1980	2	snath
soth	7	59	3252	2	soth
swath	11	59	2038	2	swath
tach	9	61	3275	2	tach
tat	3	76	9029	2	tat_
tate	4	47	4860	2	tate
tats	4	68	5813	2	tats
teth	7	63	2789	2	teth
vat	6	78	6345	2	vat_
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
wash	10	60	3381	2	wash
wat	6	73	7892	2	wat_
watch	13	56	1706	2	watch
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
with	10	57	3047	2	with
wrath	11	57	1587	2	wrath
yah	9	90	4635	2	ya_h

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	29872	0.703	254183.5
2	DLD Change Limit	29872	277	1.216	24565.8
3	Display Results	277	277	0.063	4396.8
	(SQL Overall)	178691	277	1.982	90156.9