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

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

340 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
mattered	11	24	1290	(None)
battered	11	33	1505	1	battered
mastered	11	26	1400	1	mastered
muttered	11	26	1079	1	muttered
nattered	9	20	1162	1	nattered
pattered	11	27	1420	1	pattered
smattered	12	18	678	1	smattered
tattered	9	20	1144	1	tattered
yattered	12	23	953	1	yattered
altered	8	32	1573	2	_altered
attired	8	23	891	2	_attired
bantered	11	33	1363	2	bantered
bartered	11	31	1301	2	bartered
battened	11	25	957	2	battened
batterer	10	27	1321	2	batterer
bettered	11	30	1183	2	bettered
bittered	11	27	1183	2	bittered
blattered	12	19	856	2	blattered
buttered	11	27	1262	2	buttered
cantered	11	34	1598	2	cantered
catered	10	31	1777	2	ca_tered
chattered	15	19	799	2	chattered
clattered	12	17	840	2	clattered
cottered	11	25	1173	2	cottered
faltered	12	28	1098	2	faltered
fathered	15	15	1043	2	fathered
fattened	12	26	828	2	fattened
fettered	12	25	949	2	fettered
flattered	13	18	862	2	flattered
gartered	10	31	958	2	gartered
gathered	13	14	937	2	gathered
gettered	10	25	861	2	gettered
guttered	10	25	916	2	guttered
haltered	12	31	1255	2	haltered
jittered	16	26	722	2	jittered
lathered	12	15	1232	2	lathered
lettered	9	29	1078	2	lettered
littered	9	25	1138	2	littered
mammered	12	23	765	2	mammered
mannered	11	24	965	2	mannered
martyred	14	3	428	2	martyred
matted	9	45	2141	2	matt__ed
matter	8	43	2534	2	matter__
matters	9	44	2175	2	matter_s
mattery	12	38	1071	2	matter_y
matured	10	3	1003	2	ma_tured
metered	10	35	1401	2	m_etered
mitered	10	32	1323	2	m_itered
mittened	11	3	636	2	mittened
mothered	14	23	1010	2	mothered
mustered	11	25	1150	2	mustered
mutterer	10	21	891	2	mutterer
paltered	11	30	1248	2	paltered
pattened	11	29	939	2	pattened
patterer	10	31	1217	2	patterer
patterned	12	6	574	2	patterned
pottered	11	23	1166	2	pottered
puttered	11	26	1114	2	puttered
raftered	12	3	766	2	raftered
rattened	9	21	862	2	rattened
scattered	12	19	735	2	scattered
shattered	13	17	820	2	shattered
smatterer	11	18	581	2	smatterer
spattered	12	18	764	2	spattered
tittered	9	23	949	2	tittered
tottered	9	20	870	2	tottered
uttered	8	27	1243	2	_uttered
waitered	12	3	875	2	waitered
watered	11	30	1495	2	wa_tered
adhered	12	3	923	3	_adhered
alterer	7	27	1399	3	_alterer
angered	9	30	1347	3	_angered
anteed	7	56	1611	3	_ante_ed
antired	8	23	1619	3	_antired
antlered	9	3	825	3	antlered
attend	7	25	897	3	_atte_nd
attended	10	3	576	3	_attended
attested	9	3	629	3	_attested
attire	6	24	1238	3	_attire_
attires	7	23	1295	3	_attires
attorned	9	5	535	3	_attorned
attuned	8	3	517	3	_attuned
badgered	13	3	621	3	badgered
bannered	11	29	932	3	bannered
banterer	10	28	1177	3	banterer
barbered	13	25	954	3	barbered
barterer	10	27	1163	3	barterer
batted	9	56	2365	3	batt__ed
battener	10	36	939	3	battener
batter	8	49	2887	3	batter__
batterers	11	31	1071	3	batterers
batterie	10	7	1153	3	batterie
batteries	11	6	1511	3	batteries
batters	9	46	2601	3	batter_s
battery	12	49	1181	3	batter_y
battled	10	42	1312	3	batt_led
betattered	13	4	314	3	betattered
bistered	11	29	1332	3	bistered
bitterer	10	30	977	3	bitterer
blathered	15	16	835	3	blathered
bothered	14	21	1039	3	bothered
cambered	15	12	900	3	cambered
cancered	13	24	1155	3	cancered
cankered	15	30	1022	3	cankered
capered	12	30	1404	3	ca_pered
captured	13	3	657	3	captured
careered	11	3	949	3	careered
caterer	9	28	1594	3	ca_terer
catted	9	54	2247	3	catt__ed
catteries	11	8	1552	3	catteries
cattery	12	38	1160	3	catter_y
centered	11	25	1352	3	centered
chaptered	17	17	679	3	chaptered
chartered	15	15	839	3	chartered
chatterer	14	19	684	3	chatterer
chittered	15	16	641	3	chittered
clatterer	11	18	698	3	clatterer
cluttered	12	18	594	3	cluttered
cratered	11	4	968	3	cratered
dackered	16	11	689	3	dackered
daggered	12	24	640	3	daggered
daikered	14	9	522	3	daikered
dandered	11	21	1096	3	dandered
dangered	11	24	851	3	dangered
dithered	13	18	929	3	dithered
dotterel	9	4	506	3	dotterel
embittered	15	4	254	3	embittered
entered	8	27	1888	3	_entered
factored	14	3	621	3	factored
falterer	11	23	985	3	falterer
fastened	12	25	785	3	fastened
fatted	10	54	1984	3	fatt__ed
fattener	11	26	811	3	fattener
fatter	9	45	2321	3	fatter__
feathered	16	18	889	3	feathered
festered	12	25	1210	3	festered
fetterer	11	20	781	3	fetterer
filtered	12	25	904	3	filtered
flattened	13	18	530	3	flattened
flatterer	12	18	767	3	flatterer
flittered	13	19	625	3	flittered
fluttered	13	18	594	3	fluttered
fostered	12	22	1045	3	fostered
frittered	13	20	516	3	frittered
gandered	11	22	1117	3	gandered
garnered	10	24	711	3	garnered
gatherer	12	14	790	3	gatherer
glittered	11	19	540	3	glittered
haltere	10	36	1470	3	haltere_
halteres	11	34	1459	3	halteres
hammered	16	21	885	3	hammered
hampered	16	23	993	3	hampered
hankered	16	28	944	3	hankered
hastened	12	23	910	3	hastened
hatred	10	48	1433	3	ha_t_red
hatted	10	49	2151	3	hatt__ed
hatter	9	47	2487	3	hatter__
hatteria	11	3	786	3	hatteria
hatters	10	42	2152	3	hatter_s
havered	14	40	1145	3	ha_vered
heathered	16	14	946	3	heathered
imbittered	15	4	208	3	imbittered
jabbered	20	3	443	3	jabbered
kashered	16	3	640	3	kashered
kittened	13	3	452	3	kittened
laagered	10	5	585	3	laagered
lackered	15	10	867	3	lackered
laddered	11	3	674	3	laddered
lagered	9	23	1115	3	la_gered
lappered	13	28	821	3	lappered
latened	8	7	1192	3	la_tened
laterad	8	3	1084	3	la_terad
latherer	11	13	1044	3	latherer
latter	6	50	2789	3	latter__
latterly	11	3	606	3	latterly
latticed	11	3	479	3	latticed
laveered	12	3	525	3	laveered
lawyered	15	3	403	3	lawyered
layered	11	25	941	3	la_yered
leathered	13	14	871	3	leathered
letterer	8	25	922	3	letterer
litterer	8	28	1017	3	litterer
loitered	9	3	818	3	loitered
lustered	9	25	1060	3	lustered
mackerel	16	4	486	3	mackerel
maddened	13	3	489	3	maddened
majored	17	3	585	3	ma_jored
malted	9	48	1986	3	malt__ed
mantelet	10	6	1382	3	mantelet
mantled	10	41	1339	3	mant_led
manured	10	3	947	3	ma_nured
marketed	15	3	732	3	marketed
marred	9	54	2104	3	ma__rred
marted	9	44	2521	3	mart__ed
marveled	14	3	643	3	marveled
masted	9	40	2580	3	mast__ed
master	8	48	3134	3	master__
masteries	11	10	1849	3	masteries
masterly	13	31	765	3	masterly
masters	9	46	2892	3	master_s
mastery	12	42	1432	3	master_y
matched	15	35	1396	3	ma_tched
mated	8	55	3778	3	ma_t__ed
mater	7	44	3886	3	ma_ter__
materiel	10	3	1125	3	ma_teriel
maters	8	50	3239	3	ma_ter_s
matier	8	43	2152	3	matier__
matres	8	45	2223	3	ma_t_res
matte	7	56	2684	3	matt__e_
mattedly	14	4	388	3	mattedly
matterful	14	4	319	3	matterful
mattering	12	23	1405	3	mattering
mattes	8	56	2453	3	matt__es
mattoid	10	7	928	3	matt_oid
mattress	10	3	653	3	mattress
mature	8	3	1346	3	ma_ture_
maturer	9	3	897	3	ma_turer
matures	9	3	1430	3	ma_tures
maundered	13	9	494	3	maundered
mayweed	16	3	416	3	maywe_ed
meandered	13	4	614	3	meandered
membered	15	3	590	3	membered
mentored	11	3	800	3	mentored
metred	9	53	1514	3	m_et_red
mettled	10	35	1054	3	mett_led
misaltered	13	4	456	3	misaltered
mistermed	14	3	836	3	mistermed
miterer	9	25	1133	3	m_iterer
mitred	9	44	1434	3	m_it_red
moldered	12	3	717	3	moldered
mongered	12	3	895	3	mongered
mortared	11	3	721	3	mortared
motored	10	3	993	3	m_otored
mottled	10	40	997	3	mott_led
murdered	12	3	602	3	murdered
murthered	15	4	447	3	murthered
mutter	8	44	1888	3	mutter__
mutterers	11	24	737	3	mutterers
mutters	9	41	1714	3	mutter_s
natter	6	44	2074	3	natter__
natters	7	37	1806	3	natter_s
natured	8	3	896	3	na_tured
neutered	9	3	742	3	neutered
oystered	12	3	692	3	oystered
palterer	10	24	1127	3	palterer
pampered	15	22	922	3	pampered
pandered	12	18	1257	3	pandered
papered	12	25	1316	3	pa_pered
partnered	12	4	447	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	693	3	paupered
peltered	11	25	1044	3	peltered
pestered	11	28	1495	3	pestered
petered	10	33	1496	3	_petered
plastered	12	8	889	3	plastered
portered	11	23	1153	3	portered
pothered	14	23	1104	3	pothered
potterer	10	23	1026	3	potterer
putterer	10	20	991	3	putterer
quartered	19	15	596	3	quartered
rapiered	11	3	605	3	rapiered
raptured	11	5	546	3	raptured
ratted	7	49	2334	3	ratt__ed
ratteen	7	32	911	3	ratte_en
rattener	8	23	853	3	rattener
ratter	6	43	2631	3	ratter__
ratters	7	44	2247	3	ratter_s
rattled	8	40	1295	3	ratt_led
realtered	10	3	789	3	realtered
remastered	13	4	564	3	remastered
reuttered	10	3	607	3	reuttered
sabered	10	32	1302	3	sa_bered
saggered	11	23	755	3	saggered
sauntered	10	3	628	3	sauntered
sauteed	8	34	961	3	saute_ed
scatterer	11	18	629	3	scatterer
scuttered	12	16	642	3	scuttered
shatterer	12	17	720	3	shatterer
shuttered	13	15	633	3	shuttered
sintered	9	22	1390	3	sintered
sistered	9	26	1280	3	sistered
skittered	14	3	463	3	skittered
slathered	13	14	854	3	slathered
smartened	12	4	426	3	smartened
smatter	9	36	1333	3	smatter__
smatterers	12	17	487	3	smatterers
smatters	10	40	1171	3	smatter_s
smothered	15	4	568	3	smothered
splattered	13	16	393	3	splattered
sputtered	12	16	632	3	sputtered
squattered	20	4	325	3	squattered
steered	8	36	1525	3	_steered
stuttered	10	14	576	3	stuttered
tabered	10	33	1159	3	ta_bered
tampered	13	27	946	3	tampered
tapered	10	26	1293	3	ta_pered
tatted	7	49	2053	3	tatt__ed
tatter	6	40	2457	3	tatter__
tatters	7	45	2048	3	tatter_s
tattled	8	43	1148	3	tatt_led
tattooed	9	4	457	3	tattooed
tautened	9	3	542	3	tautened
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
totterer	8	21	779	3	totterer
twittered	13	3	381	3	twittered
unaltered	10	3	772	3	unaltered
unattired	10	4	508	3	unattired
unuttered	10	6	573	3	unuttered
utterer	7	19	1046	3	_utterer
vatted	10	42	1473	3	vatt__ed
wafered	14	28	843	3	wa_fered
wagered	12	29	933	3	wa_gered
wandered	13	21	1079	3	wandered
waterbed	14	3	644	3	wa_terbed
waterer	10	33	1407	3	wa_terer
watter	9	32	2198	3	watter__
wattled	11	36	1050	3	watt_led
wavered	14	29	1043	3	wa_vered
weathered	16	16	851	3	weathered
weltered	12	23	843	3	weltered
westered	12	25	1186	3	westered
wintered	12	21	1157	3	wintered
withered	15	16	943	3	withered
wuthered	15	15	743	3	wuthered
yabbered	16	3	396	3	yabbered
yammered	16	22	576	3	yammered
yatter	9	41	1621	3	yatter__
yatters	10	39	1462	3	yatter_s

Search took 9 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.190	940478.9
2	DLD Change Limit	146162	340	7.966	18348.2
3	Display Results	340	340	0.143	2377.6
	(SQL Overall)	178691	340	8.299	21531.6