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

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

286 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
plat	6	60	4887	(None)
blat	6	65	5095	1	blat
flat	7	71	4782	1	flat
lat	3	75	9340	1	_lat
pat	5	80	8946	1	p_at
peat	6	59	6793	1	peat
phat	9	58	3786	1	phat
plait	7	56	3157	1	plait
plan	6	58	3394	1	plan
plant	7	54	3711	1	plant
plate	7	46	3511	1	plate
plats	7	55	3137	1	plats
platy	10	50	2166	1	platy
play	9	59	2898	1	play
pleat	7	47	3447	1	pleat
plot	6	61	4123	1	plot
prat	6	59	5204	1	prat
slat	4	69	5902	1	slat
splat	7	61	2934	1	splat
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	4033	2	alate
alit	4	61	5569	2	alit
alt	3	64	6796	2	al_t
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	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
pa	4	104	5648	2	p_a_
pac	7	90	5408	2	p_ac
pact	8	66	4872	2	pact
pad	6	80	5732	2	p_ad
pah	8	88	5359	2	p_ah
pal	5	67	6167	2	p_al
palate	8	42	2679	2	palate
pale	6	60	5501	2	pale
palet	7	46	5080	2	palet
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pam	7	78	5839	2	p_am
pan	5	84	6645	2	p_an
pant	6	60	6126	2	pant
pap	7	67	5840	2	p_ap
par	5	74	6702	2	p_ar
part	6	59	6746	2	part
pas	5	87	7574	2	p_as
past	6	59	5901	2	past
pate	6	53	5046	2	p_ate
path	9	91	3491	2	p_ath
pats	6	64	6085	2	p_ats
paty	9	52	3456	2	p_aty
paw	8	76	5117	2	p_aw
pax	12	73	4685	2	p_ax
pay	8	84	6118	2	p_ay
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pear	6	97	4523	2	pear
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
pelt	6	76	5108	2	pelt
pent	6	65	5907	2	pent
pert	6	67	5932	2	pert
pest	6	55	5529	2	pest
pet	5	64	7730	2	p_et
pfft	12	3	1188	2	pfft
phot	9	55	3436	2	phot
pht	8	60	3052	2	p_ht
phut	9	69	2597	2	phut
pia	5	68	4803	2	pia_
pial	6	56	3670	2	pial
pian	6	61	3609	2	pian
pias	6	65	4255	2	pias
pilaf	10	39	2348	2	pilaf
pilar	7	52	2150	2	pilar
pilau	7	36	1852	2	pilau
pilaw	10	39	1374	2	pilaw
pilot	7	74	3506	2	pilot
pint	6	69	6317	2	pint
pit	5	64	7192	2	p_it
pita	6	54	3643	2	pita
place	9	48	2461	2	place
placet	10	39	2367	2	placet
plack	13	50	1784	2	plack
plage	8	45	2040	2	plage
plaid	8	51	1830	2	plaid
plain	7	48	2330	2	plain
plaint	8	53	2320	2	plaint
plaits	8	38	1647	2	plaits
plane	7	49	2914	2	plane
planet	8	42	2835	2	planet
plank	11	52	2114	2	plank
plans	7	57	3127	2	plans
plants	8	49	2180	2	plants
plash	10	46	1656	2	plash
plasm	9	41	1463	2	plasm
platan	8	39	1369	2	platan
plated	9	52	2577	2	plated
platen	8	45	1820	2	platen
plater	8	44	2769	2	plater
plates	8	54	3224	2	plates
platys	11	45	985	2	platys
playa	10	58	1294	2	playa
plays	10	63	2077	2	plays
plaza	16	43	1106	2	plaza
plea	6	68	3060	2	plea
plead	8	58	1846	2	plead
pleas	7	56	2703	2	pleas
pleats	8	52	1859	2	pleats
pleb	8	61	2381	2	pleb
pled	7	52	3143	2	pled
plew	9	72	2281	2	plew
plex	13	73	2137	2	plex
pliant	8	39	1882	2	pliant
plie	6	51	2739	2	plie
plod	7	67	2327	2	plod
plop	8	66	2574	2	plop
plots	7	50	2567	2	plots
plotz	16	46	1700	2	plotz
plow	9	59	2323	2	plow
ploy	9	61	2360	2	ploy
plug	7	49	1599	2	plug
plum	8	51	2210	2	plum
plus	6	63	2483	2	plus
ply	8	63	2355	2	pl_y
poet	6	55	5290	2	poet
polar	7	56	2345	2	polar
port	6	60	5963	2	port
post	6	79	5336	2	post
pot	5	80	7843	2	p_ot
pout	6	57	5255	2	pout
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prate	7	51	3598	2	prate
prats	7	63	3339	2	prats
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
psst	6	61	1840	2	psst
pst	5	79	3251	2	p_st
pula	6	51	2937	2	pula_
punt	6	57	4720	2	punt
put	5	57	5907	2	p_ut
putt	6	69	3784	2	putt
pya	8	70	2375	2	pya_
pyas	9	62	2570	2	pyas
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
splats	8	48	1730	2	splats
splay	10	58	1604	2	splay
split	7	57	2901	2	split
sprat	7	66	3597	2	sprat
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
uplit	7	60	2080	2	uplit
vat	6	78	6345	2	_vat
wat	6	73	7892	2	_wat
what	10	54	3407	2	what

Search took 6 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	1.110	160982.9
2	DLD Change Limit	29872	286	3.580	8344.1
3	Display Results	286	286	0.140	2042.9
	(SQL Overall)	178691	286	4.830	36996.1