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

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

262 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
chats	10	57	3009	(None)
cats	6	63	5634	1	c_ats
chads	11	61	2223	1	chads
chais	10	75	3031	1	chais
chams	12	60	2850	1	chams
chants	11	50	2039	1	chants
chaos	10	56	2286	1	chaos
chaps	12	53	2606	1	chaps
chars	10	59	3664	1	chars
charts	11	58	2309	1	charts
chat	9	55	4613	1	chat_
chaws	13	50	2246	1	chaws
chays	13	53	1974	1	chays
cheats	11	45	1954	1	cheats
chits	10	54	2457	1	chits
coats	7	56	3500	1	coats
ghats	9	58	1861	1	ghats
hats	7	68	5825	1	_hats
khats	12	53	1601	1	khats
whats	11	77	1899	1	whats
arhats	9	3	1297	2	arhats
bahts	10	56	1780	2	bahts
bats	6	69	6233	2	_bats
beats	7	60	4224	2	beats
bhuts	10	58	1295	2	bhuts
blats	7	51	3250	2	blats
boats	7	56	3515	2	boats
brats	7	53	3601	2	brats
cabs	8	67	3942	2	c_abs
cads	7	61	4453	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
chad	10	55	2550	2	cha_d
chaeta	11	3	1068	2	chaeta
chafe	13	51	1735	2	chafe
chafes	14	50	1791	2	chafes
chaff	16	50	1628	2	chaff
chaffs	17	45	961	2	chaffs
chai	9	59	2990	2	cha_i
chain	10	57	2367	2	chain
chains	11	48	1970	2	chains
chair	10	55	1963	2	chair
chairs	11	49	1618	2	chairs
chaise	11	49	1641	2	chaise
chalets	12	28	1347	2	chalets
chalk	14	48	1460	2	chalk
chalks	15	54	1214	2	chalks
cham	11	55	3231	2	cha_m
champ	14	50	1796	2	champ
champs	15	49	1568	2	champs
chang	11	54	1856	2	chang
changs	12	52	1537	2	changs
chant	10	59	3269	2	chant
chanty	14	52	1582	2	chanty
chao	9	57	2731	2	cha_o
chap	11	49	2849	2	cha_p
chape	12	52	2114	2	chape
chapes	13	54	2187	2	chapes
chapt	12	58	2764	2	chapt
char	9	51	3215	2	cha_r
charas	11	42	2361	2	charas
chard	11	61	2474	2	chard
chards	12	51	1973	2	chards
chare	10	52	3198	2	chare
chares	11	56	3180	2	chares
chark	14	42	2271	2	chark
charks	15	52	1970	2	charks
charm	12	61	2466	2	charm
charms	13	52	1884	2	charms
charr	10	48	2178	2	charr
charrs	11	52	1919	2	charrs
chart	10	50	3828	2	chart
chary	13	50	2313	2	chary
chase	10	51	2712	2	chase
chases	11	51	2823	2	chases
chasm	12	55	1879	2	chasm
chasms	13	55	1314	2	chasms
chasse	11	51	1460	2	chasse
chaste	11	46	1739	2	chaste
chatty	14	41	936	2	chatty
chaunts	12	6	708	2	chaunts
chaw	12	62	2463	2	cha_w
chay	12	49	2487	2	cha_y
cheaps	13	46	1368	2	cheaps
cheat	10	57	3245	2	cheat_
chefs	13	62	1466	2	chefs
cherts	11	56	1723	2	cherts
chess	10	50	1692	2	chess
chest	10	49	2614	2	chest
chests	11	49	1626	2	chests
cheth	13	50	1382	2	cheth
cheths	14	38	982	2	cheths
chews	13	54	1851	2	chews
chias	10	46	2552	2	chias
chiaus	11	36	1131	2	chiaus
chics	12	39	2094	2	chics
chins	10	56	3146	2	chins
chints	11	51	1783	2	chints
chips	12	57	2125	2	chips
chis	9	59	3331	2	ch_is
chit	9	69	3746	2	chit_
chops	12	50	1987	2	chops
chott	10	39	2393	2	chott
chotts	11	36	1099	2	chotts
chows	13	56	1820	2	chows
chubs	12	54	1262	2	chubs
chugs	11	55	1194	2	chugs
chums	12	50	1583	2	chums
chute	10	43	1646	2	chute
chutes	11	46	1577	2	chutes
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
clots	7	56	2764	2	clots
coacts	10	53	1433	2	coacts
coals	7	61	2960	2	coals
coapts	10	46	1401	2	coapts
coast	7	52	3627	2	coast
coasts	8	57	1914	2	coasts
coat	6	75	5835	2	coat_
coati	7	56	2464	2	coati
coatis	8	51	2260	2	coatis
colts	7	66	3329	2	colts
coots	7	56	3684	2	coots
costs	7	72	3114	2	costs
cots	6	80	5484	2	c_ots
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
cults	7	50	2255	2	cults
cunts	7	61	2512	2	cunts
cushats	12	28	827	2	cushats
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
dhaks	13	47	970	2	dhaks
dhals	9	54	1544	2	dhals
doats	6	52	2488	2	doats
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
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
ghast	9	56	2122	2	ghast
ghat	8	64	3528	2	ghat_
ghauts	10	44	778	2	ghauts
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
haes	7	76	5102	2	_haes
haets	8	65	2512	2	_haets
hafts	11	62	1946	2	_hafts
hags	8	67	4084	2	_hags
hahs	10	83	3336	2	_hahs
halts	8	52	3010	2	_halts
hams	9	64	4613	2	_hams
hants	8	63	3540	2	_hants
haps	9	64	4346	2	_haps
harts	8	84	4159	2	_harts
has	6	73	7265	2	_ha_s
hast	7	62	5948	2	_hast
hat	6	72	8996	2	_hat_
hate	7	84	5017	2	_hate
hates	8	67	4257	2	_hates
hath	10	59	3391	2	_hath
haws	10	64	3944	2	_haws
hays	10	61	3807	2	_hays
heats	8	58	3840	2	heats
hets	7	55	4720	2	_hets
hits	7	55	4514	2	_hits
hots	7	83	4933	2	_hots
huts	7	67	3744	2	_huts
ikats	9	53	1115	2	ikats
kats	8	59	4434	2	_kats
khafs	15	64	884	2	khafs
khans	12	46	1517	2	khans
khat	11	67	3073	2	khat_
khets	12	49	1343	2	khets
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
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
pats	6	64	6085	2	_pats
peats	7	61	4019	2	peats
phat	9	58	3786	2	phat_
phots	10	54	1850	2	phots
phuts	10	46	1350	2	phuts
plats	7	55	3137	2	plats
prats	7	63	3339	2	prats
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
scats	7	59	3060	2	scats
schavs	14	3	649	2	schavs
seats	5	48	4434	2	seats
shads	9	51	2448	2	shads
shafts	12	54	1144	2	shafts
shags	9	51	2386	2	shags
shahs	11	59	1951	2	shahs
shams	10	58	2941	2	shams
shat	7	64	5660	2	shat_
shaws	11	62	2626	2	shaws
shays	11	60	2143	2	shays
shits	8	47	3117	2	shits
shoats	9	41	1708	2	shoats
shots	8	47	3085	2	shots
shuts	8	56	2248	2	shuts
skats	9	46	2154	2	skats
slats	5	54	3690	2	slats
spats	7	50	3138	2	spats
stats	5	59	3336	2	stats
swats	8	57	2686	2	swats
tats	4	68	5813	2	_tats
teats	5	56	3681	2	teats
that	7	56	3932	2	that_
thaws	11	65	1546	2	thaws
twats	8	66	1660	2	twats
unhats	9	11	1062	2	unhats
vats	7	68	4174	2	_vats
wats	7	75	5588	2	_wats
whams	13	55	1564	2	whams
whaps	13	51	1516	2	whaps
what	10	54	3407	2	what_
wheats	12	50	1322	2	wheats
whets	11	50	1961	2	whets
whits	11	59	2382	2	whits

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.313	570897.8
2	DLD Change Limit	53800	262	1.640	32804.9
3	Display Results	262	262	0.080	3275.0
	(SQL Overall)	178691	262	2.033	87895.2