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

494 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
stampers12421160(None) 
scampers143611031scampers
stammers123611521stammers
stamper113714401stamper_
stompers123610041stompers
stumpers12318311stumpers
swampers15317471swampers
tampers113516741_tampers
campers134220292_campers
champers173311622champers
clampers143211892clampers
dampers123915692_dampers
hampers143616952_hampers
lampers113817332_lampers
pampers133615932_pampers
samplers12299402s_amplers
sappers113518902s_appers
scalpers123710862scalpers
scammers14339772scammers
scamper134613162scamper_
scarpers124712512scarpers
scaupers12378172scaupers
seamers94719432seam_ers
shammers153710842shammers
shapers124016892sha_pers
sharpers133810942sharpers
simpers113014122s_impers
slammers123511222slammers
slappers123710952slappers
snappers123510172snappers
soapers93715922soa_pers
spammers14378692spammers
stabbers12268732stabbers
stablers103611152stablers
stackers143413562stackers
staffers14247082staffers
stagers84116672sta_gers
staggers10379842staggers
stainers83212172stainers
stalkers12369852stalkers
stamens93411482stam_ens
stammels12495562stammels
stammer116013342stammer_
stamped124812812stampe_d
stampede13326162stampede
stampeders15233202stampeders
stampedes14315182stampedes
stampless1334542stampless
stamps105614022stamp__s
standers93514302standers
stapes85028732sta_pe_s
staplers103111202staplers
starers74522312sta_rers
starkers123712392starkers
starters83714772starters
starvers11459642starvers
staters73922342sta_ters
stayers103813632sta_yers
steamers103410872steam_ers
steepers103011372steepers
stemmers12378442stemmers
steppers12289282steppers
stomper114111232stomper_
stoopers103711302stoopers
stopers94217372st_opers
stoppers123910592stoppers
strappers1346742strappers
stripers103911592stripers
stumper113610092stumper_
swamper14349312swamper_
swappers15358082swappers
tamers84224032_tam_ers
tamper104618512_tamper_
tapers84025812_ta_pers
tappers113416542_tappers
tempers113513012_tempers
trampers123210392trampers
vampers143111622_vampers
abampere1442853abampere
abamperes1563023abamperes
ambers104519583__ambers
ameers84015573__ameers
ampere10514413__ampere
amperes11313983__amperes
apers76629133__a_pers
aspers86220313__aspers
attempers13103503attempers
blamers115314213blam_ers
bumpers133912053_bumpers
cambers134017443_cambers
camper124722213_camper_
capers105428143_ca_pers
cappers134419403_cappers
carpers114521253_carpers
chambers173410623chambers
chamfers18409223chamfers
champer163813413champer_
chompers17369593chompers
clambers144211293clambers
clammers143510693clammers
clamper134012993clamper_
clappers143310833clappers
claspers124410913claspers
crammers14369353crammers
crappers144011023crappers
crimpers14318933crimpers
dammers123214273_dammers
damners104112113_damners
dampens12348563_dampens
damper114117753_damper_
diapers104713913dia_pers
distempers1544293distempers
drapers105313353dra_pers
dumpers123412663_dumpers
escapers12337413esca_pers
etapes85415293eta_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
metamers1249623metam_ers
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
retempers1345023retempers
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
scalers93817263sca_lers
scalpels12345883scalpels
scalper113912923scalper_
scammer133611973scammer_
scamped144711963scampe_d
scampered1635233scampered
scamperer1544623scamperer
scamperers1643473scamperers
scampies1439333scampies
scamps125014173scamp__s
scamsters1334993scamsters
scanners10379703scanners
scapes105122263sca_pe_s
scarers94618513sca_rers
scarfers13408463scarfers
scarper114814823scarper_
scatters103612753scatters
scauper11379453scauper_
schmeers1574833schmeers
scoopers124210193scoopers
scrapers125510533scrapers
scrappers1545863scrappers
scrimpers1554643scrimpers
scummers14277783scummers
scuppers1446543scuppers
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_
shapes115124953sha_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
slapper113512473slapper_
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
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammer133410433spammer_
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
stabber113610153stabber_
stabler94014933stabler_
stables93219073stable_s
stacker134416263stacker_
stactes91914633stacte_s
stades74626243sta_de_s
staffer13299093staffer_
stager74821343sta_ger_
stages75629493sta_ge_s
stagger94212393stagger_
staggery13346243staggery
stagier83513443stagier_
staider83912613staider_
stainer73614923stainer_
stairs65416333sta__irs
stakes103927293sta_ke_s
staler64025823sta_ler_
stales65538293sta_le_s
stalker113912253stalker_
stamen84115943stam_e_n
staminas1048853staminas
stammel11607533stamme_l
stammered1444643stammered
stammerer1344063stammerer
stammerers1443133stammerers
stamp95217363stamp___
stampeded15343923stampeded
stampeder14304343stampeder
stamping133310963stamping
stances93715963stance_s
stanchers14206813stanchers
standees93310143standees
stander84316163stander_
stanes64933403sta_ne_s
stapedes11197753sta_pedes
staphs114411033sta_p_hs
stapler93913633stapler_
staples93617213sta_ples
starer64027363sta_rer_
stares66038753sta_re_s
starets73515923sta_rets
starker114114693starker_
starless81610843starless
starlets81610083starlets
stars55836573sta___rs
starter73817883starter_
startlers9236743startlers
starver104611993starver_
starves104614553starve_s
stases64225563sta_se_s
stashes103916173stashe_s
stater64427563sta_ter_
states64337083sta_te_s
stators73915583sta_tors
statues74614903statue_s
statures83711113statures
staumrels1141663staumrels
staves94525193sta_ve_s
stayer94516483sta_yer_
steadiers1035083steadiers
stealers83412213stealers
steamer93313093steam_er_
steamier1048303steamier_
steepens10277113steepens
steeper93812773steeper_
steerers82511353steerers
steers63820983st__eers
stemless1036653stemless
stemmer113210183stemmer_
stemmery15334693stemmery
stepper113010853stepper_
steppes113110693steppe_s
stickers142913033stickers
stiflers11238833stiflers
stimes85920573stim_e_s
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stipels9418953st_ipels
stipes84524053st_ipe_s
stipplers1334453stipplers
stirpes95011293stirpe_s
stirrers8266943stirrers
stivers103613543st_ivers
stockers143411073stockers
stokers114515183st_okers
stomped124110533stompe_d
stomps105612833stomp__s
stoners74817953st_oners
stookers12449793stookers
stooper93813193stooper_
stoper84320103st_oper_
stopes84525893st_ope_s
stopper113012603stopper_
storers75018683st_orers
stovers103713733st_overs
strafers11379913strafers
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
strapper1258093strapper_
strayers113510143strayers
streamers11228073stream_ers
strewers11409063strewers
striders94412123striders
strikers123611293strikers
striper94514793striper_
stripes95320573stripe_s
strippers1355773strippers
strivers113911843strivers
strokers123910903strokers
stroppers1356713stroppers
stroyers11388923stroyers
strummers1333693strummers
strumpets1362893strumpets
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumblers1334383stumblers
stumped124210153stumpe_d
stumpier1255883stumpier_
stumps104912283stump__s
stunners8277923stunners
stupes84116953st_upe_s
stupors935883st_upors
stutters83210473stutters
stylers10359353st_ylers
stymies1239213stymie_s
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
tabers84621573_ta_bers
tackers134319623_tackers
taggers93514193_taggers
tailers73720183_tailers
takers103923743_ta_kers
talers64628143_ta_lers
talkers113513213_talkers
tamburs11288613_tamburs
tamer75230103_tam_er_
tames75242013_tam_e_s
tampans113310983_tampans
tamped114317043_tampe_d
tampered13279463_tampered
tamperer12248893_tamperer
tamperers13227313_tamperers
tampons112711563_tampons
tamps95524083_tamp__s
tankers113416913_tankers
tanners74018393_tanners
taper74829773_ta_per_
tapes75838603_ta_pe_s
tapirs84113173_ta_pirs
tapper104419613_tapper_
tappets113610013_tappets
tasters74225643_tasters
taters64932203_ta_ters
tatters74520483_tatters
taupes8212673_taupe_s
tawers94118603_ta_wers
taxers134015283_ta_xers
tempehs14325153_tempehs
temper103914093_temper_
tempera11329043_tempera
temperas12278233_temperas
tempters12257293_tempters
thumpers15365713thumpers
timbers113111853_timbers
timers84420993_tim_ers
tippers113414353_tippers
topers85025323_t_opers
toppers113914603_toppers
tramper113812163tramper_
tramplers13305883tramplers
trappers123711043trappers
vamper134212653_vamper_
vitamers1334683vitam_ers
warpers123413583_warpers
whappers18276743whappers
whimpers18276613whimpers
wrappers15306933wrappers
yammers143410323_yammers
yappers144012253_yappers
yaupers12337663_yaupers
yawpers15346853_yawpers
zappers203911633_zappers

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.420425454.8
2DLD Change Limit1461624946.65621959.4
3Display Results4944940.1862655.9
 (SQL Overall)1786914947.26224606.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.