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

162 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
stammels1249556(None) 
stammel11607531stammel_
stammers123611521stammers
samiels939762s_amiels
scammers14339772scammers
shammers153710842shammers
shammes144312832shamme_s
slammers123511222slammers
spammers14378692spammers
stamens93411482sta_mens
stammer116013342stamme_r
stampers124211602stampers
staumrels1141662staumrels
stemmers12378442stemmers
trammels12295412trammels
camels105217083_ca_mels
clammers143510693clammers
crammers14369353crammers
dammers123214273_dammers
damsels10126713_damsels
enamels9128163ena_mels
gammers123214563_gammers
grammes123611323gramme_s
hammals14409233_hammals
hammers144216063_hammers
jammers183710703_jammers
kummels15234793_kummels
mammals10389273_mammals
mammees104411143_mammees
mammers104615693_mammers
mammets103911113_mammets
mammeys13376723_mammeys
pommels13235793_pommels
pummels13236543_pummels
rammers113715043_rammers
sambals115213483s_ambals
sameks12409323s_a_meks
samiel8313333s_amiel_
samlets93813553s_amlets
samples112815453s_amples
satchels13328163satchels
saurels749303s_aurels
scalpels12345883scalpels
scammed14479543scamme_d
scammer133611973scamme_r
scampers143611033scampers
scummers14277783scummers
seamers94719433sea_mers
seamless10238723seamless
shambles15159043shambles
shames114726223sha_me_s
shammas14358723shamm_as
shammed153911423shamme_d
shammer144613143shamme_r
shammies15259693shammies
shammos14307203shamm_os
shimmers15269413shimmers
simmers113314613s_immers
simnels976103s_imnels
skimmers16296463skimmers
slammed123511103slamme_d
slammer113913033slamme_r
slimmers12369633slimmers
slummers12358933slummers
spammed14348523spamme_d
spammer133410433spamme_r
spancels1245273spancels
spaniels1045963spaniels
stabbers12268733stabbers
stabiles10311403stabiles
stablers103611153stablers
stables93219073stable_s
stackers143413563stackers
stactes91914633stacte_s
staddles10258693staddles
stades74626243sta_de_s
staffers14247083staffers
stagers84116673sta_gers
stages75629493sta_ge_s
staggers10379843staggers
stainers83212173stainers
stakes103927293sta_ke_s
stalely1039213sta_lely
stales65538293sta_le_s
stalkers12369853stalkers
stalls64019933sta__lls
stamen84115943sta_me_n
staminas1048853staminas
stammered1444643stammered
stammerer1344063stammerer
stammerers1443133stammerers
stamped124812813stampe_d
stampede13326163stampede
stampedes14315183stampedes
stamper113714403stampe_r
stampless1334543stampless
stamps105614023sta_m_ps
stances93715963stance_s
standees93310143standees
standers93514303standers
stanes64933403sta_ne_s
stanols739733sta_nols
stapes85028733sta_pe_s
staplers103111203staplers
staples93617213staple_s
starers74522313sta_rers
stares66038753sta_re_s
starets73515923sta_rets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
starters83714773starters
startles82111963startles
starvers11459643starvers
starves104614553starve_s
stases64225563sta_se_s
stashes103916173stashe_s
stately10310223sta_tely
staters73922343sta_ters
states64337083sta_te_s
statues74614903statue_s
staumrel1042083staumrel_
staves94525193sta_ve_s
stayers103813633sta_yers
steamers103410873steamers
steels64117983st__eels
stemless1036653stemless
stemmas11256973stemm_as
stemmed12278153stemme_d
stemmer113210183stemme_r
stemmery15334693stemmery
stimes85920573st_ime_s
stimies9316563stimie_s
stipels9418953st_ipels
stompers123610043stompers
streels73811343st_reels
strudels934123strudels
strummers1333693strummers
stumbles1237493stumbles
stummed12348553stumme_d
stumpers12318313stumpers
stymies1239213stymie_s
summers113616503s_ummers
swamies123712063swamie_s
swampers15317473swampers
swarmers1346323swarmers
swimmers15276693swimmers
taels56822073_ta__els
tamales93216153_tamales
tamals84116633_ta_mals
tamely113711953_ta_mely
tamers84224033_ta_mers
tames75242013_ta_me_s
tammies113814683_tammies
tampers113516743_tampers
tassels74510853_tassels
tramels93812493_tramels
trammel11357663trammel_
trommels12254333trommels
tsimmes1133673tsimme_s
wadmels1334303_wadmels
yammers143410323_yammers

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.423422437.4
2DLD Change Limit1461621627.17320376.7
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.65923330.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.