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

535 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
shammer14461314(None) 
hammer138120031_hammer
scammer133611971scammer
shammed153911421shammed
shammers153710831shammers
shammes144312831shammes
shimmer143310871shimmer
slammer113913031slammer
spammer133410431spammer
stammer116013341stammer
chamber164011052chamber
chamfer17399852chamfer
champer163813402champer
charmer144913662charmer
clammer134211792clammer
crammer134010962crammer
dammer114317932_dammer
gammer1112318332_gammer
hammed144116972_hammed
hammers144216052_hammers
hammier143510652_hammier
hamper134518652_hamper
harmer114719552_harmer
hemmer134112642_hemmer
hummer133615272_hummer
jammer174014132_jammer
mammer94218862_mammer
rammer103519652_rammer
rehammer1544652rehammer
scammed14479542scammed
scammers14339772scammers
scamper134613162scamper
scummer13398752scummer
seamer84223612sea_mer
seamier93114632seamier
shader104218762sha_der
shadier113111152shadier
shaker134319462sha_ker
shakier143411152shakier
shalier103116422shalier
shame105726702sha_me_
shamed125120212sha_med
shames114726222sha_mes
shammas14358712shammas
shammied16265542shammied
shammies15259672shammies
shammos14307202shammos
shammy16388502shamm_y
shaper114119932sha_per
sharer95025482sha_rer
sharker144313812sharker
sharper124312702sharper
shatter103615692shatter
shaver123718912sha_ver
shimmed15338582shimmed
shimmers15269412shimmers
shimmery18265252shimmery
simmer104115352s_immer
skimmer15327532skimmer
slammed123511102slammed
slammers123511222slammers
slimmer114211342slimmer
slummer113711202slummer
spammed14348522spammed
spammers14378692spammers
stammel11607532stammel
stammers123611522stammers
stamper113714392stamper
stemmer113210182stemmer
summer104017712s_ummer
swamper14349312swamper
swarmer1247802swarmer
swimmer14297652swimmer
whammed18345132whammed
yammer133713182_yammer
aimer75926823__aimer
amber94523203__amber
ameer75618983__ameer
armer76924443__armer
ashamed1336243asha_med
bammed133913243_bammed
beamier113411943beamier
blamer104417143bla_mer
brimmer13348803brimmer
bummer124014103_bummer
calmer105216933_calmer
camber124418473_camber
camper124722213_camper
chafer144714573cha_fer
chaffer18389473chaffer
chambers173410613chambers
chamfers18409213chamfers
chammied18215963chammied
chammies172910153chammies
chammy18488953chamm_y
champed174111473champed
champers173311613champers
chancer144215633chancer
changer134215543changer
chanter123919733chanter
chapmen1637283chapmen
chapter144213853chapter
charger133914063charger
charier124317903charier
charmed154714243charmed
charmers154211323charmers
charter123918303charter
chaser114918383cha_ser
chasmed154710173chasmed
chaster124718503chaster
chatter124416643chatter
chaufer15347943chaufer
chawer144314413cha_wer
chimer135517203ch_imer
chomper163810073chomper
chummed17396443chummed
chummier1734513chummier
claimer11279883claimer
clamber133311733clamber
clammed14369963clammed
clammers143510683clammers
clammier1435843clammier
clamper134012993clamper
crammed143710123crammed
crammers14369343crammers
crimmer133310773crimmer
cummer124414593_cummer
dammar11438903_dammar
dammed124214793_dammed
dammers123214273_dammers
damner95213433_damner
damper114117753_damper
dimmer114112613_dimmer
drammed13378073drammed
drummer12407503drummer
emmer94314463__emmer
farmer115017373_farmer
flamer114919123fla_mer
flamier123112143flamier
flammed15377413flammed
foamer114714313foa_mer
foamier12339003foamier
framer114817443fra_mer
gamer84928943_ga_mer
gamier93617933_gamier
gammed124216163_gammed
gammers123214563_gammers
gammier123711193_gammier
glimmer12437713glimmer
glummer12417983glummer
grammar12406893grammar
gramme114210333gramme_
grammes123611323grammes
grimmer123510093grimmer
grummer12338783grummer
gummer114615453_gummer
hacker154822693_hacker
hafter124815883_hafter
hailer94720343_hailer
haler85033523_ha_ler
halter94420883_halter
hame97043133_ha_me_
hames106138703_ha_mes
hamlet113722793_hamlet
hammal134512063_hammal
hammam12419333_hammam
hammered16218843_hammered
hammerer15278143_hammerer
hammy155113433_hamm_y
hampers143616943_hampers
hamster12810423_hamster
hander104526433_hander
hanger104023253_hanger
hanker134622093_hanker
harder105022403_harder
harmed125218833_harmed
harmers124116593_harmers
harper115018403_harper
hater85034753_ha_ter
hatter94724873_hatter
hauler95015123_hauler
haver115124463_ha_ver
hawker164812663_hawker
hawser125910843_hawser
hayer114620243_ha_yer
hazer174820233_ha_zer
hazier184712403_hazier
hemmed144211463_hemmed
hemmers143310843_hemmers
homer105828453_h_omer
homier116416993_homier
hummed144812673_hummed
hummers143813063_hummers
humper134115883_humper
jammed183811503_jammed
jammers183710703_jammers
jammier18408023_jammier
krimmer15376873krimmer
lamber104418493_lamber
lamer75233703_la_mer
lammed113915623_lammed
limmer104314793_limmer
loamier9349163loamier
maimer104514593_maimer
mammee94417853_mammee
mammers104615693_mammers
mammet94319253_mammet
mammey124310893_mammey
mamzer19459833_mamzer
mummer93614543_mummer
namer75622103_na_mer
palmer105816543_palmer
pamper124316663_pamper
phatter123810203phatter
plummer13298523plummer
primmer134310163primmer
rammed113117303_rammed
rammers113715043_rammers
rammier112811023_rammier
reamer84325213rea_mer
rehammers1644503rehammers
rhymer14387083rh_ymer
rimmer103516033_rimmer
roamer84715163roa_mer
rummer104715483_rummer
saber75330243s_a_ber
sacker125124843s_acker
sadder82916973s_adder
safer84721813s_a_fer
sager65432053s_a_ger
sagger84321073s_agger
sagier73717163s_agier
sailer63526103s_ailer
saker95132023s_a_ker
salter64325083s_alter
salver94617753s_alver
sambar103914163s_ambar
sambur10469503s_ambur
same65245643s_a_me_
samek114915273s_a_mek
samiel8313333s_amiel
samlet84126563s_amlet
sampler113212013s_ampler
sander74828533s_ander
saner54334323s_a_ner
sanger74524563s_anger
sapper103822353s_apper
saucer84314103s_aucer
sauger74316253s_auger
saver84831253s_a_ver
sawer85026213s_a_wer
sawyer12438043s_awyer
sayer84926553s_a_yer
scaler84321603sca_ler
scalier94316913scalier
scalper113912923scalper
scamped144711963scamped
scampers143611033scampers
scamster1235303scamster
scanner94411813scanner
scanter94215183scanter
scarcer113911373scarcer
scarer84524603sca_rer
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scatter93815173scatter
scauper11379453scauper
schemer1477953schemer
schmeer1475363schmeer
scrammed1555003scrammed
scummed14347913scummed
scummers14277783scummers
scummier1445083scummier
sealer63928963sea_ler
seamed94823883sea_med
seamen84518563sea_men
seamers94719433sea_mers
seamster1037143seamster
searer65432023sea_rer
seater64534153sea_ter
seemer84418043s_eemer
shabbier1535183shabbier
shacked174015393shacked
shackler17317973shackler
shade95125583sha_de_
shaded114518873sha_ded
shaders115915553sha_ders
shades105924533sha_des
shadower1544863shadower
shafted14288803shafted
shagged134210123shagged
shaggier13116053shaggier
shake124726403sha_ke_
shaken134113613sha_ken
shakers144015563sha_kers
shakes135024593sha_kes
shakoes144510013shakoes
shale85332833sha_le_
shaled105023953sha_led
shales94731253sha_les
shaley123714993sha_ley
sham96436353sha_m__
shaman113314273sha_man
shamans123610893shamans
shamas113717933sha_mas
shamble14149263shamble
shambled16156153shambled
shambles15159043shambles
shaming133016743shaming
shamisen1344273shamisen
shammash18293743shammash
shamming16289413shamming
shamois123210403shamois
shamos114216983sha_mos
shamoy14379913sha_moy
shamoyed1744043shamoyed
shamoys15367283shamoys
shampoo1435373shampoo
shampooer1643063shampooer
shams105829413sha_m_s
shamus114112813sha_mus
shamuses1336153shamuses
shanked153212123shanked
shantey134210033shantey
shape105125113sha_pe_
shaped125020103sha_ped
shapen114414653sha_pen
shapers124016893sha_pers
shapes115124943sha_pes
share86437083sha_re_
shared105829063sha_red
sharers104720623sha_rers
shares95236413sha_res
sharked153613903sharked
sharkers154011053sharkers
sharped134112043sharped
sharpen12389723sharpen
sharpers133810943sharpers
shatters113313903shatters
shauled1148793shauled
shave114425893sha_ve_
shaved135118383sha_ved
shaven124213303sha_ven
shavers134115093sha_vers
shaves125224933sha_ves
shavie124312413shavie_
shavies134213203shavies
shawed134817233sha_wed
shawled1437773shawled
shawm135316143shawm__
shawms14579563shawm_s
shearer104414683shearer
sheather1458213sheather
shedder12339323shedder
sheer84726893sh__eer
sheerer103813843sheerer
sheeter103814903sheeter
sheller103515883sheller
shelter103214953shelter
shelver134211063shelver
shewer124515103sh_ewer
shicker163914823shicker
shier85428943sh__ier
shifter132911073shifter
shikker13277023shikker
shimmered1744783shimmered
shimmied16294983shimmied
shimmies15287803shimmies
shimmy16306413shimm_y
shiner93820873sh_iner
shinier104113143shinier
shipmen14317283shipmen
shipper143514033shipper
shirker143711343shirker
shiver124517373sh_iver
shmear1176933sh_mear
shmoes114612093sh_moes
shoaler102610073shoaler
shoalier1137063shoalier
shocker163411423shocker
shoer84722153sh__oer
shooter103013973shooter
shopmen14277193shopmen
shopper143312623shopper
shorter103515493shorter
shouter103213073shouter
shover124515983sh_over
shower124315103sh_ower
showier1339093showier
showmen15227163showmen
shrimper1544413shrimper
shriver134712193shriver
shucker163710103shucker
shudder12297323shudder
shunner10358643shunner
shunter103611723shunter
shusher13288113shusher
shutter103712133shutter
shyer114714783sh__yer
shyster13116553shyster
simmers113314613s_immers
simper103616293s_imper
skanker10268483skanker
skater105015483ska_ter
skimmed16306053skimmed
skimmers16296453skimmers
slabber113311393slabber
slacker133915293slacker
slaker104219273sla_ker
slalomer1045033slalomer
slander84015443slander
slapper113512463slapper
slasher104515323slasher
slater64429183sla_ter
slather103816063slather
slatier74016813slatier
slaver94419613sla_ver
slayer93916333sla_yer
slimier93212013slimier
slimmed12368473slimmed
slimmers12369633slimmers
slumber113811003slumber
slummed12359273slummed
slummers12358933slummers
slummier1235473slummier
smacker153410583smacker
smaller93410333smaller
smarmier1235033smarmier
smarter94113133smarter
smasher123911013smasher
smatter93613333smatter
snacker133112603snacker
snakier112810003snakier
snapper113512073snapper
snarer64620843sna_rer
snarler73610633snarler
soaker105717533soa_ker
soaper84517873soa_per
soapier93411713soapier
soarer64522243soa_rer
somber103713993s_omber
spacer104917793spa_cer
spacier114011633spacier
spader94317133spa_der
spaller92713473spaller
spanker133612353spanker
spanner94312563spanner
sparer84524963spa_rer
sparger103613073sparger
sparker133914353sparker
sparser94311483sparser
spasmed12296993spasmed
spatter94016523spatter
spawner12347363spawner
spumier1137903spumier
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343sta_ger
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823sta_ler
stalker113912253stalker
stamen84115943sta_men
stammels12495563stammels
stammered1444643stammered
stammerer1344063stammerer
stamped124812813stamped
stampers124211593stampers
stander84316163stander
stapler93913623stapler
starer64027363sta_rer
starker114114693starker
starter73817873starter
starver104611993starver
stater64427553sta_ter
stayer94516483sta_yer
steamer93313093steamer
steamier1048303steamier
stemmed12278153stemmed
stemmers12378443stemmers
stemmery15334693stemmery
stemmier1245253stemmier
stomper114111223stomper
strummer1234783strummer
stummed12348553stummed
stumper113610093stumper
suaver93014233sua_ver
summed114014043s_ummed
summers113616503s_ummers
summery14329413s_ummery
swabber14297963swabber
swager104013613swa_ger
swagger12389333swagger
swagmen1334973swagmen
swamies123712063swamies
swamped15498443swamped
swampers15317473swampers
swampier1544593swampier
swanker14369483swanker
swapper14359703swapper
swarmed1367483swarmed
swarmers1346323swarmers
swasher134011503swasher
swather134213593swather
swatter104113323swatter
swayer125210973swa_yer
swimmers15276693swimmers
swimmier15174313swimmier
tamer75230103_ta_mer
tamper104618513_tamper
thaler94613103tha_ler
thanker14309593thanker
thawer12489343tha_wer
thrummer1542933thrummer
thumper14356953thumper
thymier1534393thymier
trammed123810713trammed
trammel11357663trammel
tramper113812153tramper
trimmer113610833trimmer
vamper134212653_vamper
warmer113816733_warmer
whacker19368503whacker
whaler124611973wha_ler
whammies18265503whammies
whammo16405193whamm_o
whammy19375293whamm_y
whapper17348273whapper
whimper17297723whimper
yammers143410323_yammers

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.1561145455.1
2DLD Change Limit1340275358.34316064.6
3Display Results5355350.1862876.3
 (SQL Overall)1786915358.68520574.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.