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

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

356 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
coats	7	56	3500	(None)
boats	7	56	3515	1	boats
cats	6	63	5634	1	c_ats
chats	10	57	3009	1	chats
coacts	10	53	1433	1	coacts
coals	7	61	2960	1	coals
coapts	10	46	1401	1	coapts
coast	7	52	3627	1	coast
coasts	8	57	1914	1	coasts
coat	6	75	5835	1	coat_
coati	7	56	2464	1	coati
coatis	8	51	2260	1	coatis
colts	7	66	3329	1	colts
coots	7	56	3684	1	coots
costs	7	72	3114	1	costs
cots	6	80	5484	1	co_ts
doats	6	52	2488	1	doats
goats	6	55	2730	1	goats
moats	7	58	2764	1	moats
oats	4	65	5421	1	_oats
bats	6	69	6233	2	_bats
beats	7	60	4224	2	beats
blats	7	51	3250	2	blats
bloats	8	52	1576	2	bloats
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_
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	bo_ts
botts	7	52	2486	2	botts
bouts	7	51	3131	2	bouts
brats	7	53	3601	2	brats
cabs	8	67	3942	2	c_abs
cads	7	61	4452	2	c_ads
cams	8	70	4728	2	c_ams
cans	6	50	5085	2	c_ans
cants	7	70	3694	2	cants
caps	8	71	4789	2	c_aps
carats	8	59	2902	2	carats
cars	6	73	6476	2	c_ars
carts	7	89	4629	2	carts
cast	6	71	5990	2	c_ast
casts	7	72	3779	2	casts
cat	5	82	8234	2	c_at_
cate	6	62	5460	2	c_ate
cates	7	59	5189	2	c_ates
caws	9	60	3611	2	c_aws
cays	9	54	3767	2	c_ays
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
chads	11	61	2223	2	chads
chais	10	75	3031	2	chais
chams	12	60	2850	2	chams
chants	11	50	2039	2	chants
chaos	10	56	2286	2	chaos
chaps	12	53	2606	2	chaps
chars	10	59	3664	2	chars
charts	11	58	2309	2	charts
chat	9	55	4613	2	chat_
chaws	13	50	2246	2	chaws
chays	13	53	1974	2	chays
cheats	11	45	1954	2	cheats
chits	10	54	2457	2	chits
chotts	11	36	1099	2	chotts
cists	7	66	2453	2	cists
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
cloaks	12	44	1126	2	cloaks
cloots	8	51	1369	2	cloots
clots	7	56	2764	2	clots
clouts	8	70	1720	2	clouts
coach	12	59	1945	2	coach
coact	9	61	3058	2	coact
coal	6	69	3925	2	coa_l
coala	7	75	2112	2	coala
coalas	8	74	1896	2	coalas
coaly	10	55	2159	2	coaly
coapt	9	61	3153	2	coapt
coarse	8	48	1390	2	coarse
coated	9	49	2704	2	coated
coatee	8	43	2722	2	coatee
coatees	9	38	1655	2	coatees
coater	8	43	2957	2	coater
coaters	9	35	2579	2	coaters
coax	13	69	2298	2	coa_x
coaxes	15	47	1563	2	coaxes
cobalts	11	3	920	2	cobalts
cobbs	11	50	1399	2	cobbs
cobs	8	70	4314	2	co_bs
cocas	9	59	2657	2	cocas
cocks	13	52	2716	2	cocks
cocos	9	56	2469	2	cocos
codas	8	47	2424	2	codas
codes	8	62	4729	2	codes
cods	7	68	4810	2	co_ds
coeds	8	59	2016	2	coeds
coffs	13	49	1630	2	coffs
coft	9	79	3968	2	coft_
cogs	7	73	4003	2	co_gs
cohos	10	59	2185	2	cohos
coifs	10	57	1870	2	coifs
coils	7	50	3008	2	coils
coins	7	58	3455	2	coins
coirs	7	52	2105	2	coirs
coitus	8	5	1189	2	coitus
cokes	11	55	3719	2	cokes
colas	7	54	3677	2	colas
colds	8	57	2697	2	colds
coles	7	60	5506	2	coles
cols	6	65	5308	2	co_ls
colt	6	71	5824	2	colt_
comas	9	58	3300	2	comas
comate	10	41	2484	2	comate
comates	11	41	2364	2	comates
combats	13	3	1168	2	combats
combs	11	61	2296	2	combs
comes	9	72	4699	2	comes
comets	10	58	2358	2	comets
comps	11	55	2605	2	comps
compts	12	52	1665	2	compts
comte	9	61	2547	2	comte
comtes	10	62	2281	2	comtes
conatus	9	3	1046	2	conatus
cones	7	64	5742	2	cones
conks	11	55	2570	2	conks
conns	7	50	2423	2	conns
cons	6	60	5769	2	co_ns
conte	7	66	3320	2	conte
contes	8	44	3291	2	contes
conto	7	60	2717	2	conto
contos	8	49	2323	2	contos
conus	7	67	2653	2	conus
coofs	10	59	2471	2	coofs
cooks	11	54	2914	2	cooks
cools	7	56	3263	2	cools
coons	7	67	3728	2	coons
coops	9	62	2964	2	coops
coopts	10	58	1458	2	coopts
coos	6	74	5649	2	co_os
coot	6	78	6038	2	coot_
copals	10	50	1894	2	copals
copays	13	49	1127	2	copays
copes	9	77	4710	2	copes
cops	8	67	5137	2	co_ps
corals	8	53	2514	2	corals
cords	8	60	3062	2	cords
cores	7	63	6185	2	cores
corks	11	60	2827	2	corks
corms	9	56	2622	2	corms
corns	7	60	3476	2	corns
corps	9	59	2704	2	corps
cors	6	66	5644	2	co_rs
cos	5	102	7039	2	co__s
coses	7	69	4949	2	coses
cosets	8	58	2440	2	cosets
coss	6	61	4349	2	co_ss
cost	6	80	5794	2	cost_
costa	7	55	2373	2	costa
cot	5	104	8322	2	co_t_
cotan	7	15	2178	2	cotan
cotans	8	13	1792	2	cotans
cote	6	66	4873	2	co_te
cotes	7	63	4784	2	cotes
cotta	7	58	1857	2	cotta
cottas	8	46	1557	2	cottas
counts	8	46	1827	2	counts
coups	9	55	2247	2	coups
courts	8	42	1617	2	courts
couth	10	61	2249	2	couth
couths	11	57	1541	2	couths
coves	10	55	3917	2	coves
covets	11	48	1964	2	covets
cowls	10	69	2221	2	cowls
cowpats	14	3	771	2	cowpats
cows	9	70	4664	2	co_ws
coxes	14	54	3086	2	coxes
coys	9	75	3724	2	co_ys
cozes	16	60	3324	2	cozes
crabs	9	54	2139	2	crabs
crafts	11	53	1274	2	crafts
crags	8	56	2257	2	crags
crams	9	62	2915	2	crams
craps	9	53	2864	2	craps
crass	7	63	2804	2	crass
crate	7	65	3740	2	crate
crates	8	57	3606	2	crates
craws	10	57	2312	2	craws
crits	7	55	2757	2	crits
croaks	12	58	1298	2	croaks
crofts	11	49	1059	2	crofts
cults	7	50	2255	2	cults
cunts	7	61	2512	2	cunts
cuts	6	58	4115	2	c_uts
cyans	10	57	1481	2	cyans
cysts	10	59	1277	2	cysts
czars	16	48	1291	2	czars
doat	5	69	4767	2	doat_
doits	6	62	2367	2	doits
dolts	6	56	2631	2	dolts
dots	5	56	4766	2	do_ts
drats	6	66	2837	2	drats
eats	4	70	5487	2	_eats
eclats	8	3	1303	2	eclats
fats	7	62	5250	2	_fats
feats	8	64	3275	2	feats
fiats	8	53	2448	2	fiats
flats	8	64	2974	2	flats
floats	9	68	1625	2	floats
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
fonts	8	61	2475	2	fonts
foots	8	55	2828	2	foots
forts	8	60	3445	2	forts
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
ghats	9	58	1861	2	ghats
gloats	7	45	1542	2	gloats
gnats	6	52	1771	2	gnats
goads	7	70	2285	2	goads
goals	6	55	2129	2	goals
goas	5	52	3994	2	goa_s
goat	5	62	5083	2	goat_
gouts	6	48	2617	2	gouts
groats	7	48	1665	2	groats
hats	7	68	5825	2	_hats
heats	8	58	3840	2	heats
hoars	8	59	2555	2	hoars
holts	8	56	2791	2	holts
hoots	8	48	3025	2	hoots
hosts	8	55	2670	2	hosts
hots	7	83	4933	2	ho_ts
ikats	9	53	1115	2	ikats
iotas	5	48	2111	2	iotas
jolts	12	50	1888	2	jolts
jotas	12	57	1744	2	jotas
jots	11	63	3614	2	jo_ts
kats	8	59	4433	2	_kats
khats	12	53	1601	2	khats
koans	9	58	1862	2	koans
koas	8	56	3509	2	koa_s
korats	10	54	1606	2	korats
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
loads	6	53	2337	2	loads
loafs	8	56	1699	2	loafs
loams	7	56	1986	2	loams
loans	5	60	2646	2	loans
loath	8	49	1860	2	loath
lofts	8	55	1836	2	lofts
loots	5	54	3142	2	loots
lotas	5	59	2630	2	lotas
lots	4	76	5209	2	lo_ts
louts	5	63	3027	2	louts
lovats	9	3	907	2	lovats
mats	6	54	6029	2	_mats
meats	7	50	3405	2	meats
moans	7	46	2437	2	moans
moas	6	55	4534	2	moa_s
moat	6	63	5203	2	moat_
molts	7	60	3209	2	molts
moots	7	58	3166	2	moots
morts	7	55	3356	2	morts
mosts	7	60	2854	2	mosts
mots	6	68	5316	2	mo_ts
motts	7	65	2700	2	motts
neats	5	59	3190	2	neats
nowts	8	69	1586	2	nowts
oafs	7	64	2526	2	_oafs
oaks	8	65	2790	2	_oaks
oars	4	68	4603	2	_oars
oast	4	71	5632	2	_oast
oasts	5	65	2918	2	_oasts
oat	3	98	8826	2	_oat_
oath	7	61	3215	2	_oath
oaths	8	61	1731	2	_oaths
ocas	6	67	2963	2	oca_s
oots	4	64	4644	2	_oots
opts	6	81	2474	2	_opts
orts	4	65	3833	2	_orts
outs	4	57	4696	2	_outs
pats	6	64	6085	2	_pats
peats	7	61	4019	2	peats
plats	7	55	3137	2	plats
poets	7	60	2444	2	poets
ports	7	59	3459	2	ports
posts	7	52	2878	2	posts
pots	6	64	5236	2	po_ts
pouts	7	55	3032	2	pouts
prats	7	63	3339	2	prats
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
recoats	9	26	1664	2	recoats
roads	6	65	2362	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2224	2	roars
roast	5	62	3014	2	roast
roasts	6	49	1541	2	roasts
roots	5	59	3367	2	roots
rotas	5	48	2772	2	rotas
rots	4	64	5409	2	ro_ts
routs	5	71	3341	2	routs
scats	7	59	3060	2	scats
scoots	8	53	1594	2	scoots
scots	7	40	2591	2	sco_ts
scouts	8	48	1794	2	scouts
seats	5	48	4434	2	seats
shoats	9	41	1708	2	shoats
skats	9	46	2154	2	skats
slats	5	54	3690	2	slats
soaks	9	52	2029	2	soaks
soaps	7	51	2071	2	soaps
soars	5	47	3251	2	soars
softs	8	50	1923	2	softs
soots	5	55	3621	2	soots
sorts	5	45	3666	2	sorts
sots	4	55	5245	2	so_ts
spats	7	50	3138	2	spats
stats	5	59	3336	2	stats
stoats	6	51	1748	2	stoats
swats	8	57	2686	2	swats
tats	4	68	5813	2	_tats
teats	5	56	3681	2	teats
toads	6	56	2107	2	toads
toast	5	58	3101	2	toast
toasts	6	59	1499	2	toasts
tofts	8	49	1924	2	tofts
toits	5	53	2747	2	toits
toots	5	53	3187	2	toots
torts	5	61	3812	2	torts
tots	4	66	5412	2	to_ts
touts	5	48	3039	2	touts
twats	8	66	1660	2	twats
vats	7	68	4174	2	_vats
volts	8	54	2129	2	volts
wats	7	75	5588	2	_wats
whats	11	77	1899	2	whats
woads	9	48	1844	2	woads
wonts	8	76	2154	2	wonts
worts	8	86	3118	2	worts
wots	7	63	4289	2	wo_ts

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	53800	0.296	603685.8
2	DLD Change Limit	53800	356	1.656	32487.9
3	Display Results	356	356	0.110	3236.4
	(SQL Overall)	178691	356	2.062	86659.1