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

162 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
pamperos1430669(None) 
pampero13328091pampero_
pampers133615931pamper_s
amperes11313982_amperes
campers134220292camper_s
dampers123915692damper_s
hampers143616952hamper_s
lampers113817332lamper_s
pampeans1444702pampeans
pamper124316662pamper__
pampered15229232pampered
pamperer14228332pamperer
pamperers15236862pamperers
papers105125322pa_per_s
paupers114311072pauper_s
pumpers133113672pumper_s
tampers113516742tamper_s
vampers143111622vamper_s
abamperes1563023abamperes
ambers104519583_amber_s
ameers84015573_ameer_s
ampere10514413_amper_e
apers76629133_a_per_s
aspers86220313_asper_s
bumpers133912053bumper_s
cambers134017443camber_s
cameos105818003cam_e_os
cameras11313363cam_eras
camper124722213camper__
camphors1737053camphors
campos125217953camp__os
capers105428143ca_per_s
cappers134419403capper_s
carpers114521253carper_s
champers173311623champer_s
clampers143211893clamper_s
comperes143217973comperes
dammers123214273dammer_s
damners104112113damner_s
dampens12348563dampe_ns
damper114117753damper__
dumpers123412663dumper_s
emperor1155483_emperor
emperors1256123_emperors
gamers94420833gam_er_s
gammers123214563gammer_s
gapers94520473ga_per_s
gaspers105014133gasper_s
gawpers13448313gawper_s
hammers144216063hammer_s
hamper134518653hamper__
hampered16239933hampered
hamperer15379093hamperer
hamperers16287533hamperers
harpers124916203harper_s
humpers142713523humper_s
jammers183710703jammer_s
japers154616173ja_per_s
jaspers164310463jasper_s
jumpers18399843jumper_s
lambers113817113lamber_s
lamberts12348793lamberts
lamperses1345123lamperses
lampreys1542883lampreys
lappers113717463lapper_s
limpers113815223limper_s
lumpers113514483lumper_s
mammers104615693mammer_s
mamzers20409163mamzer_s
mappers133313783mapper_s
mumpers133311373mumper_s
namers84517333nam_er_s
nappers114214863napper_s
pacers105124543pa_cer_s
packers153818893packer_s
padders113312873padder_s
pagers94423253pa_ger_s
palmers113513623palmer_s
palpebras1542643palpebras
palters94021683palter_s
pampas124913993pamp__as
pampean1335543pampe_an
pampering1638383pampering
panders103423733pander_s
paniers94717333panier_s
panners93621273panner_s
panzers184012013panzer_s
paper95128663pa_per__
paperboy1743723pa_perboy
paperboys1843073pa_perboys
papered122513173pa_pered
paperer113111903pa_perer
paperers122410453pa_perers
papery134812743pa_per_y
papyrus1444063pa_pyrus
pareos87023773pa_re_os
parers85530743pa_rer_s
parkers133816873parker_s
parsers94118153parser_s
paseos88015813pa_se_os
passers94717753passer_s
pasterns104112623pasterns
pasters94531733paster_s
paters84935833pa_ter_s
patterns10439943patterns
patters94825193patter_s
patzers184210573patzer_s
pauper103511943pauper__
paupered13216943paupered
pauperism1544283pauperism
pausers94113223pauser_s
pavers115021823pa_ver_s
pawers114818783pa_wer_s
pawners124311073pawner_s
payers114621823pa_yer_s
peepers113713673peeper_s
peppers103311443pepper_s
pipers104318663p_iper_s
plumpers14357293plumper_s
pomelos11218133pom_elos
pompanos1445243pompanos
poppers103414863popper_s
primeros12336883primeros
propers113619033proper_s
pulpers114612283pulper_s
pumelos11196093pum_elos
pummelos14223103pummelos
pumper124415553pumper__
rammers113715043rammer_s
ramparts1245583ramparts
rapers84327183ra_per_s
rappers113618443rapper_s
raspers94415923rasper_s
rompers113412243romper_s
samplers12299403sampler_s
santeros8311193santeros
sappers113518903sapper_s
scampers143611033scamper_s
simpers113014123simper_s
spammers14378693spammer_s
stampers124211603stamper_s
swampers15317473swamper_s
tamers84224033tam_er_s
tamper104618513tamper__
tampered13279463tampered
tamperer12248893tamperer
tamperers13227313tamperers
tapers84025813ta_per_s
tappers113416543tapper_s
temperas12278233temperas
tempers113513013temper_s
trampers123210393tramper_s
vamper134212653vamper__
vampires15226033vampires
vaqueros2042313vaqueros
warpers123413583warper_s
yammers143410323yammer_s
yappers144012253yapper_s
yaupers12337663yauper_s
yawpers15346853yawper_s
zamarros1942683zamarros
zappers203911633zapper_s

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.406440125.6
2DLD Change Limit1461621627.46619577.0
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.93522519.3
 
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.