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

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

329 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
raters	6	39	3658	(None)
caters	8	53	3650	1	caters
craters	9	50	2189	1	craters
daters	7	48	2737	1	daters
eaters	6	55	3595	1	eaters
fraters	10	35	1721	1	fraters
gaters	7	47	2864	1	gaters
graters	8	54	1974	1	graters
haters	9	49	3040	1	haters
kraters	11	42	1234	1	kraters
maters	8	50	3239	1	maters
oaters	6	50	2979	1	oaters
paters	8	49	3583	1	paters
praters	9	49	2165	1	praters
racers	8	47	2543	1	racers
rafters	10	37	1563	1	rafters
rakers	10	41	2357	1	rakers
ranters	7	33	2364	1	ranters
rapers	8	43	2718	1	rapers
rasers	6	45	2678	1	rasers
rasters	7	46	2902	1	rasters
ratels	6	45	1821	1	ratels
rater	5	49	4328	1	rater_
rates	5	53	5201	1	rate_s
ratters	7	44	2247	1	ratters
ravers	9	46	2818	1	ravers
razers	15	49	1961	1	razers
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
armers	8	55	2027	2	armers
artels	6	62	1623	2	artels
artery	9	9	1145	2	artery
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
bracers	11	46	1670	2	bracers
bravers	12	47	1552	2	bravers
brayers	12	45	1190	2	brayers
brazers	18	45	1394	2	brazers
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
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
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
drafters	12	33	852	2	drafters
drapers	10	53	1335	2	drapers
drawers	11	36	1007	2	drawers
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
erasers	7	44	1394	2	erasers
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
framers	12	51	1382	2	framers
frater	9	45	2059	2	frater_
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	1583	2	gators
gazers	16	45	1630	2	gazers
graders	9	47	1601	2	graders
grafters	12	40	919	2	grafters
granters	9	36	1414	2	granters
grater	7	46	2544	2	grater_
grates	7	54	2989	2	grate_s
gravers	11	45	1527	2	gravers
grazers	17	51	1245	2	grazers
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
irater	6	52	1835	2	irater_
jagers	14	44	1572	2	jagers
japers	15	46	1617	2	japers
kiters	10	52	1859	2	kiters
krater	10	40	1431	2	krater_
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_
orates	6	43	2861	2	orate_s
orators	7	3	1382	2	orators
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
prater	8	48	2535	2	prater_
prates	8	46	3316	2	prate_s
prayers	12	42	1285	2	prayers
racer	7	52	3302	2	racer_
races	7	49	4324	2	race_s
rackers	13	43	2045	2	rackers
radars	7	13	1467	2	radars
rafter	9	45	1758	2	rafter_
ragees	7	46	1866	2	ragees
rages	6	45	3944	2	rage_s
raiders	8	46	1514	2	raiders
railers	7	44	2066	2	railers
raisers	7	36	1739	2	raisers
rajes	12	50	2278	2	raje_s
rakees	10	45	1697	2	rakees
raker	9	45	2979	2	raker_
rakes	9	44	4035	2	rake_s
rales	5	49	4749	2	rale_s
ramees	8	46	2089	2	ramees
ramets	8	35	1739	2	ramets
rammers	11	37	1504	2	rammers
ranees	6	46	2396	2	ranees
rangers	8	36	2104	2	rangers
rankers	11	32	1746	2	rankers
ranter	6	38	2682	2	ranter_
raper	7	49	3275	2	raper_
rapes	7	57	4072	2	rape_s
rapiers	9	50	1287	2	rapiers
rappers	11	36	1844	2	rappers
raptors	9	42	1335	2	raptors
rarer	5	47	3170	2	rarer_
rares	5	52	4744	2	rare_s
raser	5	56	3341	2	raser_
rases	5	54	4721	2	rase_s
rashers	10	40	2091	2	rashers
raspers	9	44	1592	2	raspers
raster	6	47	3144	2	raster_
ratals	6	42	1958	2	ratals
ratans	6	38	1937	2	ratans
rate	4	54	5876	2	rate__
rated	6	54	4138	2	rate_d
ratel	5	42	2488	2	rate_l
rather	9	43	1974	2	rather_
ratios	6	49	2267	2	ratios
ratos	5	55	2876	2	rat_os
rats	4	62	6037	2	rat__s
rattens	7	42	1340	2	rattens
ratter	6	43	2631	2	ratter_
rattlers	8	35	1029	2	rattlers
ravels	9	47	1707	2	ravels
ravens	9	39	1688	2	ravens
raver	8	56	3149	2	raver_
raves	8	54	4197	2	rave_s
rawer	8	46	2373	2	rawer_
raxes	12	47	2939	2	raxe_s
razees	15	43	1476	2	razees
razer	14	48	2427	2	razer_
razes	14	50	3270	2	raze_s
razors	15	47	1166	2	razors
readers	8	38	2377	2	readers
realters	8	36	1404	2	realters
reamers	9	42	2108	2	reamers
reapers	9	35	2045	2	reapers
rearers	7	43	2356	2	rearers
reavers	10	83	2074	2	reavers
rebaters	10	34	1394	2	rebaters
refers	9	39	2108	2	refers
relaters	8	32	1815	2	relaters
renters	7	42	2481	2	renters
resters	7	41	3040	2	resters
retears	7	28	1492	2	retears
retems	8	39	1457	2	retems
revers	9	45	2963	2	revers
ricers	8	41	2099	2	ricers
riders	7	41	2390	2	riders
rimers	8	45	2255	2	rimers
rioters	7	36	1551	2	rioters
risers	6	46	2478	2	risers
rites	5	44	4255	2	rite_s
ritters	7	40	2062	2	ritters
rivers	9	46	2654	2	rivers
roamers	9	37	1346	2	roamers
roarers	7	38	1274	2	roarers
roasters	8	36	1593	2	roasters
rogers	7	45	1791	2	rogers
rooters	7	45	2293	2	rooters
ropers	8	43	2590	2	ropers
rosters	7	37	2754	2	rosters
rotes	5	61	4390	2	rote_s
rotors	6	49	1795	2	rotors
rotters	7	44	2139	2	rotters
routers	7	48	2287	2	routers
rovers	9	54	2352	2	rovers
rowers	9	49	2457	2	rowers
ruers	5	150	1941	2	r_uers
rulers	6	43	1709	2	rulers
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
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
tracers	9	49	1784	2	tracers
traders	8	43	1695	2	traders
treaters	8	36	1584	2	treaters
urates	6	50	2776	2	urate_s
ureters	7	3	1182	2	ureters
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
writers	10	55	1349	2	writers
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	329	2.640	31269.3
3	Display Results	329	329	0.110	2990.9
	(SQL Overall)	178691	329	3.093	57772.7