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

Here are the results of your fuzzy-string dictionary search for “tattered” 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
tattered	9	20	1144	(None)
battered	11	33	1505	1	battered
mattered	11	24	1290	1	mattered
nattered	9	20	1162	1	nattered
pattered	11	27	1420	1	pattered
tittered	9	23	949	1	tittered
tottered	9	20	870	1	tottered
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
betattered	13	4	314	2	betattered
bettered	11	30	1184	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
mastered	11	26	1400	2	mastered
muttered	11	26	1079	2	muttered
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
smattered	12	18	678	2	smattered
spattered	12	18	764	2	spattered
stuttered	10	14	576	2	stuttered
tabered	10	33	1159	2	ta_bered
tampered	13	27	946	2	tampered
tapered	10	26	1293	2	ta_pered
tatted	7	49	2053	2	tatt__ed
tatter	6	40	2457	2	tatter__
tatters	7	45	2048	2	tatter_s
tattled	8	43	1148	2	tatt_led
tattooed	9	4	457	2	tattooed
tautened	9	3	542	2	tautened
teetered	9	25	830	2	teetered
tentered	9	64	1210	2	tentered
tethered	12	3	849	2	tethered
titterer	8	26	852	2	titterer
totterer	8	21	779	2	totterer
twittered	13	3	381	2	twittered
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	826	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
bistered	11	29	1333	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
entered	8	27	1888	3	_entered
factored	14	3	622	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	1211	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
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
mammered	12	23	765	3	mammered
mannered	11	24	965	3	mannered
martyred	14	3	428	3	martyred
matted	9	45	2141	3	matt__ed
matter	8	43	2534	3	matter__
matters	9	44	2175	3	matter_s
mattery	12	38	1071	3	matter_y
matured	10	3	1004	3	ma_tured
metered	10	35	1401	3	_metered
mitered	10	32	1323	3	_mitered
mittened	11	3	636	3	mittened
mothered	14	23	1010	3	mothered
mustered	11	25	1150	3	mustered
mutterer	10	21	891	3	mutterer
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	923	3	pampered
pandered	12	18	1257	3	pandered
papered	12	25	1317	3	pa_pered
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
peltered	11	25	1045	3	peltered
pestered	11	28	1497	3	pestered
petered	10	33	1497	3	_petered
plastered	12	8	889	3	plastered
portered	11	23	1154	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	547	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
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
smatterer	11	18	581	3	smatterer
splattered	13	16	393	3	splattered
sputtered	12	16	632	3	sputtered
squattered	20	4	325	3	squattered
staggered	12	4	447	3	staggered
stammered	14	4	464	3	stammered
steered	8	36	1525	3	_steered
stutterer	9	16	491	3	stutterer
tableted	11	3	753	3	tableted
tabored	10	28	1056	3	ta_bored
taboured	11	5	627	3	taboured
tafferel	14	4	312	3	tafferel
tailored	9	3	620	3	tailored
tamperer	12	24	889	3	tamperer
taperer	9	25	1179	3	ta_perer
tared	6	93	4005	3	ta___red
targeted	10	3	748	3	targeted
tarred	7	47	2028	3	ta__rred
tartare	7	30	1268	3	tartare_
tarted	7	49	2337	3	tart__ed
tarter	6	40	2356	3	tarter__
tarweed	11	3	734	3	tarwe_ed
tasseled	9	3	560	3	tasseled
tasted	7	41	2397	3	tast__ed
taster	6	49	3057	3	taster__
tasters	7	42	2564	3	taster_s
tater	5	41	3861	3	ta_ter__
taters	6	49	3220	3	ta_ter_s
tattering	10	22	1232	3	tattering
tattie	6	48	1751	3	tatt_ie_
tattier	7	42	1624	3	tatt_ier
tatties	7	41	2034	3	tatt_ies
tattle	6	41	1565	3	tatt_le_
tattler	7	31	1221	3	tatt_ler
tattlers	8	36	969	3	tattler_s
tattles	7	36	1628	3	tatt_les
tattooer	8	4	437	3	tattooer
tauted	7	53	1711	3	taut__ed
tauter	6	43	1802	3	tauter__
teddered	11	25	518	3	teddered
telfered	12	3	488	3	telfered
tempered	13	24	822	3	tempered
tendered	10	25	1060	3	tendered
tetter	6	43	2245	3	tetter__
tetters	7	43	2047	3	tetter_s
textured	16	9	548	3	textured
tiered	7	36	1397	3	__tiered
tillered	9	3	744	3	tillered
timbered	13	13	738	3	timbered
tinkered	13	8	768	3	tinkered
titter	6	34	2116	3	titter__
titterers	9	23	699	3	titterers
titters	7	42	1962	3	titter_s
tittuped	11	4	206	3	tittuped
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	t_owered
trailered	10	4	539	3	trailered
tuckered	15	3	596	3	tuckered
tutored	8	3	755	3	t_utored
tutoyered	13	4	192	3	tutoyered
tutted	7	51	1744	3	tutt__ed
twattled	12	7	346	3	twatt_led
twitterer	12	4	330	3	twitterer
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	1187	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 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.423	422437.4
2	DLD Change Limit	146162	340	6.970	20970.2
3	Display Results	340	340	0.140	2428.6
	(SQL Overall)	178691	340	7.533	23721.1