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

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

296 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
blats	7	51	3250	(None)
bats	6	69	6233	1	b_ats
beats	7	60	4224	1	beats
blabs	9	56	1963	1	blabs
blahs	10	56	1651	1	blahs
blams	9	50	2385	1	blams
blast	7	65	3257	1	blast
blasts	8	51	1677	1	blasts
blat	6	65	5095	1	blat_
blate	7	59	3378	1	blate
blaws	10	56	2046	1	blaws
bleats	8	55	1861	1	bleats
blets	7	53	2494	1	blets
bloats	8	52	1576	1	bloats
blots	7	56	2617	1	blots
boats	7	56	3515	1	boats
brats	7	53	3601	1	brats
flats	8	64	2974	1	flats
lats	4	59	6270	1	_lats
plats	7	55	3137	1	plats
slats	5	54	3690	1	slats
ablate	8	22	1921	2	ablate
ablates	9	24	1690	2	ablates
ablauts	9	3	608	2	ablauts
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
baals	7	61	2270	2	baals
baas	6	68	4467	2	b_aas
bads	7	70	4886	2	b_ads
bags	7	66	4550	2	b_ags
bahts	10	56	1780	2	bahts
baits	7	66	3058	2	baits
balas	7	69	3721	2	balas
balata	8	6	1467	2	balata
balatas	9	3	1183	2	balatas
balds	8	55	2464	2	balds
bales	7	62	5008	2	bales
balks	11	49	2629	2	balks
balls	7	62	3641	2	balls
balms	9	57	2392	2	balms
bals	6	63	5404	2	b_als
bams	8	70	4445	2	b_ams
bans	6	65	5514	2	b_ans
baps	8	60	4084	2	b_aps
bars	6	65	6409	2	b_ars
bas	5	86	8175	2	b_a_s
bass	6	61	4678	2	b_ass
bast	6	63	6241	2	b_ast
basts	7	59	3693	2	basts
bat	5	109	8895	2	b_at_
bate	6	65	5242	2	b_ate
bates	7	58	4634	2	b_ates
bath	9	59	4008	2	b_ath
baths	10	59	2292	2	b_aths
batt	6	50	5387	2	b_att
batts	7	67	2756	2	batts
bays	9	71	4391	2	b_ays
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beasts	8	45	1972	2	beasts
beat	6	61	6830	2	beat_
beaus	7	51	2711	2	beaus
beauts	8	60	1528	2	beauts
beets	7	61	3144	2	beets
belays	11	43	1385	2	belays
belts	7	59	3116	2	belts
bents	7	60	3369	2	bents
bests	7	59	3261	2	bests
betas	7	55	2876	2	betas
bets	6	70	5144	2	b_ets
bhuts	10	58	1295	2	bhuts
bias	6	47	3816	2	bia_s
bints	7	61	3018	2	bints
bits	6	61	4816	2	b_its
bitts	7	50	2259	2	bitts
blab	8	66	2913	2	bla_b
black	13	47	1907	2	black
blacks	14	49	1495	2	blacks
blade	8	59	2333	2	blade
blades	9	52	2125	2	blades
blae	6	61	3464	2	bla_e
blaff	13	52	1648	2	blaff
blaffs	14	42	662	2	blaffs
blah	9	86	2506	2	bla_h
blain	7	54	2179	2	blain
blains	8	45	1637	2	blains
blam	8	61	3170	2	bla_m
blame	9	56	2549	2	blame
blames	10	51	2186	2	blames
bland	8	53	2045	2	bland
blank	11	54	1855	2	blank
blanks	12	41	1289	2	blanks
blare	7	58	2623	2	blare
blares	8	50	2163	2	blares
blase	7	55	2423	2	blase
blasty	11	56	1105	2	blasty
blaw	9	70	2672	2	bla_w
blawn	10	68	1370	2	blawn
blaze	16	55	2083	2	blaze
blazes	17	48	1735	2	blazes
bleaks	12	51	1243	2	bleaks
blears	8	51	1645	2	blears
bleat	7	57	3700	2	bleat_
blebs	9	64	1615	2	blebs
bless	7	59	1781	2	bless
blest	7	64	3172	2	blest
blet	6	62	4767	2	blet_
blips	9	56	1578	2	blips
bliss	7	56	1691	2	bliss
blite	7	62	2535	2	blite
blites	8	47	2121	2	blites
blitz	16	53	1813	2	blitz
bloat	7	52	2992	2	bloat_
blobs	9	56	2003	2	blobs
blocs	9	52	1965	2	blocs
blogs	8	53	1923	2	blogs
blot	6	58	4232	2	blot_
blows	10	54	2383	2	blows
blubs	9	58	1815	2	blubs
blues	7	51	2704	2	blues
bluets	8	72	1549	2	bluets
blunts	8	45	1289	2	blunts
blurs	7	46	1908	2	blurs
blurts	8	44	1264	2	blurts
boars	7	52	2960	2	boars
boarts	8	47	1687	2	boarts
boas	6	61	5083	2	boa_s
boast	7	59	3570	2	boast
boasts	8	50	1792	2	boasts
boat	6	63	6031	2	boat_
bolas	7	47	3376	2	bola_s
bolts	7	62	3211	2	bolts
boots	7	58	3797	2	boots
borts	7	67	3545	2	borts
botas	7	53	2878	2	botas
bots	6	64	5395	2	b_ots
botts	7	52	2486	2	botts
bouts	7	51	3131	2	bouts
bracts	10	56	1777	2	bracts
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
brans	7	54	3743	2	brans
brants	8	57	2305	2	brants
bras	6	57	4645	2	bra_s
brass	7	54	2802	2	brass
brat	6	60	5554	2	brat_
braws	10	64	2519	2	braws
brays	10	67	2311	2	brays
brits	7	64	3308	2	brits
bruts	7	59	2295	2	bruts
bunts	7	57	2980	2	bunts
busts	7	52	2769	2	busts
buts	6	72	4769	2	b_uts
butts	7	58	2425	2	butts
bylaws	14	41	583	2	bylaws
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	3500	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	6029	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
oblast	8	6	1366	2	oblast
oblasts	9	4	730	2	oblasts
oblate	8	22	1474	2	oblate
oblates	9	19	1324	2	oblates
pats	6	64	6085	2	_pats
peats	7	61	4019	2	peats
plaits	8	38	1647	2	plaits
plans	7	57	3127	2	plans
plants	8	49	2180	2	plants
plat	6	60	4887	2	plat_
plate	7	46	3511	2	plate
plates	8	54	3224	2	plates
platy	10	50	2166	2	platy
platys	11	45	985	2	platys
plays	10	63	2077	2	plays
pleats	8	52	1859	2	pleats
plots	7	50	2567	2	plots
prats	7	63	3339	2	prats
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	2154	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	3053	2	slots
sluts	5	45	2398	2	sluts
spats	7	50	3138	2	spats
splats	8	48	1730	2	splats
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 2 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.313	570897.8
2	DLD Change Limit	53800	296	1.546	34799.5
3	Display Results	296	296	0.076	3894.7
	(SQL Overall)	178691	296	1.935	92346.8