Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

234 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
palterer10241127(None) 
alterer72713991_alterer
falterer11239851falterer
paltered113012481paltered
palterers11249531palterers
patterer103112171patterer
altered83215732_altered
alterers82512492_alterers
banterer102811772banterer
barterer102711632barterer
batterer102713212batterer
caterer92815942ca_terer
faltered122810982faltered
falterers12238032falterers
filterer11258142filterer
haltere103614702haltere_
haltered123112552haltered
halteres113414592halteres
palaverer1443162palaverer
palter84423262palt__er
palters94021682palter_s
paltrier1037522paltrier
pamperer14228332pamperer
panderer112210912panderer
paperer113111902pa_perer
parterre1036982parterre
pasturer1037522pasturer
pattered112714202pattered
patterers112410122patterers
peltered112510452peltered
pesterer102412712pesterer
pewterer13256312pewterer
pilferer1344922pilferer
plasterer1178102plasterer
potterer102310262potterer
poulterer1145422poulterer
putterer10209912putterer
waterer103314072wa_terer
adherer1137573_adherer
adulterer1043553adulterer
alerter72111513_al_erter
aliener71011193_aliener
alleger8319633_alleger
allurer7348433_allurer
alter54828503_alt__er
alters64924223_alter_s
austerer838383austerer
bantered113313633bantered
banterers112410003banterers
bartered113113013bartered
barterers11269633barterers
battener10369393battener
battered113315053battered
batterers113110713batterers
bitterer10309773bitterer
blatherer14176713blatherer
bolsterer1145483bolsterer
cantered113415983cantered
caperer113013403ca_perer
capturer1246093capturer
careerer1038583careerer
catered103117773ca_tered
caterers102814403ca_terers
charterer14197323charterer
chatterer14196843chatterer
clatterer11186983clatterer
dapperer1335763dapperer
eagerer8248823ea_gerer
easterner945053easterner
enterer72015633_enterer
falter94519053falt__er
falters103916473falter_s
fastener11227833fastener
fattener11268113fattener
fetterer11207813fetterer
filtered12259043filtered
filterers12206973filterers
flatterer12187673flatterer
fosterer11239523fosterer
galere73716673gal_ere_
galeres83514333gal_eres
gartered10319583gartered
gatherer12147903gatherer
halter94420883halt__er
halters104619803halter_s
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259133hastener
jabberer1944023jabberer
latherer111310443latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
maltier93015483malt_ier
maltster1035303maltster
mastered112614003mastered
mattered112412903mattered
maturer938983ma_turer
miterer92511333_miterer
mutterer10218913mutterer
nattered92011623nattered
oysterer1136103oysterer
palaver1238753pal_aver
palavered1543923palavered
palaverers1542713palaverers
paleae84820293pal_eae_
paler75436933pal___er
palette93613983palette_
palettes103112833palettes
palfrey1533343pal_frey
palier85023563pal__ier
pallbearer1452313pallbearer
palleted1139873palleted
pallier94417163pal_lier
palmer105816543pal__mer
palmers113513623palmer_s
palmier113312173pal_mier
paltering122612893paltering
paltry114910403palt_r_y
pampered15229233pampered
pamperers15236863pamperers
pandered121812573pandered
panderers12229153panderers
panther12611443pant_her
papered122513173pa_pered
paperers122410453pa_perers
parcener1238473parcener
parer75839903pa___rer
parleyer1335633parleyer
partaker1436873partaker
parterres1148053parterres
partier93520713part_ier
partner92811393part_ner
partnered1244483partnered
partyer12337873part_yer
paster85734373past__er
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastier94320383past_ier
pastored1139963pastored
pasture9311463pasture_
pastured1138233pastured
pasturers1136393pasturers
pastures10311963pastures
patcher143515143pa_tcher
pater74740723pa_t__er
paters84935833pa_ter_s
pattee84323383patte_e_
pattened11299393pattened
patter84628263pa_t_ter
pattern93712053patter_n
patterned1265743patterned
patterns10439943patterns
patters94825193patter_s
patzer173111643pa_t_zer
paupered13216943paupered
pelter83321623pelt__er
pelters93720313pelter_s
pepperer1145283pepperer
pestered112814973pestered
pesterers112510463pesterers
petered103314973p_etered
pewterers14216043pewterers
philtered1545493philtered
pilfered1435853pilfered
pilferers1444583pilferers
pilsener1044753pilsener
plastered1288893plastered
plasterers1286123plasterers
platelet10510733platelet
plater84427693plat__er
platers93924093plater_s
platier93716293plat_ier
platter93917413plat_ter
ponderer112410193ponderer
portered112311543portered
posturer1038923posturer
pottered112311663pottered
potterers11218663potterers
poulterers1244563poulterers
powderer14245593powderer
prealtered1344943prealtered
properer1259203properer
psalter9247813psalt__er
psalteria1144003psalteria
psalteries1276563psalteries
psalters10227713psalter_s
psaltery13224733psalter_y
puckerer1645793puckerer
puttered112611143puttered
putterers11238363putterers
quarterer18145713quarterer
raftered1237663raftered
rattener8238533rattener
realtered1037893realtered
salter64325083salt__er
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltier74318633salt_ier
saltire73113033saltire_
saltires83112423saltires
saltpeter1153163saltpeter
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
shelterer1245033shelterer
silverer11216733silverer
slaverer11196993slaverer
smatterer11185813smatterer
solderer947183solderer
spattered12187643spattered
sputterer11165263sputterer
tamperer12248893tamperer
taperer92511793ta_perer
tattered92011443tattered
titterer8268523titterer
totterer8217793totterer
unaltered1037723unaltered
utterer71910463_utterer
wagerer11328493wa_gerer
waitered1238753waitered
waltzer1934383walt_zer
wanderer122210123wanderer
watered113014953wa_tered
waterers112312783wa_terers
waterier11312083wa_terier
waverer13319523wa_verer
weltered12238433weltered
winterer112110443winterer
yammerer15225483yammerer
yattered12239533yattered

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.436409841.7
2DLD Change Limit1461622347.06320694.0
3Display Results2342340.0932516.1
 (SQL Overall)1786912347.59223536.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.