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

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

328 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
paltered	11	30	1248	(None)
altered	8	32	1573	1	_altered
faltered	12	28	1098	1	faltered
haltered	12	31	1255	1	haltered
palterer	10	24	1127	1	palterer
pattered	11	27	1420	1	pattered
peltered	11	25	1044	1	peltered
alterer	7	27	1399	2	_alterer
bantered	11	33	1363	2	bantered
bartered	11	31	1301	2	bartered
battered	11	33	1505	2	battered
cantered	11	34	1598	2	cantered
catered	10	31	1776	2	ca_tered
falterer	11	23	985	2	falterer
filtered	12	25	904	2	filtered
gartered	10	31	958	2	gartered
haltere	10	36	1470	2	haltere_
halteres	11	34	1459	2	halteres
mastered	11	26	1400	2	mastered
mattered	11	24	1290	2	mattered
nattered	9	20	1162	2	nattered
palavered	15	4	392	2	palavered
palleted	11	3	986	2	palleted
palter	8	44	2326	2	palter__
palterers	11	24	953	2	palterers
palters	9	40	2168	2	palter_s
pampered	15	22	922	2	pampered
pandered	12	18	1257	2	pandered
papered	12	25	1316	2	pa_pered
partnered	12	4	447	2	partnered
pastored	11	3	996	2	pastored
pastured	11	3	823	2	pastured
pattened	11	29	939	2	pattened
patterer	10	31	1217	2	patterer
patterned	12	6	574	2	patterned
paupered	13	21	693	2	paupered
pestered	11	28	1495	2	pestered
petered	10	33	1496	2	p_etered
philtered	15	4	549	2	philtered
pilfered	14	3	585	2	pilfered
plastered	12	8	889	2	plastered
portered	11	23	1153	2	portered
pottered	11	23	1166	2	pottered
prealtered	13	4	492	2	prealtered
puttered	11	26	1114	2	puttered
raftered	12	3	766	2	raftered
realtered	10	3	789	2	realtered
spattered	12	18	764	2	spattered
tattered	9	20	1144	2	tattered
unaltered	10	3	772	2	unaltered
waitered	12	3	875	2	waitered
watered	11	30	1495	2	wa_tered
weltered	12	23	843	2	weltered
yattered	12	23	953	2	yattered
adhered	12	3	923	3	_adhered
alerted	8	25	1222	3	_al_erted
aliened	8	10	1174	3	_aliened
alleged	9	38	931	3	_alleged
allured	8	29	917	3	_allured
alter	5	48	2850	3	_alter__
alterers	8	25	1249	3	_alterers
alters	6	49	2422	3	_alter_s
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
attired	8	23	891	3	_attired
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
battened	11	25	957	3	battened
batterer	10	27	1321	3	batterer
bettered	11	30	1183	3	bettered
bistered	11	29	1332	3	bistered
bittered	11	27	1183	3	bittered
blathered	15	16	835	3	blathered
blattered	12	19	856	3	blattered
blazered	20	3	506	3	blazered
bolstered	12	4	608	3	bolstered
buttered	11	27	1262	3	buttered
calibred	13	3	505	3	calibred
calipered	14	5	487	3	calipered
cambered	15	12	899	3	cambered
cancered	13	24	1155	3	cancered
cankered	15	30	1022	3	cankered
capered	12	30	1404	3	ca_pered
captured	13	3	656	3	captured
careered	11	3	949	3	careered
caterer	9	28	1593	3	ca_terer
centered	11	25	1352	3	centered
chaptered	17	17	678	3	chaptered
chartered	15	15	838	3	chartered
chattered	15	19	798	3	chattered
clattered	12	17	840	3	clattered
clavered	14	18	763	3	clavered
cottered	11	25	1173	3	cottered
cratered	11	4	967	3	cratered
cultured	11	3	723	3	cultured
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
elaterid	9	4	861	3	elaterid
entered	8	27	1888	3	_entered
espaliered	13	4	197	3	espaliered
factored	14	3	621	3	factored
falter	9	45	1905	3	falter__
falterers	12	23	803	3	falterers
falters	10	39	1647	3	falter_s
fastened	12	25	785	3	fastened
fathered	15	15	1043	3	fathered
fattened	12	26	828	3	fattened
festered	12	25	1210	3	festered
fettered	12	25	949	3	fettered
filterer	11	25	814	3	filterer
flattered	13	18	862	3	flattered
fleered	11	30	950	3	_fleered
fostered	12	22	1044	3	fostered
fullered	12	3	638	3	fullered
galere	7	37	1667	3	gal_ere_
galeres	8	35	1432	3	gal_eres
galleried	11	4	692	3	galleried
galleted	10	3	821	3	galleted
gandered	11	22	1117	3	gandered
garnered	10	24	711	3	garnered
gathered	13	14	937	3	gathered
gettered	10	25	861	3	gettered
guttered	10	25	915	3	guttered
halberd	13	3	604	3	halber_d
halted	10	50	1960	3	halt__ed
halter	9	44	2088	3	halter__
halters	10	46	1980	3	halter_s
hammered	16	21	884	3	hammered
hampered	16	23	992	3	hampered
hankered	16	28	944	3	hankered
hastened	12	23	910	3	hastened
hatred	10	48	1433	3	ha_t_red
havered	14	40	1145	3	ha_vered
hollered	12	3	760	3	hollered
holstered	13	4	587	3	holstered
jabbered	20	3	443	3	jabbered
jittered	16	26	722	3	jittered
kashered	16	3	640	3	kashered
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	1083	3	la_terad
lathered	12	15	1232	3	lathered
laveered	12	3	525	3	laveered
lawyered	15	3	403	3	lawyered
layered	11	25	941	3	la_yered
leered	7	38	1622	3	__leered
lettered	9	29	1078	3	lettered
littered	9	25	1138	3	littered
loitered	9	3	818	3	loitered
lustered	9	25	1060	3	lustered
malted	9	48	1985	3	malt__ed
mammered	12	23	765	3	mammered
mannered	11	24	965	3	mannered
martyred	14	3	428	3	martyred
matured	10	3	1003	3	ma_tured
metered	10	35	1401	3	_metered
misaltered	13	4	456	3	misaltered
mitered	10	32	1323	3	_mitered
moldered	12	3	717	3	moldered
mustered	11	25	1150	3	mustered
muttered	11	26	1079	3	muttered
natured	8	3	896	3	na_tured
neutered	9	3	742	3	neutered
oystered	12	3	691	3	oystered
packeted	17	14	828	3	packeted
paired	9	50	1752	3	pa__ired
palaced	12	41	1077	3	pal_aced
palaverer	14	4	316	3	palaverer
paleae	8	48	2029	3	pal_eae_
paled	8	55	3872	3	pal___ed
paler	7	54	3693	3	pal_er__
palette	9	36	1398	3	palette_
palettes	10	31	1283	3	palettes
palfrey	15	3	334	3	pal_frey
palier	8	50	2356	3	palier__
palled	9	46	2516	3	pal__led
palmated	13	25	1100	3	palmated
palmed	11	43	1464	3	pal__med
palmer	10	58	1654	3	palmer__
palmers	11	35	1362	3	palmer_s
paloverde	15	10	205	3	paloverde
palpated	13	24	976	3	palpated
palped	11	45	1364	3	pal__ped
palsied	10	29	1130	3	pal_sied
paltering	12	26	1289	3	paltering
paltrier	10	3	752	3	paltrier
paltry	11	49	1040	3	palt_r_y
pamperer	14	22	833	3	pamperer
panderer	11	22	1091	3	panderer
paneled	10	6	1257	3	pa_neled
panniered	12	4	385	3	panniered
panted	9	50	2482	3	pant__ed
pantiled	11	31	1159	3	pantiled
paperer	11	31	1190	3	pa_perer
parceled	13	3	832	3	parceled
pared	8	69	4676	3	pa___red
pargeted	12	3	867	3	pargeted
parleyed	14	3	620	3	parleyed
parred	9	50	2407	3	pa__rred
parted	9	42	2868	3	part__ed
parterre	10	3	698	3	parterre
parterres	11	4	804	3	parterres
partied	10	35	1655	3	part_ied
pasted	9	44	2690	3	past__ed
paster	8	57	3437	3	paster__
pastern	9	44	1506	3	paster_n
pasterns	10	41	1262	3	pasterns
pasters	9	45	3173	3	paster_s
pasture	9	3	1146	3	pasture_
pasturer	10	3	752	3	pasturer
pastures	10	3	1196	3	pastures
patched	15	35	1462	3	pa_tched
pated	8	52	3784	3	pa_t__ed
patented	11	8	889	3	pa_tented
pater	7	47	4072	3	pa_ter__
paters	8	49	3582	3	pa_ter_s
patined	10	51	1478	3	pa_tined
patted	9	47	2468	3	pa_t_ted
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
paveed	12	43	889	3	pa_ve_ed
peered	9	38	1948	3	p__eered
pelleted	11	3	818	3	pelleted
pelted	9	46	1775	3	pelt__ed
pelter	8	33	2162	3	pelter__
pelters	9	37	2031	3	pelter_s
peppered	12	3	611	3	peppered
pesterer	10	24	1270	3	pesterer
pewterer	13	25	631	3	pewterer
philtred	14	11	418	3	philt_red
pictured	13	4	657	3	pictured
pilferer	13	4	492	3	pilferer
pillared	11	22	808	3	pillared
plaistered	13	4	413	3	plaistered
plasterer	11	7	810	3	plasterer
plateaued	12	4	257	3	plateaued
plated	9	52	2577	3	plat__ed
platelet	10	5	1073	3	platelet
plater	8	44	2769	3	plater__
platers	9	39	2408	3	plater_s
platted	10	36	1426	3	plat_ted
pollened	11	5	777	3	pollened
pondered	12	64	1129	3	pondered
postured	11	3	949	3	postured
pothered	14	23	1104	3	pothered
potterer	10	23	1026	3	potterer
poulterer	11	4	542	3	poulterer
powdered	15	25	689	3	powdered
powered	13	29	1164	3	p_owered
psalter	9	24	781	3	psalter__
psalteria	11	4	400	3	psalteria
psalteries	12	7	656	3	psalteries
psalters	10	22	771	3	psalter_s
psaltery	13	22	473	3	psalter_y
puckered	17	3	610	3	puckered
putterer	10	20	991	3	putterer
quartered	19	15	596	3	quartered
rapiered	11	3	605	3	rapiered
raptured	11	5	546	3	raptured
rattened	9	21	862	3	rattened
sabered	10	32	1302	3	sa_bered
saggered	11	23	755	3	saggered
salted	7	41	2120	3	salt__ed
salter	6	43	2508	3	salter__
saltern	7	40	1065	3	salter_n
salterns	8	38	889	3	salterns
salters	7	36	2225	3	salter_s
saltire	7	31	1303	3	saltire_
saltires	8	31	1242	3	saltires
sauntered	10	3	628	3	sauntered
sauteed	8	34	961	3	saute_ed
scattered	12	19	735	3	scattered
shattered	13	17	820	3	shattered
sheltered	13	3	557	3	sheltered
silvered	12	23	756	3	silvered
sintered	9	22	1390	3	sintered
sistered	9	26	1280	3	sistered
skeltered	14	4	387	3	skeltered
slathered	13	14	853	3	slathered
slavered	12	18	803	3	slavered
smattered	12	18	678	3	smattered
soldered	10	3	815	3	soldered
splattered	13	16	393	3	splattered
sputtered	12	16	632	3	sputtered
sweltered	13	4	445	3	sweltered
tabered	10	33	1159	3	ta_bered
tampered	13	27	946	3	tampered
tapered	10	26	1293	3	ta_pered
tautened	9	3	542	3	tautened
teetered	9	25	830	3	teetered
telfered	12	3	488	3	telfered
tentered	9	64	1210	3	tentered
tillered	9	3	743	3	tillered
tittered	9	23	949	3	tittered
tottered	9	20	870	3	tottered
ulcered	10	3	797	3	_ulcered
uttered	8	27	1243	3	_uttered
valeted	11	3	901	3	val_eted
valleyed	15	3	401	3	valleyed
wafered	14	28	843	3	wa_fered
wagered	12	29	933	3	wa_gered
walleyed	15	3	415	3	walleyed
waltzed	20	3	349	3	walt_zed
wandered	13	21	1079	3	wandered
waterbed	14	3	644	3	wa_terbed
waterer	10	33	1407	3	wa_terer
wavered	14	29	1043	3	wa_vered
westered	12	25	1186	3	westered
wildered	13	3	663	3	wildered
wintered	12	21	1157	3	wintered
yabbered	16	3	396	3	yabbered
yammered	16	22	576	3	yammered

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.170	1051123.5
2	DLD Change Limit	146162	328	8.096	18053.6
3	Display Results	328	328	0.123	2666.7
	(SQL Overall)	178691	328	8.389	21300.6