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

241 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
pampered1522922(None) 
hampered16239931hampered
pamperer14228331pamperer
papered122513161pa_pered
paupered13216931paupered
tampered13279461tampered
ampere10514412_ampere_
amperes11313982_amperes
bumpered1536002bumpered
cambered15129002cambered
capered123014042ca_pered
compered153414922compered
dampened1435622dampened
hammered16218852hammered
hamperer15379092hamperer
lappered13288212lappered
mammered12237652mammered
paltered113012482paltered
pamper124316662pamper__
pamperers15236862pamperers
pampero13328092pamper_o
pamperos14306692pamperos
pampers133615932pamper_s
pandered121812572pandered
paperer113111902pa_perer
pattered112714202pattered
peppered1236122peppered
scampered1635232scampered
simpered1338252simpered
tamperer12248892tamperer
tapered102612932ta_pered
tempered13248212tempered
yammered16225762yammered
abampere1442853abampere_
abamperes1563023abamperes
adhered1239233_adhered
altered83215733_altered
amerced1256523_am_erced
amped104820513_amp__ed
angered93013473_angered
appeared1336143_appeared
aspersed11428293_aspersed
aspired1068173_aspired
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
calipered1454873calipered
cameoed1238383cam_eoed
camped134720233camp__ed
camper124722213camper__
campers134220293camper_s
camporee1449343camporee
campused1535253campused
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
caperer113013403ca_perer
careered1139493careered
carpeted1338943carpeted
catered103117773ca_tered
chambered19145993chambered
chamfered20165063chamfered
clambered16146133clambered
compared153811823compared
compeered1646303compeered
compere134616623compere_
comperes143217973comperes
competed154113593competed
coopered133310933coopered
coppered153410543coppered
cumbered15157963cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
damped124315583damp__ed
dampener1335533dampener
damper114117753damper__
dampers123915693damper_s
dandered112110963dandered
dangered11248513dangered
dapperer1335763dapperer
diapered1238003diapered
faltered122810983faltered
fathered151510433fathered
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
haltered123112553haltered
hammerer15278143hammerer
hamper134518653hamper__
hamperers16287533hamperers
hampers143616953hamper_s
hankered16289443hankered
happened1635653happened
havered144011453ha_vered
homered133212713hom_ered
impeded13418183_impeded
jabbered2034433jabbered
kashered1636403kashered
kippered17255623kippered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153la_gered
lamped114017543lamp__ed
lampers113817333lamper_s
lamperses1345123lamperses
lamprey1434863lamp_rey
lampyrid1642903lampyrid
lapeled10258893la_peled
lappeted13255833lappeted
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lippered13287953lippered
loppered13326753loppered
lumbered13188233lumbered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
membered1535903membered
nattered92011623nattered
numbered13147143numbered
packeted17148283packeted
paired95017523pa__ired
palavered1543923palavered
palleted1139863palleted
palpated13249763palpated
palped114513643palp__ed
palterer102411273palterer
pampean1335543pampe_an
pampeans1444703pampeans
pampering1638383pampering
pamphlet1745733pamphlet
panderer112210913panderer
paneled10612573pa_neled
panniered1243853panniered
paper95128663pa_per__
paperers122410453pa_perers
papers105125323pa_per_s
papery134812743pa_per_y
parapeted1446473parapeted
parceled1338333parceled
pared86946763pa___red
pargeted1238673pargeted
parleyed1436233parleyed
parred95024073pa__rred
partnered1244473partnered
pastored1139963pastored
pastured1138233pastured
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
pauper103511943pauper__
pauperized2443753pauperized
paupers114311073pauper_s
paveed12438893pa_ve_ed
peered93819483p__eered
peltered112510443peltered
pepperer1145273pepperer
pestered112814953pestered
petered103314963p_etered
pilfered1435853pilfered
pimped134913483pimp__ed
pimpernel1542653pimpernel
pimpled14289183pimp_led
plastered1288893plastered
plumpened1642543plumpened
pommeled1543103pommeled
pondered126411293pondered
popeyed1535703p_opeyed
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powdered15256893powdered
powered132911643p_owered
premiered14237083premiered
prepared132210863prepared
properer1259203properer
prospered1446973prospered
puckered1736103puckered
pummeled1543373pummeled
pumped133915563pump__ed
pumper124415553pumper__
pumpers133113673pumper_s
puttered112611143puttered
raftered1237663raftered
rampaged1434103rampaged
ramparted1443543ramparted
ramped114617903ramp__ed
rapiered1136053rapiered
rappeled1335003rappeled
repapered1445233repa_pered
sabered103213023sa_bered
saggered11237553saggered
sampled123410793samp_led
scamperer1544623scamperer
scarpered1435113scarpered
simmered1336863simmered
simperer1237173simperer
spattered12187643spattered
stammered1444643stammered
stampeded15343923stampeded
summered1338143summered
supered10316123_supered
tabered103311593ta_bered
tamped114317043tamp__ed
tamper104618513tamper__
tamperers13227313tamperers
tampers113516743tamper_s
tamponed1336023tamponed
taperer92511793ta_perer
tattered92011443tattered
temperer12227723temperer
timbered13137383timbered
umbered121510113_umbered
umpired1235783_umpired
unhampered1853133unhampered
vamped144211013vamp__ed
vamper134212653vamper__
vampers143111623vamper_s
vampire14296673vampire_
vampires15226033vampires
vapored1336923va_pored
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
whimpered20144023whimpered
yabbered1633963yabbered
yammerer15225483yammerer
yattered12239533yattered
zippered22244823zippered

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.1731032896.0
2DLD Change Limit1461622417.42019698.4
3Display Results2412410.1102190.9
 (SQL Overall)1786912417.70323197.6
 
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.