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

120 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
stardoms113679(None) 
stardom1037761stardom_
tsardoms1144131tsardoms
czardoms2243742czardoms
shahdoms1743772shahdoms
tsardom1044482tsardom_
tzardoms2043272tzardoms
ardors74416863__ardors
cardons104519933_cardons
caroms105619573_car_oms
carroms11512403_carroms
czardom2144183czardom_
earldoms1144223_earldoms
fandoms13229473_fandoms
heirdoms1444353heirdoms
jarldoms1842943_jarldoms
lardons83914493_lardons
masterdoms1544353masterdoms
motordoms1444093motordoms
pardons103817623_pardons
randoms102112433_randoms
rhabdoms1643333rhabdoms
sarcoma1147403s_arcoma
sarcomas1247223s_arcomas
sarcous9312933s_arcous
sardars83112903s_ardars
sardius839553s_ardius
sards64736183s_ard__s
sargos74318273s_argo_s
sarodes84216143s_arodes
sarods74918573s_ar_ods
saros55238063s_ar_o_s
sartors7314953s_artors
scarious10610203scarious
seadogs958643sea_dogs
seadrome1146513seadrome
seadromes1246093seadromes
selfdoms1443683selfdoms
serfdoms1443763serfdoms
shadows1437193sha_dows
shahdom1643963shahdom_
shaloms1288983sha_loms
shards104319173shard__s
slaloms9106543sla_loms
smarms105712533smar__ms
sodoms989663s__odoms
sordors839983s_ordors
sparrows1344803sparrows
staddles10258693staddles
stades74626243sta_d_es
stadias8411113sta_dias
stadiums1145703stadiums
standbys1443203standbys
standees93310143standees
standers93514303standers
standoff1543993standoff
standoffs1642673standoffs
standout948663standout
standouts1044983standouts
stands75118053stand__s
standups1143963standups
stannous846443stannous
stannums1043803stannums
stanols739733sta_nols
starches131912913starches
stardust946093stardust
stardusts1043153stardusts
starers74522313star_ers
stares66038753star__es
starets73515923star_ets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
starnose8136683starnose
starnoses9157143starnoses
stars55836573star___s
starters83714763starters
startles82111963startles
starts65423123star__ts
startups1033893startups
starvers11459643starvers
starves104614553star_ves
starwort1198673starwort
starworts12105263starworts
staterooms1244383staterooms
stations82415213stations
statisms1039543statisms
stators73915553sta_tors
stereos74314973stereo_s
sternums1045783sternums
sterols7313443ster_ols
stertors8310903stertors
storms85814603stor__ms
stratous8410683stratous
stratums10266803stratums
streams94713373st_reams
stridors9367293stridors
stroma84313073st_r_oma
strops86220383st_r_ops
strows96718273st_r_ows
stroys95914603st_r_oys
strums84716453st_r_ums
sturdies92110273sturdies
sunrooms1045723sunrooms
swards105415133sward__s
swarms116112163swar__ms
tandems1037633_tandems
taprooms1246663_taprooms
tardies84225863_tardies
tardo65321103_tardo__
tardyons1244613_tardyons
tarocs84615663_tar_ocs
taroks106115283_tar_oks
taros55640823_tar_o_s
tarots66422993_tar_ots
tarpons92612203_tarpons
tearooms1047843tearooms
tsarisms1056653tsarisms
tzardom1943733tzardom_
varooms1248883_varooms

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.1561145455.1
2DLD Change Limit1461621207.09620597.8
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.29824484.9
 
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.