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

Here are the results of your fuzzy-string dictionary search for “pottered” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

324 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
pottered	11	23	1166	(None)
cottered	11	25	1173	1	cottered
pattered	11	27	1420	1	pattered
portered	11	23	1154	1	portered
pothered	14	23	1104	1	pothered
potterer	10	23	1026	1	potterer
puttered	11	26	1114	1	puttered
tottered	9	20	870	1	tottered
battered	11	33	1505	2	battered
bettered	11	30	1183	2	bettered
bittered	11	27	1183	2	bittered
bothered	14	21	1039	2	bothered
buttered	11	27	1262	2	buttered
dotterel	9	4	506	2	dotterel
fettered	12	25	949	2	fettered
fostered	12	22	1045	2	fostered
gettered	10	25	861	2	gettered
guttered	10	25	916	2	guttered
jittered	16	26	722	2	jittered
lettered	9	29	1078	2	lettered
littered	9	25	1138	2	littered
loitered	9	3	818	2	loitered
mattered	11	24	1290	2	mattered
mothered	14	23	1010	2	mothered
muttered	11	26	1079	2	muttered
nattered	9	20	1162	2	nattered
paltered	11	30	1248	2	paltered
pattened	11	29	939	2	pattened
patterer	10	31	1217	2	patterer
patterned	12	6	574	2	patterned
peltered	11	25	1045	2	peltered
pestered	11	28	1496	2	pestered
petered	10	33	1497	2	p_etered
pondered	12	64	1129	2	pondered
postured	11	3	949	2	postured
potted	9	46	2401	2	pott__ed
potteen	9	31	967	2	potte_en
potter	8	39	2698	2	potter__
potterers	11	21	866	2	potterers
potteries	11	3	1359	2	potteries
potters	9	40	2434	2	potter_s
pottery	12	30	1107	2	potter_y
powdered	15	25	689	2	powdered
powered	13	29	1164	2	po_wered
putterer	10	20	991	2	putterer
spattered	12	18	764	2	spattered
sputtered	12	16	632	2	sputtered
tattered	9	20	1144	2	tattered
tittered	9	23	949	2	tittered
totterer	8	21	779	2	totterer
uttered	8	27	1243	2	_uttered
yattered	12	23	953	2	yattered
altered	8	32	1573	3	_altered
antlered	9	3	826	3	antlered
attired	8	23	891	3	_attired
bantered	11	33	1363	3	bantered
bartered	11	31	1301	3	bartered
battened	11	25	957	3	battened
batterer	10	27	1321	3	batterer
bistered	11	29	1332	3	bistered
bitterer	10	30	977	3	bitterer
blattered	12	19	856	3	blattered
bolstered	12	4	609	3	bolstered
bordered	12	4	893	3	bordered
bottled	10	46	1123	3	bott_led
bottomed	13	4	467	3	bottomed
bowered	13	31	1304	3	bo_wered
brothered	15	4	600	3	brothered
cantered	11	34	1598	3	cantered
catered	10	31	1777	3	_catered
centered	11	25	1352	3	centered
chattered	15	19	799	3	chattered
chittered	15	16	641	3	chittered
clattered	12	17	840	3	clattered
cluttered	12	18	594	3	cluttered
cockered	17	7	1021	3	cockered
coffered	17	3	767	3	coffered
cohered	13	35	1469	3	co_hered
compered	15	34	1492	3	compered
coopered	13	33	1093	3	coopered
coppered	15	34	1054	3	coppered
cornered	11	3	1113	3	cornered
coshered	14	6	1029	3	coshered
cotter	8	49	2667	3	cotter__
cotters	9	43	2344	3	cotter_s
cottoned	11	3	803	3	cottoned
countered	12	3	1300	3	countered
covered	13	33	1529	3	co_vered
cowered	13	32	1465	3	co_wered
cratered	11	4	968	3	cratered
dithered	13	18	929	3	dithered
doctored	12	4	561	3	doctored
doddered	12	3	494	3	doddered
donnered	10	30	775	3	donnered
dormered	12	5	567	3	dormered
dotted	8	47	1752	3	dott__ed
dotter	7	44	1934	3	dotter__
dotterels	10	4	390	3	dotterels
dotters	8	37	1597	3	dotter_s
dottrel	8	3	446	3	dott_rel
dowered	12	28	1155	3	do_wered
entered	8	27	1888	3	_entered
faltered	12	28	1098	3	faltered
fathered	15	15	1043	3	fathered
fattened	12	26	828	3	fattened
festered	12	25	1210	3	festered
fetterer	11	20	781	3	fetterer
filtered	12	25	904	3	filtered
flattered	13	18	862	3	flattered
flittered	13	19	625	3	flittered
fluttered	13	18	594	3	fluttered
foddered	14	3	455	3	foddered
fosterer	11	23	952	3	fosterer
frittered	13	20	516	3	frittered
gartered	10	31	958	3	gartered
gathered	13	14	937	3	gathered
glittered	11	19	540	3	glittered
goateed	9	30	706	3	goate_ed
goffered	16	3	452	3	goffered
haltered	12	31	1255	3	haltered
hollered	12	3	760	3	hollered
holstered	13	4	588	3	holstered
homered	13	32	1271	3	ho_mered
hoovered	15	19	541	3	hoovered
hosteled	12	3	728	3	hosteled
hotted	10	43	1994	3	hott__ed
hotter	9	47	2008	3	hotter__
hovered	14	34	1157	3	ho_vered
jotted	14	36	1517	3	jott__ed
jotter	13	43	1563	3	jotter__
jotters	14	34	1380	3	jotter_s
kittened	13	3	452	3	kittened
koshered	16	3	606	3	koshered
lathered	12	15	1232	3	lathered
letterer	8	25	922	3	letterer
litterer	8	28	1017	3	litterer
lobstered	12	4	464	3	lobstered
loiterer	8	3	708	3	loiterer
loppered	13	32	675	3	loppered
lotted	7	42	2240	3	lott__ed
lotter	6	40	2560	3	lotter__
lotteries	9	3	1107	3	lotteries
lotters	7	39	2106	3	lotter_s
lottery	10	38	983	3	lotter_y
louvered	12	4	499	3	louvered
lowered	11	27	1191	3	lo_wered
lustered	9	25	1060	3	lustered
mastered	11	26	1400	3	mastered
metered	10	35	1401	3	_metered
mitered	10	32	1323	3	_mitered
mittened	11	3	636	3	mittened
moldered	12	3	717	3	moldered
mongered	12	3	895	3	mongered
mortared	11	3	721	3	mortared
motored	10	3	993	3	mo_tored
mottled	10	40	997	3	mott_led
mustered	11	25	1150	3	mustered
mutterer	10	21	891	3	mutterer
neutered	9	3	742	3	neutered
ochered	13	26	1028	3	_ochered
offered	14	3	614	3	_offered
ordered	9	10	853	3	_ordered
osiered	8	3	712	3	_osiered
otter	5	44	2397	3	_otter__
otters	6	40	2151	3	_otter_s
outbred	10	3	1126	3	_outbred
overed	10	22	1662	3	_o_vered
oystered	12	3	692	3	oystered
palterer	10	24	1127	3	palterer
pampered	15	22	923	3	pampered
pandered	12	18	1257	3	pandered
papered	12	25	1317	3	p_apered
partnered	12	4	448	3	partnered
pastored	11	3	996	3	pastored
pastured	11	3	823	3	pastured
patted	9	47	2468	3	patt__ed
pattee	8	43	2338	3	patte_e_
patter	8	46	2826	3	patter__
patterers	11	24	1012	3	patterers
pattern	9	37	1205	3	patter_n
patterns	10	43	994	3	patterns
patters	9	48	2519	3	patter_s
paupered	13	21	694	3	paupered
peered	9	38	1949	3	p__eered
peppered	12	3	613	3	peppered
pesterer	10	24	1270	3	pesterer
petted	9	41	2152	3	pett__ed
petter	8	39	2477	3	petter__
petters	9	37	2236	3	petter_s
pettled	10	36	1151	3	pett_led
pewterer	13	25	631	3	pewterer
philtered	15	4	549	3	philtered
pictured	13	4	657	3	pictured
pilfered	14	3	585	3	pilfered
pioneered	12	5	373	3	pioneered
pitted	9	43	1959	3	pitt__ed
plastered	12	8	889	3	plastered
plotted	10	46	1237	3	plott__ed
plotter	9	41	1366	3	plotter__
plotters	10	40	1155	3	plotter_s
pocketed	17	14	714	3	pocketed
poetised	11	3	852	3	poetised
poetized	20	3	798	3	poetized
poitrel	9	3	619	3	poit_rel
pollened	11	5	778	3	pollened
pommeled	15	4	310	3	pommeled
ponderer	11	24	1019	3	ponderer
popeyed	15	3	571	3	po_peyed
pored	8	52	3451	3	po___red
portaged	12	22	846	3	portaged
portaled	11	23	920	3	portaled
ported	9	42	2324	3	port__ed
portend	10	34	1119	3	porte_nd
portended	13	4	564	3	portended
porter	8	42	2441	3	porter__
porteress	11	3	793	3	porteress
porters	9	37	2270	3	porter_s
portiere	10	3	877	3	portiere_
portieres	11	3	821	3	portieres
posted	9	37	2249	3	post__ed
posteen	9	35	1262	3	poste_en
poster	8	41	2917	3	poster__
postern	9	36	1561	3	poster_n
posterns	10	27	1372	3	posterns
posters	9	39	2801	3	poster_s
postgrad	12	4	549	3	postgrad
postteen	10	5	569	3	postte_en
posture	9	3	1325	3	posture_
posturer	10	3	892	3	posturer
postures	10	3	1378	3	postures
poteen	8	35	1426	3	po_te_en
pothead	13	38	1039	3	pothe_ad
potheen	12	25	789	3	pothe_en
pother	11	38	1885	3	pother__
potherb	14	35	868	3	pother_b
potherbs	15	38	712	3	potherbs
pothers	12	38	1862	3	pother_s
potholed	14	4	839	3	potholed
potsherd	14	3	481	3	potsher_d
pottage	10	33	1060	3	pottage_
pottages	11	29	1045	3	pottages
potteens	10	25	679	3	potteens
pottering	12	26	1200	3	pottering
pottier	9	35	1649	3	pott_ier
potties	9	37	2354	3	pott_ies
pottle	8	44	1610	3	pott_le_
pottles	9	38	1698	3	pott_les
potzer	17	44	1121	3	potzer__
potzers	18	40	1054	3	potzer_s
poulterer	11	4	542	3	poulterer
poured	9	51	1674	3	po__ured
pouted	9	40	2139	3	pout__ed
pouter	8	39	2398	3	pouter__
pouters	9	42	2187	3	pouter_s
powderer	14	24	559	3	powderer
powter	11	41	1603	3	powter__
powters	12	40	1566	3	powter_s
proctored	14	4	641	3	proctored
proffered	18	4	343	3	proffered
prospered	14	4	697	3	prospered
puckered	17	3	610	3	puckered
putted	9	42	2025	3	putt__ed
puttee	8	59	1972	3	putte_e_
puttees	9	36	1291	3	putte_es
putter	8	39	2144	3	putter__
putterers	11	23	836	3	putterers
putters	9	42	1919	3	putter_s
puttied	10	38	1116	3	putt_ied
raftered	12	3	766	3	raftered
rattened	9	21	862	3	rattened
reuttered	10	3	607	3	reuttered
rogered	9	3	955	3	ro_gered
roistered	10	3	764	3	roistered
rotted	7	45	2443	3	rott__ed
rottener	8	21	697	3	rottener
rotter	6	43	2546	3	rotter__
rotters	7	44	2139	3	rotter_s
roystered	13	4	487	3	roystered
scattered	12	19	735	3	scattered
scuttered	12	16	642	3	scuttered
shattered	13	17	820	3	shattered
shuttered	13	15	633	3	shuttered
sintered	9	22	1390	3	sintered
sistered	9	26	1280	3	sistered
skittered	14	3	463	3	skittered
smattered	12	18	678	3	smattered
smothered	15	4	568	3	smothered
sobered	10	29	1243	3	so_bered
softened	12	3	566	3	softened
soldered	10	3	815	3	soldered
sotted	7	41	2140	3	sott__ed
splattered	13	16	393	3	splattered
spluttered	13	15	317	3	spluttered
spotted	10	37	1314	3	spott__ed
spotter	9	45	1488	3	spotter__
spotters	10	43	1338	3	spotter_s
sputterer	11	16	526	3	sputterer
steered	8	36	1525	3	_steered
stuttered	10	14	576	3	stuttered
teetered	9	25	830	3	teetered
tentered	9	64	1210	3	tentered
tethered	12	3	849	3	tethered
tiered	7	36	1397	3	__tiered
titterer	8	26	852	3	titterer
tochered	14	3	791	3	tochered
tortured	9	3	584	3	tortured
totted	7	43	1995	3	tott__ed
totter	6	50	2146	3	totter__
totterers	9	18	681	3	totterers
totters	7	46	1873	3	totter_s
tottery	10	38	848	3	totter_y
towered	11	29	1140	3	to_wered
twittered	13	3	381	3	twittered
unuttered	10	6	573	3	unuttered
utterer	7	19	1046	3	_utterer
waitered	12	3	875	3	waitered
watered	11	30	1495	3	_watered
weltered	12	23	843	3	weltered
westered	12	25	1186	3	westered
wintered	12	21	1157	3	wintered
withered	15	16	943	3	withered
wondered	13	23	994	3	wondered
wotted	10	41	1571	3	wott__ed
wuthered	15	15	743	3	wuthered

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	324	7.110	20557.2
3	Display Results	324	324	0.186	1741.9
	(SQL Overall)	178691	324	7.716	23158.5