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

458 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
scampers14361103(None) 
campers134220291_campers
scalpers123710861scalpers
scammers14339771scammers
scamper134613161scamper_
scarpers124712511scarpers
scaupers12378171scaupers
stampers124211601stampers
swampers15317471swampers
cambers134017442_cambers
camper124722212_camper_
capers105428142_ca_pers
cappers134419402_cappers
carpers114521252_carpers
champers173311622champers
clampers143211892clampers
dampers123915692_dampers
escapers12337412esca_pers
hampers143616952_hampers
lampers113817332_lampers
pampers133615932_pampers
samplers12299402s_amplers
sappers113518902s_appers
scalers93817262sca_lers
scalpels12345882scalpels
scalper113912922scalper_
scammer133611972scammer_
scamped144711962scampe_d
scampered1635232scampered
scamperer1544622scamperer
scamperers1643472scamperers
scampies1439322scampies
scamps125014172scamp__s
scamsters1334992scamsters
scanners10379702scanners
scapes105122262sca_pe_s
scarers94618502sca_rers
scarfers13408462scarfers
scarper114814822scarper_
scatters103612752scatters
scauper11379452scauper_
schmeers1574832schmeers
scoopers124210192scoopers
scrapers125510522scrapers
scrappers1545852scrappers
scrimpers1554632scrimpers
scummers14277782scummers
scuppers1446542scuppers
seamers94719432seam_ers
shammers153710842shammers
shapers124016892sha_pers
sharpers133810942sharpers
simpers113014122s_impers
slammers123511222slammers
slappers123710942slappers
snappers123510172snappers
soapers93715922soa_pers
spammers14378692spammers
stammers123611522stammers
stamper113714402stamper_
stompers123610042stompers
stumpers12318312stumpers
swamper14349312swamper_
swappers15358082swappers
tampers113516742_tampers
trampers123210392trampers
vampers143111622_vampers
abampere1442853abampere
abamperes1563023abamperes
ambers104519583__ambers
ameers84015573__ameers
ampere10514413__ampere
amperes11313983__amperes
apers76629133__a_pers
aspers86220313__aspers
blamers115314213blam_ers
bumpers133912053_bumpers
cabers105023923_ca_bers
cablers114416713_cablers
cadgers114712003_cadgers
cagers95624193_ca_gers
cahiers123510673_cahiers
calipers1249443_calipers
calkers134414693_calkers
callers94221963_callers
camber124418483_camber_
camels105217083_cam_els
cameos105818003_cam_eos
camera10313693_cam_era
cameras11313363_cam_eras
cames97047313_cam_e_s
camlets114314623_camlets
camped134720233_campe_d
camphors1737053_camphors
campier133313273_campier_
campos125217953_camp_os
camps116330263_camp__s
campus125213923_camp_us
cancers114018583_cancers
caners84629203_ca_ners
cankers134418753_cankers
canners93822663_canners
canoers94318373_canoers
canters94827733_canters
caper94831623_ca_per_
capes95441923_ca_pe_s
capper124421983_capper_
carders104820353_carders
careers95218783_careers
carers85133963_ca_rers
carpels115315463_carpels
carper104923633_carper_
carpets113915333_carpets
carters95327253_carters
carvers124817533_carvers
casters94729903_casters
caters85336503_ca_ters
causers94014793_causers
cavers115026843_ca_vers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chompers17369593chompers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clappers143310833clappers
claspers124410913claspers
combers134516623_combers
comers105328083_com_ers
compeers143410013_compeers
compels133210883_compels
compere134616623_compere
comperes143217973_comperes
coopers114019483_coopers
copers104629843_c_opers
coppers133519753_coppers
crammers14369353crammers
crappers144011023crappers
crimpers14318933crimpers
cumbers134515413_cumbers
cummers133713483_cummers
cuppers133712213_cuppers
dammers123214273_dammers
damners104112113_damners
dampens12348563_dampens
damper114117753_damper_
diapers104713913dia_pers
drapers105313353dra_pers
dumpers123412663_dumpers
escapees12336333esca_pees
escaper11368843esca_per_
escapes113811673esca_pe_s
flamers124616363flam_ers
flappers15388383flappers
foamers123812103foam_ers
framers125113823fram_ers
gamers94420833_gam_ers
gammers123214563_gammers
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
graspers11338403graspers
hammers144216063_hammers
hamper134518653_hamper_
harpers124916203_harpers
heapers123616673hea_pers
humpers142713523_humpers
jammers183710703_jammers
japers154616173_ja_pers
jaspers164310463_jaspers
jumpers18399843_jumpers
knappers16315643knappers
lambers113817113_lambers
lappers113717463_lappers
leapers93716663lea_pers
limpers113815223_limpers
lumpers113514483_lumpers
mammers104615693_mammers
mamzers20409163_mamzers
mappers133313783_mappers
mumpers133311373_mumpers
namers84517333_nam_ers
nappers114214863_nappers
pamper124316663_pamper_
pampero13328093_pampero
pamperos14306693_pamperos
papers105125323_pa_pers
paupers114311073_paupers
plumpers14357293plumpers
pumpers133113673_pumpers
rammers113715043_rammers
rapers84327183_ra_pers
rappers113618443_rappers
raspers94415923_raspers
reamers94221083ream_ers
reapers93520453rea_pers
recamiers1345513recamiers
revampers1653443revampers
roamers93713463roam_ers
rompers113412243_rompers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sambars115113843s_ambars
samburs11369343s_amburs
sameks12409323s_am_eks
samiels939763s_amiels
samlets93813553s_amlets
sampans112411003s_ampans
sampler113212013s_ampler_
samples112815453s_amples
samps96124673s_amp__s
sanders84025943s_anders
sangers84421943s_angers
sapors84118813s_a_pors
sapper103822353s_apper_
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scabies11613333scabie_s
scalares103210983scalares
scalars93711903sca_lars
scaler84321603sca_ler_
scales84529313sca_le_s
scalier94316913scalier_
scallopers1454043scallopers
scalped124411993scalpe_d
scalpel11377713scalpe_l
scalps104315233scalp__s
scammed14479543scamme_d
scamp115717313scamp___
scampering1745323scampering
scampi12469103scamp__i
scamping153510193scamping
scampish1744893scampish
scams94423973scam___s
scamster1235303scamster_
scanner94411813scanner_
scanter94215183scanter_
scape96921843sca_pe__
scaped115519553sca_pe_d
scarcer113911373scarcer_
scarer84524603sca_rer_
scares85033003sca_re_s
scarfer124511083scarfer_
scarier94017873scarier_
scarless10189053scarless
scarlets10178573scarlets
scarped124314403scarpe_d
scarpered1435113scarpered
scarphs14437413scarp_hs
scarps104718603scarp__s
scars75433533sca___rs
scarves124511623scarve_s
scathes124515713scathe_s
scatter93815173scatter_
scaups105411933scaup__s
scaurs85512053sca__urs
scepters1237783scepters
schappes1736033schappe_s
schemers1576703schemers
schmears1584103schmears
schmeer1475363schmeer_
schmoes14308543schmoe_s
schnappers1942143schnappers
scimiters1345123scimiters
sclaffers17122523sclaffers
scoffers16286133scoffers
scolders11288993scolders
scooper113812033scooper_
scooters103511033scooters
scopes104719593sc_ope_s
scorers94115313sc_orers
scorners10228493scorners
scoters93313813sc_oters
scourers10348533scourers
scouters103411323scouters
scowders14276223scowders
scowlers13257353scowlers
scramblers16183543scramblers
scramjets2052063scramjets
scraper114513413scraper_
scrapes116217663scrape_s
scrapper1466963scrapper_
scrawlers1434743scrawlers
screamers13236253scream_ers
screwers13358053screwers
scribers12307953scribers
scrimper1455753scrimper_
scripters13116673scripters
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scumless1254993scumless
scummer13398753scummer_
scunners10357303scunners
scupper1367423scupper_
scutters103311023scutters
sealers74323553sea_lers
seamer84223613seam_er_
seamier93114633seamier_
seamless10238723seamless
seamsters1136333seamsters
seaters74028943sea_ters
seemers93814333seem_ers
shaders115915553sha_ders
shakers144015563sha_kers
shames114726223sham_e_s
shammer144613143shammer_
shammes144312833shamme_s
shampooers1742493shampooers
shampoos1544603shampoos
shaper114119933sha_per_
shapes115124943sha_pe_s
sharers104720623sha_rers
sharkers154011053sharkers
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shimmers15269413shimmers
shippers153012313shippers
shoppers153010763shoppers
shrimpers1633813shrimpers
simmers113314613s_immers
simper103616293s_imper_
sippers113117753s_ippers
skankers11316483skankers
skaters113512963ska_ters
skimmers16296463skimmers
skippers16318203skippers
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammer113913033slammer_
slanders94014013slanders
slapper113512463slapper_
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sleepers103110113sleepers
slimmers12369633slimmers
slippers123711233slippers
slopers94213093s_lopers
slumbers123110273slumbers
slummers12358933slummers
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snapper113512073snapper_
snarers74216663sna_rers
snarlers8298753snarlers
snipers93311773s_nipers
snippers12299723snippers
snoopers10319843snoopers
soakers114114953soa_kers
soaper84517873soa_per_
soarers74118093soa_rers
socagers1196363soca_gers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammer133410433spammer_
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stamens93411483stam_ens
stammels12495563stammels
stammer116013343stammer_
stamped124812813stampe_d
stampede13326163stampede
stampeders15233203stampeders
stampedes14315183stampedes
stampless1334543stampless
stamps105614023stamp__s
standers93514303standers
stapes85028733sta_pe_s
staplers103111203staplers
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
steamers103410873steam_ers
steepers103011373steepers
stemmers12378443stemmers
steppers12289283steppers
stomper114111233stomper_
stoopers103711303stoopers
stopers94217373s_topers
stoppers123910593stoppers
strappers1346743strappers
stripers103911593stripers
stumper113610093stumper_
summers113616503s_ummers
sumpters1238023s_umpters
supers84622403s__upers
suppers113314703s_uppers
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swamies123712063swamie_s
swamped15498443swampe_d
swampier1544593swampier_
swamps135910263swamp__s
swapper14359703swapper_
swarmers1346323swarmers
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
sweepers13348163sweepers
swimmers15276693swimmers
swoopers13317523swoopers
sycamores1642873sycamores
tamers84224033_tam_ers
tamper104618513_tamper_
tapers84025813_ta_pers
tappers113416543_tappers
tempers113513013_tempers
thumpers15365713thumpers
tramper113812163tramper_
tramplers13305883tramplers
trappers123711043trappers
vamper134212653_vamper_
warpers123413583_warpers
whappers18276743whappers
whimpers18276613whimpers
wrappers15306933wrappers
yammers143410323_yammers
yappers144012253_yappers
yaupers12337663_yaupers
yawpers15346853_yawpers
zappers203911633_zappers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461624587.65619091.2
3Display Results4584580.1862462.4
 (SQL Overall)1786914587.99822342.0
 
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.