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

393 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
stammers12361152(None) 
scammers14339771scammers
shammers153710841shammers
slammers123511221slammers
spammers14378691spammers
stammels12495561stammels
stammer116013341stammer_
stampers124211601stampers
stemmers12378441stemmers
clammers143510692clammers
crammers14369352crammers
dammers123214272_dammers
gammers123214562_gammers
hammers144216062_hammers
jammers183710702_jammers
mammers104615692_mammers
rammers113715042_rammers
scammer133611972scammer_
scampers143611032scampers
scummers14277782scummers
seamers94719432sea_mers
shammer144613142shammer_
shammes144312832shamme_s
shimmers15269412shimmers
simmers113314612s_immers
skimmers16296462skimmers
slammer113913032slammer_
slimmers12369632slimmers
slummers12358932slummers
spammer133410432spammer_
stabbers12268732stabbers
stablers103611152stablers
stackers143413562stackers
staffers14247082staffers
stagers84116672sta_gers
staggers10379842staggers
stainers83212172stainers
stalkers12369852stalkers
stamens93411482sta_mens
stammel11607532stamme_l
stammered1444642stammered
stammerer1344062stammerer
stammerers1443132stammerers
stamper113714402stamper_
standers93514302standers
staplers103111202staplers
starers74522312sta_rers
starkers123712392starkers
starters83714772starters
starvers11459642starvers
staters73922342sta_ters
stayers103813632sta_yers
steamers103410872steamers
stemmer113210182stemmer_
stemmery15334692stemmery
stompers123610042stompers
strummers1333692strummers
stumpers12318312stumpers
summers113616502s_ummers
swampers15317472swampers
swarmers1346322swarmers
swimmers15276692swimmers
tamers84224032_ta_mers
tampers113516742_tampers
yammers143410322_yammers
aimers84621913__aimers
ambers104519583__ambers
ameers84015573__ameers
armers85520273__armers
blamers115314213bla_mers
brimmers14287073brimmers
bummers133712443_bummers
cambers134017443_cambers
campers134220293_campers
chambers173410623chambers
chamfers18409223chamfers
champers173311623champers
charmers154211333charmers
claimers12298743claimers
clambers144211293clambers
clammer134211793clammer_
clampers143211893clampers
crammer134010963crammer_
crimmers14298543crimmers
cummers133713483_cummers
dammars12308193_dammars
dammer114317933_dammer_
damners104112113_damners
dampers123915693_dampers
dimmers123811563_dimmers
drummers13316163drummers
emmers104013223__emmers
farmers124315263_farmers
flamers124616363fla_mers
foamers123812103foa_mers
framers125113823fra_mers
gamers94420833_ga_mers
gammer1112318333_gammer_
glimmers13396153glimmers
grammars13345943grammars
grammes123611323gramme_s
gummers123712203_gummers
hammer138120033_hammer_
hampers143616953_hampers
harmers124116593_harmers
hemmers143310843_hemmers
hummers143813063_hummers
jammer174014133_jammer_
krimmers16315673krimmers
lambers113817113_lambers
lampers113817333_lampers
limmers113413083_limmers
maimers113813043_maimers
mammees104411143_mammees
mammer94218863_mammer_
mammets103911113_mammets
mammeys13376723_mammeys
mamzers20409163_mamzers
metamers1249623meta_mers
mummers103712843_mummers
namers84517333_na_mers
palmers113513623_palmers
pampers133615933_pampers
rammer103519653_rammer_
reamers94221083rea_mers
rehammers1644503rehammers
rimmers113812883_rimmers
roamers93713463roa_mers
rummers113513653_rummers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sambars115113843s_ambars
samburs11369343s_amburs
sameks12409323s_a_meks
samiels939763s_amiels
samlets93813553s_amlets
samplers12299403s_amplers
sanders84025943s_anders
sangers84421943s_angers
sappers113518903s_appers
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scalers93817263sca_lers
scalpers123710863scalpers
scammed14479543scamme_d
scamper134613163scamper_
scamsters1334993scamsters
scanners10379703scanners
scarers94618513sca_rers
scarfers13408463scarfers
scarpers124712513scarpers
scatters103612753scatters
scaupers12378173scaupers
schemers1576713schemers
schmeers1574833schmeers
scummer13398753scummer_
sealers74323553sea_lers
seamer84223613sea_mer_
seamier93114633seamier_
seamless10238723seamless
seamsters1136333seamsters
seaters74028943sea_ters
seemers93814333s_eemers
shaders115915553sha_ders
shakers144015563sha_kers
shames114726223sha_me_s
shammas14358723shamm_as
shammed153911423shamme_d
shammies15259693shammies
shammos14307203shamm_os
shapers124016893sha_pers
sharers104720623sha_rers
sharkers154011053sharkers
sharpers133810943sharpers
shatters113313913shatters
shavers134115093sha_vers
shimmer143310873shimmer_
shimmery18265253shimmery
simmer104115353s_immer_
simpers113014123s_impers
skankers11316483skankers
skaters113512963ska_ters
skimmer15327533skimmer_
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slalomers1144553slalomers
slammed123511103slamme_d
slanders94014013slanders
slappers123710953slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slimmer114211343slimmer_
slumbers123110273slumbers
slummer113711203slummer_
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snappers123510173snappers
snarers74216663sna_rers
snarlers8298753snarlers
soakers114114953soa_kers
soapers93715923soa_pers
soarers74118093soa_rers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammed14348523spamme_d
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_
stamen84115943sta_me_n
staminas1048853staminas
stammering1544523stammering
stamped124812813stampe_d
stampede13326163stampede
stampeders15233203stampeders
stampedes14315183stampedes
stampless1334543stampless
stamps105614023sta_m_ps
stances93715963stance_s
stanchers14206813stanchers
standees93310143standees
stander84316163stander_
stanes64933403sta_ne_s
stapes85028733sta_pe_s
stapler93913633stapler_
staples93617213staple_s
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
staumrel1042083staumrel
staumrels1141663staumrels
staves94525193sta_ve_s
stayer94516483sta_yer_
steadiers1035083steadiers
stealers83412213stealers
steamer93313093steamer_
steamier1048303steamier_
steepers103011373steepers
steerers82511353steerers
steers63820983st__eers
stemless1036653stemless
stemmas11256973stemm_as
stemmed12278153stemme_d
stemmeries1445173stemmeries
stemmier1245253stemmier_
steppers12289283steppers
stickers142913033stickers
stiflers11238833stiflers
stimes85920573st_ime_s
stimies9316563stimie_s
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stirrers8266943stirrers
stivers103613543st_ivers
stockers143411073stockers
stokers114515183st_okers
stomper114111233stomper_
stoners74817953st_oners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373st_opers
stoppers123910593stoppers
storers75018683st_orers
stovers103713733st_overs
strafers11379913strafers
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
strappers1346743strappers
strayers113510143strayers
streamers11228073streamers
strewers11409063strewers
striders94412123striders
strikers123611293strikers
stripers103911593stripers
strivers113911843strivers
strokers123910903strokers
stroyers11388923stroyers
strummer1234783strummer_
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumblers1334383stumblers
stummed12348553stumme_d
stumper113610093stumper_
stunners8277923stunners
stutters83210473stutters
stylers10359353st_ylers
stymies1239213stymie_s
summer104017713s_ummer_
summery14329413s_ummery
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swamies123712063swamie_s
swamper14349313swamper_
swappers15358083swappers
swarmer1247803swarmer_
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
swimmer14297653swimmer_
tabers84621573_ta_bers
tackers134319623_tackers
taggers93514193_taggers
tailers73720183_tailers
takers103923743_ta_kers
talers64628143_ta_lers
talkers113513213_talkers
tamburs11288613_tamburs
tamer75230103_ta_mer_
tames75242013_ta_me_s
tammies113814683_tammies
tamper104618513_tamper_
tankers113416913_tankers
tanners74018393_tanners
tapers84025813_ta_pers
tappers113416543_tappers
tasters74225643_tasters
taters64932203_ta_ters
tatters74520483_tatters
tawers94118603_ta_wers
taxers134015283_ta_xers
teemers95012903_teemers
tempers113513013_tempers
termers95414503_termers
timbers113111853_timbers
timers84420993_t_imers
trammels12295413trammels
trampers123210393trampers
trimers94615143_trimers
trimmers12288913trimmers
tsimmes1133673tsimme_s
tummlers12295703_tummlers
vampers143111623_vampers
vitamers1334683vita_mers
warmers124514293_warmers
yammer133713183_yammer_

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.406440125.6
2DLD Change Limit1461623937.67319048.9
3Display Results3933930.1532568.6
 (SQL Overall)1786913938.23221706.9
 
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.