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

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

322 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
paters	8	49	3583	(None)
caters	8	53	3650	1	caters
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
pacers	10	51	2454	1	pacers
pagers	9	44	2325	1	pagers
palters	9	40	2168	1	palters
papers	10	51	2532	1	papers
parers	8	55	3074	1	parers
pasters	9	45	3173	1	pasters
patens	8	48	2086	1	patens
pater	7	47	4072	1	pater_
pates	7	60	4789	1	pate_s
patters	9	48	2519	1	patters
patzers	18	42	1057	1	patzers
pavers	11	50	2182	1	pavers
pawers	11	48	1878	1	pawers
payers	11	46	2182	1	payers
peters	8	66	2459	1	peters
platers	9	39	2409	1	platers
praters	9	49	2165	1	praters
raters	6	39	3658	1	raters
taters	6	49	3220	1	taters
waters	9	50	3063	1	waters
abaters	9	51	1520	2	abaters
afters	9	47	1707	2	afters
agers	6	50	2785	2	_agers
alters	6	49	2422	2	alters
apers	7	66	2913	2	_apers
apter	7	61	2020	2	apter_
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
cabers	10	50	2392	2	cabers
cagers	9	56	2419	2	cagers
caners	8	46	2920	2	caners
canters	9	48	2773	2	canters
capers	10	54	2814	2	capers
carers	8	51	3396	2	carers
carters	9	53	2725	2	carters
casters	9	47	2990	2	casters
cater	7	48	4072	2	cater_
cates	7	59	5189	2	cate_s
cavers	11	50	2684	2	cavers
citers	8	50	2298	2	citers
coaters	9	35	2579	2	coaters
craters	9	50	2189	2	craters
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
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
pacer	9	61	3161	2	pacer_
paces	9	67	4111	2	pace_s
packers	15	38	1889	2	packers
padders	11	33	1287	2	padders
padres	9	50	1698	2	padres
pager	8	47	2820	2	pager_
pages	8	52	3507	2	page_s
painters	10	30	1302	2	painters
pairs	7	53	2583	2	pa_irs
paler	7	54	3693	2	paler_
pales	7	57	5380	2	pale_s
palets	8	51	2231	2	palets
palmers	11	35	1362	2	palmers
palter	8	44	2326	2	palter_
pampers	13	36	1593	2	pampers
panders	10	34	2373	2	panders
panels	8	47	1652	2	panels
panes	7	61	4869	2	pane_s
paniers	9	47	1733	2	paniers
panners	9	36	2127	2	panners
panthers	13	5	1078	2	panthers
panzers	18	40	1201	2	panzers
paper	9	51	2866	2	paper_
papery	13	48	1274	2	papery
pareos	8	70	2377	2	pareos
parer	7	58	3990	2	parer_
pares	7	71	6448	2	pare_s
pareus	8	54	2074	2	pareus
parkers	13	38	1687	2	parkers
parrs	7	59	2867	2	pa_rrs
pars	6	75	6079	2	pa__rs
parsers	9	41	1815	2	parsers
partiers	10	35	1424	2	partiers
partners	10	27	1113	2	partners
partyers	13	27	776	2	partyers
paseos	8	80	1581	2	paseos
pases	7	53	4650	2	pase_s
passers	9	47	1775	2	passers
pastels	9	52	1518	2	pastels
paster	8	57	3437	2	paster_
pastern	9	44	1506	2	pastern
pasterns	10	41	1262	2	pasterns
pastes	8	52	3391	2	paste_s
pastors	9	41	1900	2	pastors
patchers	15	34	1330	2	patchers
pate	6	53	5046	2	pate__
pated	8	52	3784	2	pate_d
paten	7	48	2734	2	pate_n
patent	8	45	2492	2	patent
patents	9	48	1520	2	patents
pathos	11	55	1669	2	pathos
paths	10	55	2138	2	pat_hs
patins	8	75	2878	2	patins
patios	8	52	2178	2	patios
patness	9	29	1228	2	patness
patois	8	43	1936	2	patois
pats	6	64	6085	2	pat__s
pattens	9	54	1492	2	pattens
patter	8	46	2826	2	patter_
pattern	9	37	1205	2	pattern
patterns	10	43	994	2	patterns
patzer	17	31	1164	2	patzer_
paupers	11	43	1107	2	paupers
pausers	9	41	1322	2	pausers
paver	10	42	2583	2	paver_
paves	10	48	3392	2	pave_s
pawer	10	44	2297	2	pawer_
pawners	12	43	1107	2	pawners
paxes	14	49	2842	2	paxe_s
payees	11	48	1290	2	payees
payer	10	51	2572	2	payer_
payors	11	43	1264	2	payors
peers	7	51	3027	2	p_eers
pelters	9	37	2031	2	pelters
pesters	9	38	2709	2	pesters
peter	7	44	2759	2	peter_
petters	9	37	2236	2	petters
pewters	12	41	1335	2	pewters
piasters	10	29	1281	2	piasters
piers	7	59	2633	2	p_iers
pikers	12	47	1739	2	pikers
pipers	10	43	1866	2	pipers
pitiers	9	38	1265	2	pitiers
placers	11	45	1526	2	placers
plaiters	10	35	1263	2	plaiters
planers	9	45	1794	2	planers
planters	10	29	1532	2	planters
plasters	10	35	1813	2	plasters
platens	9	42	1398	2	platens
plater	8	44	2769	2	plater_
plates	8	54	3224	2	plate_s
platters	10	34	1528	2	platters
players	12	43	1376	2	players
pleaters	10	36	1379	2	pleaters
pliers	8	47	1515	2	pliers
plyers	11	49	1298	2	plyers
pokers	12	46	1792	2	pokers
polers	8	42	2564	2	polers
porters	9	37	2270	2	porters
posers	8	42	2397	2	posers
posters	9	39	2801	2	posters
pothers	12	38	1862	2	pothers
potters	9	40	2434	2	potters
potzers	18	40	1054	2	potzers
pouters	9	42	2187	2	pouters
powers	11	38	2232	2	powers
powters	12	40	1566	2	powters
prater	8	48	2535	2	prater_
prates	8	46	3316	2	prate_s
prayers	12	42	1285	2	prayers
priers	8	45	2119	2	priers
pryers	11	50	1224	2	pryers
psalters	10	22	771	2	psalters
pulers	8	38	2028	2	pulers
punters	9	36	1704	2	punters
putters	9	42	1919	2	putters
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
seaters	7	40	2894	2	seaters
skaters	11	35	1296	2	skaters
slaters	7	31	2373	2	slaters
spacers	11	38	1387	2	spacers
spaders	10	42	1447	2	spaders
sparers	9	45	1961	2	sparers
spates	8	50	2817	2	spate_s
spatters	10	39	1470	2	spatters
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
updaters	11	25	518	2	updaters
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 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	82551	0.343	520965.0
2	DLD Change Limit	82551	322	2.406	34310.5
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	2.859	62501.2