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

278 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
pampero1332809(None) 
pamper124316661pamper_
pamperos14306691pamperos
pampers133615931pampers
ampere10514412_ampere
camper124722212camper_
campers134220292campers
damper114117752damper_
dampers123915692dampers
hamper134518652hamper_
hampers143616952hampers
lampers113817332lampers
pampean1335542pampean
pampered15229232pampered
pamperer14228332pamperer
paper95128662pa_per_
papers105125322pa_pers
papery134812742pa_pery
pauper103511942pauper_
paupers114311072paupers
pumper124415552pumper_
pumpers133113672pumpers
tamper104618512tamper_
tampers113516742tampers
vamper134212652vamper_
vampers143111622vampers
abampere1442853abampere
aero45435343_a__ero
amber94523213_amber_
ambers104519583_ambers
ambery133811133_ambery
ameer75618983_ameer_
ameers84015573_ameers
amped104820513_ampe_d
amperes11313983_amperes
ampler104313303_ampler_
aper66336233_a_per_
apers76629133_a_pers
apery106517903_a_pery
asper75520433_asper_
aspers86220313_aspers
bumper123714343bumper_
bumpers133912053bumpers
camber124418483camber_
cambers134017443cambers
cameo95924993cam_e_o
camera10313693cam_era
camped134720233campe_d
camphor1636133camphor
campier133313273campier_
campo115219763camp__o
caper94831623ca_per_
capers105428143ca_pers
capper124421983capper_
cappers134419403cappers
carper104923633carper_
carpers114521253carpers
champer163813413champer_
champers173311623champers
clamper134012993clamper_
clampers143211893clampers
compere134616623compere
dammer114317933dammer_
dammers123214273dammers
damner95213433damner_
damners104112113damners
damped124315583dampe_d
dampen114310593dampe_n
dampens12348563dampens
dampest12411043dampest
dapper114016633dapper_
dumper114615213dumper_
dumpers123412663dumpers
emperor1155483_emperor
empery1348683_empery
gamer84928943gam_er_
gamers94420833gam_ers
gamier93617933gamier_
gammer1112318333gammer_
gammers123214563gammers
gaper86125123ga_per_
gapers94520473ga_pers
gasper94515543gasper_
gaspers105014133gaspers
gawper12499693gawper_
gawpers13448313gawpers
hammer138120033hammer_
hammers144216063hammers
hampered16239933hampered
hamperer15379093hamperer
harper115018403harper_
harpers124916203harpers
humper134115883humper_
humpers142713523humpers
jammer174014133jammer_
jammers183710703jammers
japer146218883ja_per_
japers154616173ja_pers
japery18439143ja_pery
jasper154610383jasper_
jaspers164310463jaspers
jaspery19405253jaspery
jimper17389863jimper_
jumper173612373jumper_
jumpers18399843jumpers
lamber104418493lamber_
lambers113817113lambers
lambert113617113lambert
lamer75233703lam_er_
lamped114017543lampe_d
lamprey1434863lamprey
lapper104319953lapper_
lappers113717463lappers
limper104117853limper_
limpers113815223limpers
lumper103816653lumper_
lumpers113514483lumpers
mammer94218863mammer_
mammers104615693mammers
mamzer19459833mamzer_
mamzers20409163mamzers
mapper124516093mapper_
mappers133313783mappers
mumper123513523mumper_
mumpers133311373mumpers
namer75622103nam_er_
namers84517333nam_ers
napery11489813na_pery
napper103718283napper_
nappers114214863nappers
pacer96131613pa_cer_
pacers105124543pa_cers
pacier105018683pacier_
packer144223403packer_
packers153818893packers
padder103415493padder_
padders113312873padders
pager84728203pa_ger_
pagers94423253pa_gers
paler75436933pa_ler_
palier85023563palier_
palmer105816543palmer_
palmers113513623palmers
palmier113312173palmier_
palpebra1442683palpebra
palped114513643palpe_d
palter84423263palter_
palters94021683palters
pampa114913423pamp__a
pampas124913993pamp_as
pampeans1444703pampeans
pamperers15236863pamperers
pampering1638383pampering
pander93725523pander_
panders103423733panders
panier84425503panier_
paniers94717333paniers
panner84224763panner_
panners93621273panners
panzer174213233panzer_
panzers184012013panzers
paperboy1743723pa_perboy
papered122513173pa_pered
paperer113111903pa_perer
pappier103511603pappier_
papyri1334903pa_pyri
pareo74632603pa_re_o
parer75839903pa_rer_
parers85530743pa_rers
parker124121373parker_
parkers133816873parkers
parser84822373parser_
parsers94118153parsers
paseo77022513pa_se_o
passer84721033passer_
passers94717753passers
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pater74740723pa_ter_
paters84935833pa_ters
patter84628263patter_
pattern93712053pattern
patters94825193patters
patzer173111643patzer_
patzers184210573patzers
paupered13216943paupered
pauser84415963pauser_
pausers94113223pausers
paver104225833pa_ver_
pavers115021823pa_vers
pawer104422973pa_wer_
pawers114818783pa_wers
pawner114212923pawner_
pawners124311073pawners
payer105125723pa_yer_
payers114621823pa_yers
peeper103614803peeper_
peepers113713673peepers
pepper93512943pepper_
peppers103311443peppers
peppery13286253peppery
pimped134913483pimpe_d
piper96523193p_iper_
pipers104318663p_ipers
plumper13318773plumper_
plumpers14357293plumpers
pomelo10238663pom_elo
pompano1345203pompano
popery134511703p_opery
popper93615963popper_
poppers103414863poppers
primero11368923primero
proper104319953proper_
propers113619033propers
pulper103513273pulper_
pulpers114612283pulpers
pumelo10257113pum_elo
pummelo13284233pummelo
pumped133915563pumpe_d
rammer103519653rammer_
rammers113715043rammers
rampart11311993rampart
ramped114617903rampe_d
raper74932753ra_per_
rapers84327183ra_pers
rapper104621573rapper_
rappers113618443rappers
rasper83917333rasper_
raspers94415923raspers
romper104213683romper_
rompers113412243rompers
sampler113212013sampler_
samplers12299403samplers
santero7311133santero
sapper103822353sapper_
sappers113518903sappers
scamper134613163scamper_
scampers143611033scampers
simper103616293simper_
simpers113014123simpers
spammer133410433spammer_
spammers14378693spammers
stamper113714403stamper_
stampers124211603stampers
swamper14349313swamper_
swampers15317473swampers
tamer75230103tam_er_
tamers84224033tam_ers
tamped114317043tampe_d
tampered13279463tampered
tamperer12248893tamperer
taper74829773ta_per_
tapers84025813ta_pers
tapper104419613tapper_
tappers113416543tappers
temper103914093temper_
tempera11329043tempera
tempers113513013tempers
tramper113812163tramper_
trampers123210393trampers
vamped144211013vampe_d
vampier14308233vampier_
vampire14296673vampire
vaquero1942643vaquero
warper114015583warper_
warpers123413583warpers
yammer133713183yammer_
yammers143410323yammers
yapper133714513yapper_
yappers144012253yappers
yauper11368543yauper_
yaupers12337663yaupers
yawper14437953yawper_
yawpers15346853yawpers
zamarro1842883zamarro
zapper193414023zapper_
zappers203911633zappers

Search took 9 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 Filter1786911340270.843211970.3
2DLD Change Limit1340272787.43618024.1
3Display Results2782780.0962895.8
 (SQL Overall)1786912788.37521336.2
 
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.