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

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

335 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
slat	4	69	5902	(None)
blat	6	65	5095	1	blat
flat	7	71	4782	1	flat
lat	3	75	9340	1	_lat
plat	6	60	4887	1	plat
salt	4	57	5852	1	salt
sat	3	62	8848	1	s_at
scat	6	58	4837	1	scat
seat	4	75	7556	1	seat
shat	7	64	5659	1	shat
skat	8	70	3789	1	skat
slab	6	71	3376	1	slab
slag	5	59	3435	1	slag
slam	6	77	3797	1	slam
slant	5	52	3870	1	slant
slap	6	64	3404	1	slap
slate	5	54	3828	1	slate
slats	5	54	3690	1	slats
slaty	8	65	2315	1	slaty
slaw	7	79	3071	1	slaw
slay	7	64	3638	1	slay
slit	4	62	5010	1	slit
slot	4	60	4982	1	slot
slut	4	50	4059	1	slut
spat	6	65	4852	1	spat
splat	7	61	2934	1	splat
stat	4	73	5269	1	stat
swat	7	72	4444	1	swat
ala	3	124	6360	2	ala_
alae	4	56	4375	2	alae
alan	4	68	4408	2	alan
alant	5	57	4229	2	alant
alar	4	63	4007	2	alar
alas	4	63	5812	2	alas
alate	5	53	4032	2	alate
alit	4	61	5569	2	alit
alt	3	64	6796	2	al_t
aslant	6	3	1775	2	aslant
at	2	123	9340	2	__at
bat	5	109	8895	2	_bat
beat	6	61	6830	2	beat
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blast	7	65	3257	2	blast
blate	7	59	3378	2	blate
blats	7	51	3250	2	blats
blaw	9	70	2672	2	blaw
bleat	7	57	3700	2	bleat
blet	6	62	4767	2	blet
bloat	7	52	2992	2	bloat
blot	6	58	4232	2	blot
boat	6	63	6031	2	boat
brat	6	60	5554	2	brat
cat	5	82	8234	2	_cat
chat	9	55	4613	2	chat
clad	7	62	2582	2	clad
clag	7	59	2457	2	clag
clam	8	63	3229	2	clam
clan	6	56	3392	2	clan
clap	8	64	2904	2	clap
clapt	9	80	2717	2	clapt
clast	7	60	3058	2	clast
claw	9	56	2434	2	claw
clay	9	59	2741	2	clay
cleat	7	63	3506	2	cleat
clot	6	65	4242	2	clot
coat	6	75	5834	2	coat
doat	5	69	4767	2	doat
drat	5	62	4783	2	drat
eat	3	69	8905	2	_eat
eclat	7	5	2360	2	eclat
elan	4	67	3424	2	elan
elate	5	53	3588	2	elate
fat	6	81	7808	2	_fat
feat	7	64	5822	2	feat
fiat	7	66	4664	2	fiat
flab	9	66	2835	2	flab
flag	8	74	2708	2	flag
flak	11	60	2617	2	flak
flam	9	63	3329	2	flam
flan	7	61	3418	2	flan
flap	9	61	2870	2	flap
flats	8	64	2974	2	flats
flaw	10	63	2664	2	flaw
flax	14	73	2563	2	flax
flay	10	63	3280	2	flay
flit	7	65	3927	2	flit
float	8	59	2857	2	float
frat	7	56	4854	2	frat
gat	4	68	8051	2	_gat
ghat	8	64	3528	2	ghat
glad	6	56	2401	2	glad
glam	7	65	2934	2	glam
gloat	6	54	2768	2	gloat
glut	5	63	3129	2	glut
gnat	5	60	3443	2	gnat
goat	5	62	5083	2	goat
grat	5	56	5128	2	grat
halt	7	60	5630	2	halt
hat	6	72	8996	2	_hat
heat	7	70	6142	2	heat
ikat	8	76	2664	2	ikat
islet	5	45	2755	2	islet
kat	7	74	6829	2	_kat
khat	11	67	3072	2	khat
kyat	11	60	2552	2	kyat
la	2	192	6163	2	_la_
lab	5	88	6478	2	_lab
lac	5	101	5582	2	_lac
lad	4	81	6570	2	_lad
lag	4	78	6212	2	_lag
lam	5	76	6671	2	_lam
lap	5	85	6527	2	_lap
lar	3	79	6753	2	_lar
las	3	72	8147	2	_las
last	4	62	6032	2	_last
late	4	75	6048	2	_late
lath	7	66	4038	2	_lath
lati	4	64	3827	2	_lati
lats	4	59	6270	2	_lats
latu	4	79	3418	2	_latu
lav	6	68	4734	2	_lav
law	6	86	5664	2	_law
lax	10	76	5152	2	_lax
lay	6	88	6535	2	_lay
let	3	64	8147	2	_let
lit	3	93	7731	2	_lit
lot	3	81	7926	2	_lot
malt	6	62	5480	2	malt
mat	5	80	8393	2	_mat
meat	6	63	5960	2	meat
moat	6	63	5203	2	moat
neat	4	63	5678	2	neat
oat	3	98	8826	2	_oat
pat	5	80	8946	2	_pat
peat	6	59	6793	2	peat
phat	9	58	3786	2	phat
plait	7	56	3157	2	plait
plan	6	58	3394	2	plan
plant	7	54	3711	2	plant
plate	7	46	3511	2	plate
plats	7	55	3137	2	plats
platy	10	50	2166	2	platy
play	9	59	2898	2	play
pleat	7	47	3447	2	pleat
plot	6	61	4123	2	plot
prat	6	59	5204	2	prat
qat	12	52	5333	2	_qat
rat	3	78	9274	2	_rat
sab	5	65	6320	2	s_ab
sac	5	74	5286	2	s_ac
sad	4	74	5920	2	s_ad
sae	3	83	6518	2	s_ae
sag	4	61	6340	2	s_ag
sal	3	64	6288	2	s_al
salad	6	53	2183	2	salad
salal	5	54	2570	2	salal
sale	4	49	5970	2	sale
sall	4	45	4468	2	sall
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salts	5	54	3188	2	salts
salty	8	55	2438	2	salty
sap	5	64	6323	2	s_ap
sate	4	55	5610	2	s_ate
sati	4	55	3932	2	s_ati
sau	3	63	5657	2	s_au
saw	6	82	5535	2	s_aw
sax	10	74	4764	2	s_ax
say	6	72	6476	2	s_ay
scab	8	59	2671	2	scab
scad	7	57	2576	2	scad
scag	7	66	2689	2	scag
scam	8	59	3235	2	scam
scan	6	55	3045	2	scan
scant	7	97	3507	2	scant
scar	6	64	3420	2	scar
scart	7	61	3977	2	scart
scats	7	59	3060	2	scats
scatt	7	60	3009	2	scatt
scot	6	62	4260	2	scot
scut	6	58	3554	2	scut
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seats	5	48	4434	2	seats
sect	6	74	4362	2	sect
selah	8	3	1961	2	selah
sent	4	69	6301	2	sent
sept	6	58	4436	2	sept
set	3	66	8125	2	s_et
seta	4	56	3731	2	seta
sett	4	59	4905	2	sett
sext	11	73	3809	2	sext
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shaft	11	57	2525	2	shaft
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
shalt	8	55	3448	2	shalt
sham	9	64	3635	2	sham
shaw	10	81	3255	2	shaw
shay	10	71	3334	2	shay
shit	7	67	4593	2	shit
shoat	8	56	3394	2	shoat
shot	7	61	5024	2	shot
shut	7	61	3758	2	shut
sial	4	59	3883	2	sial
sift	7	107	4066	2	sift
silt	4	65	5819	2	silt
sit	3	58	7775	2	s_it
ska	7	69	2586	2	ska_
skag	9	63	2151	2	skag
skas	8	53	2571	2	skas
skate	9	47	2154	2	skate
skats	9	46	2153	2	skats
skit	8	54	3752	2	skit
slabs	7	53	2264	2	slabs
slack	11	50	2176	2	slack
slags	6	65	2590	2	slags
slain	5	49	2357	2	slain
slake	9	37	2405	2	slake
slams	7	49	2790	2	slams
slang	6	63	2402	2	slang
slank	9	58	2277	2	slank
slants	6	48	1908	2	slants
slanty	9	51	1484	2	slanty
slaps	7	60	2571	2	slaps
slash	8	47	1968	2	slash
slatch	11	45	1053	2	slatch
slated	7	50	2831	2	slated
slater	6	44	2918	2	slater
slates	6	49	3406	2	slates
slatey	9	54	1706	2	slatey
slave	8	42	2403	2	slave
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
sled	5	53	3437	2	sled
sleet	5	56	3913	2	sleet
slept	7	57	2810	2	slept
slew	7	62	2823	2	slew
slid	5	58	2898	2	slid
slim	6	66	3195	2	slim
slip	6	70	3173	2	slip
slipt	7	66	2748	2	slipt
slits	5	61	2885	2	slits
slob	6	60	2942	2	slob
sloe	4	55	3495	2	sloe
slog	5	67	2827	2	slog
slop	6	65	3387	2	slop
sloth	8	50	1944	2	sloth
slots	5	48	3052	2	slots
slow	7	77	2949	2	slow
slub	6	54	2803	2	slub
slue	4	53	3219	2	slue
slug	5	51	2464	2	slug
slum	6	54	3051	2	slum
slur	4	55	2515	2	slur
sluts	5	45	2398	2	sluts
sly	6	62	2856	2	sl_y
smalt	7	47	2933	2	smalt
smart	7	58	3409	2	smart
smit	6	51	3840	2	smit
smut	6	66	2978	2	smut
snag	5	58	2787	2	snag
snap	6	57	2703	2	snap
snath	8	64	1980	2	snath
snaw	7	89	2307	2	snaw
snit	4	63	4247	2	snit
snot	4	47	4544	2	snot
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soar	4	68	3867	2	soar
soft	7	69	4282	2	soft
sola	4	55	4186	2	sola_
solan	5	53	2815	2	solan
solar	5	59	2734	2	solar
solate	6	45	2607	2	solate
soot	4	57	6105	2	soot
sort	4	62	6481	2	sort
sot	3	103	8429	2	s_ot
spa	5	57	3081	2	spa_
spae	6	50	3432	2	spae
spait	7	56	3160	2	spait
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spar	6	54	3330	2	spar
spas	6	70	3672	2	spas
spate	7	47	3158	2	spate
spats	7	50	3138	2	spats
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
spit	6	55	4508	2	spit
splats	8	48	1730	2	splats
splay	10	58	1604	2	splay
split	7	57	2901	2	split
spot	6	55	4068	2	spot
sprat	7	66	3597	2	sprat
squat	14	37	2014	2	squat
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
star	4	80	3776	2	star
start	5	56	4231	2	start
state	5	62	3733	2	state
stats	5	59	3336	2	stats
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stet	4	59	4732	2	stet
stoat	5	71	3595	2	stoat
stot	4	63	4732	2	stot
suet	4	67	5482	2	suet
suit	4	56	4987	2	suit
swab	9	68	2531	2	swab
swag	8	75	2673	2	swag
swam	9	63	2998	2	swam
swan	7	66	3131	2	swan
swap	9	59	2543	2	swap
swart	8	62	3464	2	swart
swath	11	59	2038	2	swath
swats	8	57	2686	2	swats
sway	10	71	2823	2	sway
sweat	8	56	2840	2	sweat
swot	7	51	3465	2	swot
tat	3	76	9029	2	_tat
teat	4	59	6363	2	teat
that	7	56	3932	2	that
twat	7	58	3151	2	twat
ulan	4	65	2739	2	ulan
vat	6	78	6345	2	_vat
wat	6	73	7892	2	_wat
what	10	54	3407	2	what

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.140	1276364.3
2	DLD Change Limit	29872	335	2.126	14050.8
3	Display Results	335	335	0.156	2147.4
	(SQL Overall)	178691	335	2.422	73778.3