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 “stums” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
stums7532008(None) 
scums95017421scums
slums74623431slums
stems75219951stems
strums84716451strums
stubs75016071stubs
studs64415871studs
stum65526021stum_
stump94616461stump
stumps104912281stumps
stuns54719491stuns
sums65837581s_ums
alums75720602alums
arums75517832arums
atoms76817562atoms
bums85934592_bums
chums125015832chums
datums936352datums
doums85417642doums
drums85415872drums
estrums9208602estrums
etuis54013132etuis
gaums86217072gaums
geums85414112geums
glums84621422glums
gums75030942_gums
hums96831422_hums
items7499612items
lums65734242_lums
mums85732772_mums
neums75414252neums
plums94619952plums
rums64833472_rums
sauls55128122sauls
scams94423972scams
scrums104614252scrums
scuds85116242scuds
scum85924522scum_
scups95316652scups
scuts74522522scuts
seams75731662seams
sebums10369812sebums
sedums93910482sedums
seems75525022seems
septums1135742septums
serums83916302serums
setups83910462setups
shams105829412shams
shims104422552shims
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
sims65737182s_ims
situps8538782situps
situs55019232situ_s
skims114517202skims
skuas95611732skuas
slams74927902slams
slims75423652slims
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slum65430512slum_
slump94816632slump
slumps104313582slumps
slurs54123372slurs
sluts54523982sluts
smuts75415712smuts
snubs75412552snubs
snugs64913022snugs
solums85211332solums
soms66239372s_oms
souks94820522souks
souls55127362souls
soups75322942soups
sours55230502sours
sous46947212sou_s
spams94922192spams
spuds85113672spuds
spues75025382spues
spume95817312spume
spumes1021314882spumes
spumy124610362spumy
spurs74621522spurs
stabs76221382stabs
stags66226742stags
stamp95217362stamp
stamps105614022stamps
stars55836572stars
stats55933362stats
stays86022022stays
steams84916902steams
stem610628252stem_
steps76619882steps
stets55423912stets
stews85519142stews
sties55132982sties
stime76521802stime
stimes85920572stimes
stimy105114742stimy
stirs55921622stirs
stoas55126022stoas
stobs75718232stobs
stoma75918272stoma
stomas84816322stomas
stomp95616662stomp
stomps105612832stomps
stops74827282stops
storms85814632storms
stoss54316342stoss
stots54828552stots
stoups85313272stoups
stours65015632stours
stouts65019002stouts
stows86622702stows
strum75619452strum_
struma84313272struma
strumas9419832strumas
struts65616802struts
stub66221842stu_b
stuck114515772stuck
stud56220092stu_d
study94411792study
stuff113817052stuff
stuffs123810222stuffs
stull54916272stull
stulls63912982stulls
stumpy13458132stumpy
stun45623452stu_n
stung65417152stung
stunk94616292stunk
stunt55328172stunt
stunts65615252stunts
stupa74112312stupa
stupas83910882stupas
stupe75217752stupe
stupes84116952stupes
sturt56028962sturt
sturts63915142sturts
styes86316522styes
stymy13358292stymy
subs66037122s_ubs
suds56135302s_uds
sues46247652s_ues
suks85927122s_uks
sum56346012s_um_
sumo67326312s_umo
sumos75720092s_umos
sump86331532s_ump
sumps95023432s_umps
suns45841902s_uns
sups64834432s_ups
suqs134319652s_uqs
suss45229302s_uss
swims105514142swims
swum96416822swum_
tams67247932_tams
toms68343492_toms
tubs65430062_tubs
tugs56231672_tugs
tuis44829642_tuis
tump85927032_tump
tumps95420792_tumps
tuns45138662_tuns
tups65628762_tups
tuts45838452_tuts

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001661.40638264.6
3Display Results1661660.0463608.7
 (SQL Overall)1786911661.765101241.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.