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

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

281 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
plats	7	55	3137	(None)
blats	7	51	3250	1	blats
flats	8	64	2974	1	flats
lats	4	59	6270	1	_lats
pats	6	64	6085	1	p_ats
peats	7	61	4019	1	peats
plaits	8	38	1647	1	plaits
plans	7	57	3127	1	plans
plants	8	49	2180	1	plants
plat	6	60	4887	1	plat_
plate	7	46	3511	1	plate
plates	8	54	3224	1	plates
platy	10	50	2166	1	platy
platys	11	45	985	1	platys
plays	10	63	2077	1	plays
pleats	8	52	1859	1	pleats
plots	7	50	2567	1	plots
prats	7	63	3339	1	prats
slats	5	54	3690	1	slats
splats	8	48	1730	1	splats
alans	5	56	3617	2	alans
alants	6	77	2202	2	alants
alas	4	63	5812	2	ala_s
alate	5	53	4032	2	alate
alates	6	48	3396	2	alates
alts	4	66	3990	2	al_ts
bats	6	69	6233	2	_bats
beats	7	60	4224	2	beats
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blams	9	50	2385	2	blams
blast	7	65	3257	2	blast
blasts	8	51	1677	2	blasts
blat	6	65	5095	2	blat_
blate	7	59	3378	2	blate
blaws	10	56	2046	2	blaws
bleats	8	55	1861	2	bleats
blets	7	53	2494	2	blets
bloats	8	52	1576	2	bloats
blots	7	56	2617	2	blots
boats	7	56	3515	2	boats
brats	7	53	3601	2	brats
cats	6	63	5634	2	_cats
chats	10	57	3009	2	chats
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
clams	9	51	2767	2	clams
clans	7	50	3101	2	clans
claps	9	56	2618	2	claps
class	7	55	2548	2	class
clast	7	60	3058	2	clast
clasts	8	48	1729	2	clasts
claws	10	60	2083	2	claws
clays	10	55	2133	2	clays
cleats	8	49	1931	2	cleats
clots	7	56	2764	2	clots
coats	7	56	3499	2	coats
doats	6	52	2488	2	doats
drats	6	66	2837	2	drats
eats	4	70	5487	2	_eats
eclats	8	3	1303	2	eclats
elans	5	55	2775	2	elans
elate	5	53	3588	2	elate
elates	6	50	3236	2	elates
fats	7	62	5250	2	_fats
feats	8	64	3275	2	feats
fiats	8	53	2448	2	fiats
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flams	10	51	2501	2	flams
flans	8	53	2797	2	flans
flaps	10	56	2138	2	flaps
flat	7	71	4782	2	flat_
flatus	9	43	1078	2	flatus
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
flits	8	56	2522	2	flits
floats	9	68	1625	2	floats
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
ghats	9	58	1861	2	ghats
glads	7	56	2061	2	glads
glams	8	58	2293	2	glams
glans	6	51	2583	2	glans
glass	6	55	1813	2	glass
gloats	7	45	1542	2	gloats
gluts	6	61	2013	2	gluts
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
halts	8	52	3010	2	halts
hats	7	68	5825	2	_hats
heats	8	58	3840	2	heats
ikats	9	53	1115	2	ikats
kats	8	59	4433	2	_kats
khats	12	53	1601	2	khats
kyats	12	50	1244	2	kyats
labs	6	71	4512	2	_labs
lacs	6	69	4248	2	_lacs
lads	5	65	4913	2	_lads
lags	5	65	4622	2	_lags
lams	6	65	5226	2	_lams
laps	6	68	4887	2	_laps
lars	4	69	5657	2	_lars
las	3	72	8147	2	_la_s
lass	4	74	4454	2	_lass
last	4	62	6032	2	_last
lasts	5	77	3126	2	_lasts
lat	3	75	9340	2	_lat_
late	4	75	6048	2	_late
lath	7	66	4038	2	_lath
laths	8	60	2240	2	_laths
lati	4	64	3827	2	_lati
latu	4	79	3418	2	_latu
lavs	7	67	3415	2	_lavs
laws	7	64	4168	2	_laws
lays	7	60	4325	2	_lays
lets	4	71	4794	2	_lets
lits	4	62	5249	2	_lits
lots	4	76	5209	2	_lots
malts	7	63	3175	2	malts
mats	6	54	6028	2	_mats
meats	7	50	3405	2	meats
moats	7	58	2764	2	moats
neats	5	59	3190	2	neats
oats	4	65	5421	2	_oats
pacs	8	58	4218	2	p_acs
pacts	9	51	2580	2	pacts
pads	7	67	4295	2	p_ads
palais	8	4	2042	2	palais
palate	8	42	2678	2	palate
palates	9	36	2493	2	palates
pales	7	57	5380	2	pales
palets	8	51	2231	2	palets
palls	7	43	3256	2	palls
palms	9	49	2175	2	palms
palps	9	47	1956	2	palps
pals	6	69	5135	2	p_als
pams	8	56	4176	2	p_ams
pans	6	58	5572	2	p_ans
pants	7	65	3692	2	pants
paps	8	64	4345	2	p_aps
pars	6	75	6079	2	p_ars
parts	7	77	4337	2	parts
pas	5	87	7574	2	p_a_s
pass	6	52	3995	2	p_ass
past	6	59	5901	2	p_ast
pasts	7	59	3650	2	pasts
pat	5	80	8946	2	p_at_
pate	6	53	5046	2	p_ate
pates	7	60	4789	2	p_ates
path	9	91	3491	2	p_ath
paths	10	55	2138	2	p_aths
patsy	10	57	1720	2	p_atsy
paty	9	52	3456	2	p_aty
paws	9	60	3818	2	p_aws
pays	9	59	4022	2	p_ays
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peat	6	59	6793	2	peat_
peaty	10	57	2569	2	peaty
pelts	7	61	2881	2	pelts
pests	7	59	3327	2	pests
pets	6	62	4833	2	p_ets
phat	9	58	3786	2	phat_
phots	10	54	1849	2	phots
phuts	10	46	1350	2	phuts
pians	7	51	2696	2	pians
pias	6	65	4255	2	pia_s
pilafs	11	35	1102	2	pilafs
pilaus	8	41	1413	2	pilaus
pilaws	11	39	943	2	pilaws
pilots	8	40	1887	2	pilots
pints	7	59	3622	2	pints
pitas	7	74	2767	2	pitas
pits	6	63	4874	2	p_its
place	9	48	2461	2	place
places	10	43	2370	2	places
placets	11	39	1122	2	placets
plack	13	50	1784	2	plack
placks	14	44	1415	2	placks
plage	8	45	2040	2	plage
plages	9	45	2015	2	plages
plaid	8	51	1830	2	plaid
plaids	9	43	1244	2	plaids
plain	7	48	2330	2	plain
plains	8	50	1959	2	plains
plaints	9	40	1205	2	plaints
plait	7	56	3157	2	plait
plan	6	58	3394	2	pla_n
plane	7	49	2914	2	plane
planes	8	50	2808	2	planes
planets	9	39	1408	2	planets
plank	11	52	2114	2	plank
planks	12	41	1675	2	planks
plant	7	54	3711	2	plant
plash	10	46	1656	2	plash
plasm	9	41	1463	2	plasm
plasms	10	37	1133	2	plasms
platan	8	39	1369	2	platan
platans	9	34	1312	2	platans
plated	9	52	2577	2	plated
platen	8	45	1820	2	platen
platens	9	42	1398	2	platens
plater	8	44	2769	2	plater
platers	9	39	2408	2	platers
platies	9	37	2254	2	platies
play	9	59	2898	2	pla_y
playa	10	58	1294	2	playa
playas	11	46	1228	2	playas
plaza	16	43	1106	2	plaza
plazas	17	40	991	2	plazas
pleads	9	46	1395	2	pleads
pleas	7	56	2703	2	pleas
pleat	7	47	3447	2	pleat_
plebs	9	58	1458	2	plebs
plews	10	54	1535	2	plews
plies	7	45	2651	2	plies
plods	8	57	1929	2	plods
plops	9	59	2033	2	plops
plot	6	61	4123	2	plot_
plotz	16	46	1699	2	plotz
plows	10	54	1990	2	plows
ploys	10	58	1659	2	ploys
plugs	8	52	1349	2	plugs
plums	9	46	1995	2	plums
plus	6	63	2483	2	pl_us
poets	7	60	2444	2	poets
polars	8	44	1935	2	polars
ports	7	59	3459	2	ports
posts	7	52	2878	2	posts
pots	6	64	5236	2	p_ots
pouts	7	55	3032	2	pouts
prams	9	61	2551	2	prams
praos	7	49	2356	2	praos
prat	6	59	5204	2	prat_
prate	7	51	3598	2	prate
prates	8	46	3316	2	prates
praus	7	46	2175	2	praus
prays	10	50	2243	2	prays
punts	7	58	2800	2	punts
puts	6	56	4175	2	p_uts
putts	7	57	1927	2	putts
pyas	9	62	2570	2	pya_s
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
salts	5	54	3188	2	salts
scats	7	59	3060	2	scats
seats	5	48	4434	2	seats
skats	9	46	2153	2	skats
slabs	7	53	2264	2	slabs
slags	6	65	2590	2	slags
slams	7	49	2790	2	slams
slants	6	48	1908	2	slants
slaps	7	60	2571	2	slaps
slat	4	69	5902	2	slat_
slate	5	54	3828	2	slate
slates	6	49	3406	2	slates
slaty	8	65	2315	2	slaty
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
slits	5	61	2885	2	slits
slots	5	48	3052	2	slots
sluts	5	45	2398	2	sluts
spats	7	50	3138	2	spats
splat	7	61	2934	2	splat_
splays	11	49	1087	2	splays
splits	8	54	1641	2	splits
sprats	8	58	1993	2	sprats
stats	5	59	3336	2	stats
swats	8	57	2686	2	swats
tats	4	68	5813	2	_tats
teats	5	56	3681	2	teats
twats	8	66	1660	2	twats
ulans	5	49	2130	2	ulans
vats	7	68	4174	2	_vats
wats	7	75	5588	2	_wats
whats	11	77	1899	2	whats

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	281	2.733	19685.3
3	Display Results	281	281	0.186	1510.8
	(SQL Overall)	178691	281	3.012	59326.4