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 “pewterer” 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.

131 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
pewterer1325631(None) 
pesterer102412711pesterer
pewterers14216041pewterers
dewaterer1343712dewaterer
enterer72015632_enterer
fetterer11207812fetterer
letterer8259222letterer
palterer102411282palterer
patterer103112172patterer
peltered112510452peltered
pepperer1145282pepperer
pestered112814972pestered
pesterers112510462pesterers
petered103314972pe_tered
pewter114013672pewt__er
pewters124113352pewter_s
potterer102310262potterer
powderer14245592powderer
putterer10209912putterer
alterer72714003_alterer
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bettered113011843bettered
bitterer10309773bitterer
caterer92815943_caterer
centered112513523centered
deterger10147593de_terger
deterrer9137013de_terrer
dewatered1444743dewatered
dewaterers1442933dewaterers
eagerer8248823_eagerer
entered82718883_entered
enterers82214153_enterers
falterer11239863falterer
festered122512113festered
fettered12259493fettered
fetterers12267043fetterers
filterer11258143filterer
fosterer11239523fosterer
gesturer935983gesturer
gettered10258613gettered
jeerer13389933je__erer
jeweler1735053jew_eler
lecturer10136033lecturer
lettered92910783lettered
letterers9228113letterers
litterer82810173litterer
loiterer837083loiterer
metered103514013me_tered
miterer92511333_miterer
mutterer10218913mutterer
neutered937423neutered
oysterer1136103oysterer
paltered113012493paltered
palterers11249533palterers
pamperer14228333pamperer
panderer112210913panderer
paperer113111903p_aperer
parterre1036993parterre
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
peatier94017233peat_ier
peeler83517383pe__eler
peeper103614803pe__eper
peered93819493pe__ered
pelter83321623pelt__er
pelters93720313pelter_s
pentene9313793pentene_
pentenes10315633pentenes
peppered1236133peppered
pepperers1244903pepperers
peptizer21236473peptizer
perjurer17285903perjurer
perter84422283pert__er
perturber1343153perturber
perverter1445563perverter
pester84827593pest__er
pesters93827093pester_s
pestier94317403pest_ier
peter74427593pe_t__er
peters86624593pe_ter_s
petrel83111533pe_t_rel
petter83924773pe_t_ter
petters93722363petter_s
pettier94213613pe_ttier
pewee10319973pew_e_e_
pewees11311393pew_e_es
peytrel1264253peyt_rel
pilferer1344923pilferer
plasterer1178113plasterer
ponderer112410193ponderer
portered112311543portered
posturer1038923posturer
pottered112311663pottered
potterers11218663potterers
poulterer1145423poulterer
powdered15256893powdered
powderers15214793powderers
powered132911643pow_ered
powter114116033powt__er
powters124015663powter_s
properer1259203properer
puckerer1645793puckerer
puttered112611143puttered
putterers11238363putterers
renderer9239743renderer
restorer84813723restorer
retirer74715013re_tirer
reverer103815833re_verer
severer103511563se_verer
sewered112911243sew_ered
shelterer1245033shelterer
sputterer11165263sputterer
teetered9258303teetered
temperer12227723temperer
tenderer9228733tenderer
tentered96412103tentered
titterer8268523titterer
totterer8217793totterer
utterer71910463_utterer
veneerer1145033veneerer
venturer1137243venturer
verderer1245373verderer
waterer103314073_waterer
weltered12238433weltered
westered122511873westered
westerner1244963westerner
winterer112110443winterer

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 Limit1461621317.29620033.2
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.79522923.8
 
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.