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
palterer10241129(None) 
alterer72714011_alterer
falterer11239871falterer
paltered113012501paltered
palterers11249541palterers
patterer103112181patterer
altered83215752_altered
alterers82512502_alterers
banterer102811782banterer
barterer102711652barterer
batterer102713222batterer
caterer92815952ca_terer
faltered122811002faltered
falterers12238042falterers
filterer11258142filterer
haltere103614712haltere_
haltered123112572haltered
halteres113414602halteres
palaverer1443172palaverer
palter84423262palt__er
palters94021682palter_s
paltrier1037542paltrier
pamperer14228332pamperer
panderer112210912panderer
paperer113111902pa_perer
parterre1037012parterre
pasturer1037522pasturer
pattered112714212pattered
patterers112410132patterers
peltered112510452peltered
pesterer102412712pesterer
pewterer13256312pewterer
pilferer1344922pilferer
plasterer1178112plasterer
potterer102310262potterer
poulterer1145422poulterer
putterer10209912putterer
waterer103314082wa_terer
adherer1137573_adherer
adulterer1043553adulterer
alerter72111513_al_erter
aliener71011193_aliener
alleger8319633_alleger
allurer7348433_allurer
alter54828503_alt__er
alters64924223_alter_s
austerer838383austerer
bantered113313653bantered
banterers112410013banterers
bartered113113033bartered
barterers11269643barterers
battener10369403battener
battered113315073battered
batterers113110723batterers
bitterer10309783bitterer
blatherer14176723blatherer
bolsterer1145483bolsterer
cantered113415993cantered
caperer113013403ca_perer
capturer1246103capturer
careerer1038583careerer
catered103117783ca_tered
caterers102814413ca_terers
charterer14197333charterer
chatterer14196843chatterer
clatterer11186993clatterer
dapperer1335763dapperer
eagerer8248823ea_gerer
easterner945063easterner
enterer72015633_enterer
falter94519053falt__er
falters103916473falter_s
fastener11227843fastener
fattener11268113fattener
fetterer11207813fetterer
filtered12259043filtered
filterers12206973filterers
flatterer12187683flatterer
fosterer11239523fosterer
galere73716693gal_ere_
galeres83514343gal_eres
gartered10319603gartered
gatherer12147913gatherer
halter94420883halt__er
halters104619803halter_s
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259143hastener
jabberer1944023jabberer
latherer111310453latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
maltier93015483malt_ier
maltster1035303maltster
mastered112614013mastered
mattered112412913mattered
maturer938983ma_turer
miterer92511333_miterer
mutterer10218913mutterer
nattered92011633nattered
oysterer1136103oysterer
palaver1238753pal_aver
palavered1543933palavered
palaverers1542713palaverers
paleae84820293pal_eae_
paler75436943pal___er
palette93613983palette_
palettes103112833palettes
palfrey1533343pal_frey
palier85023573pal__ier
pallbearer1452313pallbearer
palleted1139873palleted
pallier94417173pal_lier
palmer105816543pal__mer
palmers113513623palmer_s
palmier113312183pal_mier
paltering122612903paltering
paltry114910403palt_r_y
pampered15229233pampered
pamperers15236863pamperers
pandered121812573pandered
panderers12229153panderers
panther12611443pant_her
papered122513173pa_pered
paperers122410453pa_perers
parcener1238473parcener
parer75839903pa___rer
parleyer1335633parleyer
partaker1436873partaker
parterres1148083parterres
partier93520713part_ier
partner92811393part_ner
partnered1244493partnered
partyer12337873part_yer
paster85734373past__er
pastern94415063paster_n
pasterns104112623pasterns
pasters94531733paster_s
pastier94320383past_ier
pastored1139973pastored
pasture9311463pasture_
pastured1138233pastured
pasturers1136393pasturers
pastures10311963pastures
patcher143515143pa_tcher
pater74740733pa_t__er
paters84935843pa_ter_s
pattee84323383patte_e_
pattened11299393pattened
patter84628263pa_t_ter
pattern93712053patter_n
patterned1265753patterned
patterns10439943patterns
patters94825193patter_s
patzer173111643pa_t_zer
paupered13216943paupered
pelter83321623pelt__er
pelters93720313pelter_s
pepperer1145283pepperer
pestered112814973pestered
pesterers112510463pesterers
petered103314973p_etered
pewterers14216043pewterers
philtered1545493philtered
pilfered1435853pilfered
pilferers1444583pilferers
pilsener1044753pilsener
plastered1288913plastered
plasterers1286123plasterers
platelet10510733platelet
plater84427693plat__er
platers93924093plater_s
platier93716293plat_ier
platter93917413plat_ter
ponderer112410193ponderer
portered112311553portered
posturer1038923posturer
pottered112311663pottered
potterers11218663potterers
poulterers1244563poulterers
powderer14245593powderer
prealtered1344943prealtered
properer1259203properer
psalter9247813psalt__er
psalteria1144013psalteria
psalteries1276563psalteries
psalters10227713psalter_s
psaltery13224733psalter_y
puckerer1645793puckerer
puttered112611153puttered
putterers11238363putterers
quarterer18145723quarterer
raftered1237673raftered
rattener8238533rattener
realtered1037903realtered
salter64325083salt__er
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltier74318633salt_ier
saltire73113043saltire_
saltires83112433saltires
saltpeter1153163saltpeter
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
shelterer1245043shelterer
silverer11216733silverer
slaverer11196993slaverer
smatterer11185813smatterer
solderer947183solderer
spattered12187653spattered
sputterer11165263sputterer
tamperer12248893tamperer
taperer92511793ta_perer
tattered92011453tattered
titterer8268523titterer
totterer8217793totterer
unaltered1037733unaltered
utterer71910463_utterer
wagerer11328493wa_gerer
waitered1238763waitered
waltzer1934383walt_zer
wanderer122210123wanderer
watered113014963wa_tered
waterers112312793wa_terers
waterier11312103wa_terier
waverer13319523wa_verer
weltered12238443weltered
winterer112110443winterer
yammerer15225483yammerer
yattered12239543yattered

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.470380193.6
2DLD Change Limit1461622347.10620568.8
3Display Results2342340.1102127.3
 (SQL Overall)1786912347.68623248.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.