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

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

288 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
blat	6	65	5095	(None)
bat	5	109	8895	1	b_at
beat	6	61	6830	1	beat
blab	8	66	2913	1	blab
blae	6	61	3464	1	blae
blah	9	86	2506	1	blah
blam	8	61	3170	1	blam
blast	7	65	3257	1	blast
blate	7	59	3378	1	blate
blats	7	51	3250	1	blats
blaw	9	70	2672	1	blaw
bleat	7	57	3700	1	bleat
blet	6	62	4767	1	blet
bloat	7	52	2992	1	bloat
blot	6	58	4232	1	blot
boat	6	63	6031	1	boat
brat	6	60	5554	1	brat
flat	7	71	4782	1	flat
lat	3	75	9340	1	_lat
plat	6	60	4887	1	plat
slat	4	69	5902	1	slat
ablate	8	22	1921	2	ablate
ablaut	8	3	1326	2	ablaut
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
at	2	123	9340	2	__at
ba	4	99	6234	2	b_a_
baa	5	106	5042	2	b_aa
baal	6	70	3311	2	baal
baas	6	68	4467	2	baas
bad	6	77	6315	2	b_ad
bag	6	70	5922	2	b_ag
bah	8	77	5535	2	b_ah
baht	9	67	4001	2	baht
bait	6	65	5600	2	bait
bal	5	66	6272	2	b_al
balas	7	69	3721	2	balas
balata	8	6	1467	2	balata
bald	7	64	3290	2	bald
bale	6	63	5384	2	bale
balk	10	51	3222	2	balk
ball	6	60	4332	2	ball
balm	8	55	3420	2	balm
bals	6	63	5404	2	bals
bam	7	85	6014	2	b_am
ban	5	83	6684	2	b_an
bap	7	64	5584	2	b_ap
bar	5	80	7055	2	b_ar
bas	5	86	8175	2	b_as
bast	6	63	6241	2	bast
bate	6	65	5242	2	b_ate
bath	9	59	4008	2	b_ath
bats	6	69	6233	2	b_ats
batt	6	50	5387	2	batt
bay	8	96	6164	2	b_ay
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beast	7	63	3864	2	beast
beats	7	60	4224	2	beats
beau	6	61	3727	2	beau
beaut	7	51	3521	2	beaut
beet	6	64	5754	2	beet
begat	8	66	2972	2	begat
belay	10	50	2152	2	belay
belt	6	57	5403	2	belt
bent	6	77	5991	2	bent
best	6	63	5532	2	best
bet	5	83	7667	2	b_et
beta	6	62	3413	2	beta
bhut	9	54	2571	2	bhut
bias	6	47	3816	2	bias
bint	6	73	5504	2	bint
bit	5	70	7090	2	b_it
bitt	6	55	4581	2	bitt
blabs	9	56	1963	2	blabs
black	13	47	1907	2	black
blade	8	59	2333	2	blade
blaff	13	52	1648	2	blaff
blahs	10	56	1651	2	blahs
blain	7	54	2179	2	blain
blame	9	56	2549	2	blame
blams	9	50	2385	2	blams
bland	8	53	2045	2	bland
blank	11	54	1855	2	blank
blare	7	58	2623	2	blare
blase	7	55	2423	2	blase
blasts	8	51	1677	2	blasts
blasty	11	56	1105	2	blasty
blawn	10	68	1370	2	blawn
blaws	10	56	2046	2	blaws
blaze	16	55	2083	2	blaze
bleak	11	59	1538	2	bleak
blear	7	59	1868	2	blear
bleats	8	55	1861	2	bleats
bleb	8	54	2522	2	bleb
bled	7	57	2931	2	bled
blent	7	62	3095	2	blent
blest	7	64	3172	2	blest
blets	7	53	2494	2	blets
blew	9	47	2243	2	blew
blin	6	72	2817	2	blin
blip	8	83	2277	2	blip
blite	7	62	2535	2	blite
blitz	16	53	1813	2	blitz
bloats	8	52	1576	2	bloats
blob	8	60	2709	2	blob
bloc	8	50	2327	2	bloc
blog	7	57	2382	2	blog
blots	7	56	2617	2	blots
blow	9	58	2719	2	blow
blub	8	53	2487	2	blub
blue	6	53	2846	2	blue
bluet	7	56	3119	2	bluet
blunt	7	55	2502	2	blunt
blur	6	60	2053	2	blur
blurt	7	76	2562	2	blurt
boa	5	69	5403	2	boa_
boar	6	61	3429	2	boar
boart	7	88	3593	2	boart
boas	6	61	5083	2	boas
boast	7	59	3570	2	boast
boats	7	56	3515	2	boats
bola	6	60	3556	2	bola_
bolar	7	51	2347	2	bolar
bolas	7	47	3376	2	bolas
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bort	6	59	6096	2	bort
bot	5	96	8040	2	b_ot
bota	6	62	3650	2	bota
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
bra	5	63	3946	2	bra_
bract	9	63	3272	2	bract
brad	7	52	3434	2	brad
brae	6	56	3911	2	brae
brag	7	52	2972	2	brag
bran	6	57	4038	2	bran
brant	7	47	4217	2	brant
bras	6	57	4645	2	bras
brats	7	53	3601	2	brats
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
brit	6	63	5015	2	brit
brut	6	65	3796	2	brut
bunt	6	58	5085	2	bunt
bust	6	59	4778	2	bust
but	5	59	6302	2	b_ut
butt	6	51	4374	2	butt
bylaw	13	40	860	2	bylaw
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	5835	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
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	5481	2	malt
mat	5	80	8394	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
oblast	8	6	1366	2	oblast
oblate	8	22	1474	2	oblate
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
salt	4	57	5852	2	salt
sat	3	62	8848	2	_sat
scat	6	58	4837	2	scat
seat	4	75	7556	2	seat
shat	7	64	5660	2	shat
skat	8	70	3790	2	skat
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slam	6	77	3797	2	slam
slant	5	52	3870	2	slant
slap	6	64	3404	2	slap
slate	5	54	3828	2	slate
slats	5	54	3690	2	slats
slaty	8	65	2315	2	slaty
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
slit	4	62	5010	2	slit
slot	4	60	4983	2	slot
slut	4	50	4059	2	slut
spat	6	65	4852	2	spat
splat	7	61	2934	2	splat
stat	4	73	5269	2	stat
swat	7	72	4444	2	swat
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 4 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.156	1145455.1
2	DLD Change Limit	29872	288	2.970	10057.9
3	Display Results	288	288	0.233	1236.1
	(SQL Overall)	178691	288	3.359	53197.7