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

158 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
pamperer1422833(None) 
hamperer15379091hamperer
pampered15229231pampered
pamperers15236861pamperers
paperer113111901pa_perer
tamperer12248891tamperer
ampere10514412_ampere_
amperes11313982_amperes
caperer113013402ca_perer
dampener1335532dampener
dapperer1335762dapperer
hammerer15278142hammerer
hampered16239932hampered
hamperers16287532hamperers
palterer102411272palterer
pamper124316662pamp__er
pampero13328092pamper_o
pamperos14306692pamperos
pampers133615932pamper_s
panderer112210912panderer
papered122513172pa_pered
paperers122410452pa_perers
patterer103112172patterer
paupered13216942paupered
pepperer1145282pepperer
properer1259202properer
scamperer1544622scamperer
simperer1237172simperer
tampered13279462tampered
tamperers13227312tamperers
taperer92511792ta_perer
temperer12227722temperer
yammerer15225482yammerer
abampere1442853abampere_
abamperes1563023abamperes
adherer1137573_adherer
alterer72713993_alterer
ambeer104511603_ambe_er
ameer75618983_am_e_er
amercer1146373_am_ercer
ammeter1148393_ammeter
ampler104313303_amp_ler
asperser10408303_asperser
aspirer967903_aspirer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bumpered1536003bumpered
cambered15129003cambered
camper124722213camp__er
campers134220293camper_s
campier133313273camp_ier
camporee1449343camporee
capered123014043ca_pered
caperers122611723ca_perers
careerer1038583careerer
caterer92815943ca_terer
chamferer19154693chamferer
clamberer15185273clamberer
comparer143611363comparer
compeer133811553compe_er
compere134616623compere_
compered153414923compered
comperes143217973comperes
cumberer14266993cumberer
damneder1243763damneder
dampened1435623dampened
dampeners1444663dampeners
damper114117753damp__er
dampers123915693damper_s
eagerer8248823ea_gerer
emperor1155483_emperor
falterer11239853falterer
gatherer12147903gatherer
hammered16218853hammered
hammerers16216563hammerers
hamper134518653hamp__er
hampers143616953hamper_s
hankerer15248233hankerer
impeder12438533_impeder
impurer1136483_impurer
jabberer1944023jabberer
kipperer16294723kipperer
lampers113817333lamper_s
lamperses1345123lamperses
lamprey1434863lamp_rey
lappered13288213lappered
latherer111310443latherer
limberer12187053limberer
lumberer12177583lumberer
mammered12237653mammered
merer75126233__m_erer
numberer12186313numberer
palaverer1443163palaverer
paltered113012483paltered
palterers11249533palterers
pampean1335543pampe_an
pampeans1444703pampeans
pampering1638383pampering
pamphlet1745733pamphlet
pandered121812573pandered
panderers12229153panderers
paper95128663pa_p__er
papers105125323pa_per_s
papery134812743pa_per_y
pappier103511593pa_ppier
parcener1238473parcener
parer75839903pa___rer
parleyer1335633parleyer
parterre1036983parterre
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
pauper103511943paup__er
paupers114311073pauper_s
peppered1236133peppered
pepperers1244903pepperers
pesterer102412713pesterer
pewterer13256313pewterer
pilferer1344923pilferer
pimpernel1542653pimpernel
pimplier1445413pimplier
plasterer1178103plasterer
ponderer112410193ponderer
potterer102310263potterer
powderer14245593powderer
preparer12169643preparer
puckerer1645793puckerer
pumper124415553pump__er
pumpers133113673pumper_s
putterer10209913putterer
rampager1344453rampager
sampler113212013samp_ler
scampered1635233scampered
scamperers1643473scamperers
simpered1338253simpered
simperers1335933simperers
stammerer1344063stammerer
stampeder14304343stampeder
tamper104618513tamp__er
tampers113516743tamper_s
tapered102612933ta_pered
taperers10269773ta_perers
tempered13248223tempered
temperers13247023temperers
vamper134212653vamp__er
vampers143111623vamper_s
vampier14308233vamp_ier
vampire14296673vampire_
vampires15226033vampires
vaporer1236983va_porer
wagerer11328493wa_gerer
wanderer122210123wanderer
waterer103314073wa_terer
waverer13319523wa_verer
whimperer19123723whimperer
yammered16225763yammered
yammerers16214453yammerers

Search took 7 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.406440125.6
2DLD Change Limit1461621586.43622710.1
3Display Results1581580.0801975.0
 (SQL Overall)1786911586.92225814.9
 
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.