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 “pewterers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
pewterers1421604(None) 
pesterers112510451pesterers
pewterer13256311pewterer_
dewaterers1442932dewaterers
enterers82214152_enterers
fetterers12267042fetterers
letterers9228112letterers
palterers11249532palterers
patterers112410122patterers
pepperers1244902pepperers
pesterer102412702pesterer_
pewters124113352pewt__ers
potterers11218662potterers
powderers15214792powderers
putterers11238362putterers
alterers82512493_alterers
banterers112410003banterers
barterers11269633barterers
batterers113110713batterers
caterers102814403_caterers
detergers11147183de_tergers
deterrers10116593de_terrers
dewaterer1343713dewaterer_
enterer72015633_enterer_
falterers12238033falterers
fetterer11207813fetterer_
filterers12206973filterers
fosterers12238023fosterers
gesturers1044283gesturers
jeerers14328923je__erers
jewelers1834713jew_elers
lecturers11124233lecturers
letterer8259223letterer_
litterers9228193litterers
loiterers936263loiterers
miterers10219683_miterers
mutterers11247373mutterers
oysterers1245573oysterers
palterer102411273palterer_
pamperers15236863pamperers
panderers12229153panderers
paperers122410453p_aperers
parterres1148053parterres
pasturers1136393pasturers
patterer103112173patterer_
peelers93615593pe__elers
peepers113713673pe__epers
peeress939503pe__eress
peltered112510453peltere_d
pelters93720313pelt__ers
pentenes10315633pentene_s
pepperer1145283pepperer_
peptizers22245033peptizers
perjurers18224463perjurers
perturbers1442633perturbers
perverters1544963perverters
pestered112814963pestere_d
pesters93827093pest__ers
petered103314973pe_tere_d
peters86624593pe_t__ers
petrels9279373pe_t_rels
petters93722363pe_t_ters
pewees11311393pew_e_e_s
pewter114013673pewt__er_
peytrels1363373peyt_rels
pilferers1444583pilferers
plasterers1286123plasterers
ponderers12248453ponderers
porteress1137933porteress
posturers1137053posturers
potterer102310263potterer_
poulterers1244563poulterers
powderer14245593powderer_
powters124015663powt__ers
puckerers1744513puckerers
putterer10209913putterer_
renderers10208093renderers
restorers95110113restorers
retirers84311533re_tirers
reverers113113153re_verers
shelterers1344343shelterers
sputterers12174583sputterers
temperers13247023temperers
tenderers10227803tenderers
titterers9236993titterers
totterers9186813totterers
utterers8218653_utterers
veneerers1244523veneerers
venturers1245523venturers
verderers1344843verderers
waterers112312783_waterers
westerners1344463westerners
winterers12209723winterers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641937.25020502.2
3Display Results93930.0462021.7
 (SQL Overall)178691937.71923149.5
 
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.