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

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

325 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
caters	8	53	3650	(None)
cabers	10	50	2392	1	cabers
cagers	9	56	2419	1	cagers
caners	8	46	2920	1	caners
canters	9	48	2773	1	canters
capers	10	54	2814	1	capers
carers	8	51	3396	1	carers
carters	9	53	2725	1	carters
casters	9	47	2990	1	casters
cater	7	48	4072	1	cater_
cates	7	59	5189	1	cate_s
cavers	11	50	2684	1	cavers
citers	8	50	2298	1	citers
coaters	9	35	2579	1	coaters
craters	9	50	2189	1	craters
daters	7	48	2737	1	daters
eaters	6	55	3595	1	eaters
gaters	7	47	2864	1	gaters
haters	9	49	3040	1	haters
maters	8	50	3239	1	maters
oaters	6	50	2979	1	oaters
paters	8	49	3583	1	paters
raters	6	39	3658	1	raters
taters	6	49	3220	1	taters
waters	9	50	3063	1	waters
abaters	9	51	1520	2	abaters
actors	8	10	1677	2	actors
afters	9	47	1707	2	afters
agers	6	50	2785	2	_agers
alters	6	49	2422	2	alters
apers	7	66	2913	2	_apers
asters	6	56	3160	2	asters
ates	4	50	4792	2	_ate_s
avers	8	51	2731	2	_avers
baiters	9	46	1930	2	baiters
bakers	12	53	2345	2	bakers
balers	8	56	2693	2	balers
banters	9	46	2311	2	banters
barters	9	42	2303	2	barters
basters	9	49	3030	2	basters
bates	7	58	4634	2	bate_s
bathers	12	47	2036	2	bathers
batters	9	46	2601	2	batters
beaters	9	49	2504	2	beaters
biters	8	39	2524	2	biters
boaters	9	34	1924	2	boaters
caber	9	51	2683	2	caber_
cablers	11	44	1671	2	cablers
cades	8	54	4073	2	cade_s
cadets	9	63	1651	2	cadets
cadgers	11	47	1200	2	cadgers
cadres	9	40	1793	2	cadres
cafes	10	64	2692	2	cafe_s
cager	8	52	2922	2	cager_
cages	8	59	3601	2	cage_s
cahiers	12	35	1067	2	cahiers
cakes	11	60	3767	2	cake_s
calkers	13	44	1469	2	calkers
callers	9	42	2196	2	callers
cambers	13	40	1744	2	cambers
camels	10	52	1708	2	camels
cameos	10	58	1800	2	cameos
camera	10	3	1369	2	camera
cameras	11	3	1336	2	cameras
cames	9	70	4731	2	came_s
campers	13	42	2029	2	campers
cancers	11	40	1858	2	cancers
caner	7	53	3477	2	caner_
canes	7	53	5037	2	cane_s
cankers	13	44	1875	2	cankers
canners	9	38	2266	2	canners
canoers	9	43	1837	2	canoers
canter	8	52	3011	2	canter_
cantors	9	46	2075	2	cantors
caper	9	48	3162	2	caper_
capes	9	54	4192	2	cape_s
cappers	13	44	1940	2	cappers
captors	11	39	1498	2	captors
carders	10	48	2035	2	carders
careers	9	52	1878	2	careers
carer	7	49	4233	2	carer_
cares	7	73	6918	2	care_s
caress	8	57	2026	2	caress
carets	8	53	3077	2	carets
carpers	11	45	2125	2	carpers
carrs	7	57	3085	2	ca_rrs
cars	6	73	6476	2	ca__rs
cartels	9	46	1812	2	cartels
carter	8	49	3227	2	carter_
cartes	8	62	3947	2	carte_s
carvers	12	48	1754	2	carvers
casern	8	47	1331	2	casern
caserns	9	47	1122	2	caserns
cases	7	50	4838	2	case_s
caster	8	52	3257	2	caster_
castes	8	56	3186	2	caste_s
castors	9	49	1944	2	castors
catchers	15	31	1406	2	catchers
cate	6	62	5460	2	cate__
catena	8	3	1248	2	catena
catenas	9	3	1311	2	catenas
cateran	9	3	1377	2	cateran
caterans	10	3	1322	2	caterans
catered	10	31	1777	2	catered
caterer	9	28	1594	2	caterer
caterers	10	28	1440	2	caterers
cateress	10	23	1161	2	cateress
cats	6	63	5634	2	cat__s
cattery	12	38	1160	2	cattery
causers	9	40	1479	2	causers
cautery	12	34	959	2	cautery
caver	10	56	2906	2	caver_
cavern	11	53	1245	2	cavern
caverns	12	45	1025	2	caverns
caves	10	56	3970	2	cave_s
ceders	9	38	1767	2	ceders
centers	9	44	2060	2	centers
cetes	7	57	3110	2	cete_s
chafers	15	45	1274	2	chafers
chanters	13	40	1674	2	chanters
chapters	15	40	1213	2	chapters
charters	13	41	1558	2	charters
chasers	12	37	1492	2	chasers
chatters	13	42	1395	2	chatters
chawers	15	44	1205	2	chawers
cheaters	13	36	1351	2	cheaters
cheers	11	45	1891	2	cheers
ciders	9	46	2009	2	ciders
citer	7	48	2733	2	citer_
cites	7	44	3559	2	cite_s
cithers	12	43	1577	2	cithers
clatters	10	33	1391	2	clatters
clavers	12	43	1490	2	clavers
clawers	12	39	1097	2	clawers
coalers	9	44	1935	2	coalers
coasters	10	43	1733	2	coasters
coatees	9	38	1655	2	coatees
coater	8	43	2957	2	coater_
coaxers	16	43	1108	2	coaxers
coders	9	54	2698	2	coders
colters	9	35	2244	2	colters
comers	10	53	2808	2	comers
cooers	8	43	2456	2	cooers
cooters	9	45	2572	2	cooters
copers	10	46	2984	2	copers
copters	11	36	2128	2	copters
corers	8	52	3107	2	corers
costers	9	41	2833	2	costers
cotes	7	63	4784	2	cote_s
cotters	9	43	2344	2	cotters
couters	9	38	2730	2	couters
covers	11	46	2796	2	covers
cowers	11	46	2553	2	cowers
crafters	13	41	995	2	crafters
crater	8	50	2664	2	crater_
crates	8	57	3606	2	crate_s
cravers	12	44	1656	2	cravers
criers	8	39	1858	2	criers
cubers	10	53	1835	2	cubers
curers	8	49	2319	2	curers
cuter	7	47	2823	2	cuter_
cutes	7	94	3832	2	cute_s
cuteys	11	56	998	2	cuteys
cutlers	9	42	1700	2	cutlers
cutters	9	42	1896	2	cutters
cyders	12	39	883	2	cyders
darers	7	59	2187	2	darers
darters	8	40	1760	2	darters
dater	6	53	3231	2	dater_
dates	6	56	3915	2	date_s
deters	7	47	2468	2	deters
doters	7	44	2391	2	doters
eagers	7	45	2368	2	eagers
easters	7	51	2568	2	easters
eater	5	46	3984	2	eater_
eatery	9	53	1635	2	eatery
elaters	7	44	2019	2	elaters
enters	6	44	2564	2	enters
esters	6	46	2773	2	esters
facers	11	55	1944	2	facers
faders	10	51	1746	2	faders
fakers	13	42	1953	2	fakers
falters	10	39	1647	2	falters
farers	9	59	2405	2	farers
fates	8	51	3923	2	fate_s
fathers	13	39	1650	2	fathers
fraters	10	35	1721	2	fraters
gagers	8	40	2133	2	gagers
gaiters	8	35	1654	2	gaiters
gamers	9	44	2083	2	gamers
gapers	9	45	2047	2	gapers
garters	8	42	1823	2	garters
gasters	8	56	2429	2	gasters
gater	6	45	3365	2	gater_
gates	6	59	3951	2	gate_s
gathers	11	43	1507	2	gathers
gators	7	41	1584	2	gators
gazers	16	45	1630	2	gazers
graters	8	54	1974	2	graters
hafters	13	46	1433	2	hafters
halers	9	49	2691	2	halers
halters	10	46	1980	2	halters
hater	8	50	3475	2	hater_
hates	8	67	4257	2	hate_s
hatters	10	42	2152	2	hatters
havers	12	47	2148	2	havers
hayers	12	44	1594	2	hayers
hazers	18	46	1595	2	hazers
heaters	10	42	2522	2	heaters
inters	6	43	2805	2	inters
jagers	14	44	1572	2	jagers
japers	15	46	1617	2	japers
kiters	10	52	1859	2	kiters
kraters	11	42	1234	2	kraters
lacers	8	52	2525	2	lacers
laders	7	49	2776	2	laders
lagers	7	48	2614	2	lagers
lakers	10	52	2515	2	lakers
lasers	6	49	2570	2	lasers
lasters	7	56	2769	2	lasters
latens	6	46	2021	2	latens
later	5	48	4392	2	later_
lathers	10	43	2188	2	lathers
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
liters	6	54	2988	2	liters
locaters	10	27	1007	2	locaters
macers	10	53	2127	2	macers
makers	12	39	2173	2	makers
masers	8	46	2345	2	masers
masters	9	46	2892	2	masters
mater	7	44	3886	2	mater_
mates	7	52	5136	2	mate_s
mateys	11	56	1094	2	mateys
matres	8	45	2223	2	matres
matters	9	44	2175	2	matters
mazers	17	39	1709	2	mazers
meters	8	56	2583	2	meters
miters	8	43	2878	2	miters
namers	8	45	1733	2	namers
nates	5	52	3833	2	nate_s
natters	7	37	1806	2	natters
niters	6	46	2421	2	niters
noters	6	40	2100	2	noters
oater	5	54	3373	2	oater_
otters	6	40	2151	2	otters
outers	6	42	3017	2	outers
oxters	13	48	1327	2	oxters
pacers	10	51	2454	2	pacers
pagers	9	44	2325	2	pagers
palters	9	40	2168	2	palters
papers	10	51	2532	2	papers
parers	8	55	3074	2	parers
pasters	9	45	3173	2	pasters
patens	8	48	2086	2	patens
pater	7	47	4072	2	pater_
pates	7	60	4789	2	pate_s
patters	9	48	2519	2	patters
patzers	18	42	1057	2	patzers
pavers	11	50	2182	2	pavers
pawers	11	48	1878	2	pawers
payers	11	46	2182	2	payers
peters	8	66	2459	2	peters
platers	9	39	2409	2	platers
praters	9	49	2165	2	praters
racers	8	47	2543	2	racers
rafters	10	37	1563	2	rafters
rakers	10	41	2357	2	rakers
ranters	7	33	2364	2	ranters
rapers	8	43	2718	2	rapers
rasers	6	45	2678	2	rasers
rasters	7	46	2902	2	rasters
ratels	6	45	1821	2	ratels
rater	5	49	4328	2	rater_
rates	5	53	5201	2	rate_s
ratters	7	44	2247	2	ratters
ravers	9	46	2818	2	ravers
razers	15	49	1961	2	razers
sabers	8	52	2473	2	sabers
sakers	10	41	2543	2	sakers
salters	7	36	2225	2	salters
sates	5	49	4932	2	sate_s
satyrs	9	3	796	2	satyrs
savers	9	38	2592	2	savers
sawers	9	46	2016	2	sawers
sayers	9	42	2159	2	sayers
scalers	9	38	1726	2	scalers
scarers	9	46	1851	2	scarers
scatters	10	36	1275	2	scatters
scoters	9	33	1381	2	scoters
seaters	7	40	2894	2	seaters
skaters	11	35	1296	2	skaters
slaters	7	31	2373	2	slaters
staters	7	39	2234	2	staters
tabers	8	46	2157	2	tabers
takers	10	39	2374	2	takers
talers	6	46	2814	2	talers
tamers	8	42	2403	2	tamers
tapers	8	40	2581	2	tapers
tasters	7	42	2564	2	tasters
tatars	6	46	1979	2	tatars
tater	5	41	3861	2	tater_
tates	5	54	4498	2	tate_s
tatters	7	45	2048	2	tatters
tawers	9	41	1860	2	tawers
taxers	13	40	1528	2	taxers
titers	6	45	2641	2	titers
toters	6	50	2636	2	toters
utters	6	38	1712	2	utters
voters	9	50	1744	2	voters
waders	10	91	2064	2	waders
wafers	12	43	1614	2	wafers
wafters	13	41	1281	2	wafters
wagers	10	51	2220	2	wagers
waiters	10	42	1862	2	waiters
wakers	13	48	2249	2	wakers
walers	9	48	2446	2	walers
wanters	10	44	2009	2	wanters
wasters	10	40	2659	2	wasters
water	8	47	3331	2	water_
watery	12	39	1449	2	watery
wavers	12	50	2247	2	wavers
waxers	16	40	1430	2	waxers
yagers	10	51	1453	2	yagers
yatters	10	39	1462	2	yatters

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	82551	0.343	520965.0
2	DLD Change Limit	82551	325	2.733	30205.3
3	Display Results	325	325	0.096	3385.4
	(SQL Overall)	178691	325	3.172	56333.9