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

135 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
surmised113686(None) 
surmise9311081surmise_
surmiser1036761surmiser
surmises10310641surmises
summited13246412summited
surbased1136612surbased
surmisers1145202surmisers
surprised1245312surprised
survived1534072survived
atomised11278833atomised
braised104014803_braised
bruised10389503_bruised
buried94822373bur_i_ed
burnished1544923burnished
cruised103710213_cruised
curried103313653curri_ed
cursed94321253cur__sed
curtsied1134953curtsied
demised113613683_demised
dermises112512023dermises
dummied13346723dummi_ed
ermined10410603_ermined
fulmined1454333fulmined
furbished1843773furbished
furnished1644583furnished
guised84612173gu__ised
hurried113511043hurri_ed
irised73913153_ir_ised
itemised11105163itemised
juried144212443jur_i_ed
kermises14248313kermises
mortised1178743mortised
mummied11327103mummi_ed
murmured1343113murmured
nursed74514663nur__sed
outraised1039243outraised
praised104214813_praised
premised133013193premised
prised94322203_pr_ised
promised133010873promised
pumiced1435173pu_miced
purposed1335263purposed
pursed95220883pur__sed
raised76120333__raised
remised103516843_remised
reraised9312353reraised
ruralised1046593ruralised
samisen937673s_amisen
sardined10268663sardined
scribed124510643scr_ibed
scried95817303scr_i_ed
scrimped1555313scrimped
scrived134511113scr_ived
scurried11267053scurri_ed
seised74218123s__eised
semises93916553s_emises
serifed11811463ser_ifed
serried82513963serri_ed
serviced1435613serviced
shamisen1344273shamisen
shrimped1634213shrimped
shrined114112413shr_ined
shrived144712183shr_ived
skirmished2051563skirmished
slurried9285943slurri_ed
smiled93716433s__miled
sortied83314103sorti_ed
sprained1138433sprained
stimied10310623stimi_ed
strained9412253strained
stressed9128543stressed
striped105214363str_iped
strived114713663str_ived
sturdied10215963sturdi_ed
stylised12215893stylised
stymied1335663stymi_ed
suberised1299033suberised
sublimed1337213sublimed
submersed1445863submersed
submiss1138083submis_s
submitted1445233submitted
subsided1257663subsided
subsisted1245783subsisted
sudsed83911373su__dsed
sufficed17205663sufficed
suffixed22214343suffixed
suffused1544023suffused
suicided1246033suicided
suited74019423su__ited
sullied83714483sulli_ed
summarised15123913summarised
summated13298833summated
summed114014043su_m_med
summered1338143summered
summoned1345723summoned
summonsed1443303summonsed
sunrise7310813sunrise_
sunrises8310693sunrises
sunwise1036433sunwise_
supervised1646663supervised
supposed1345783supposed
surbase939793surbase_
surbases10310003surbases
surceased1264843surceased
surfaced1436063surfaced
surfed103814463sur__fed
surfeited1344593surfeited
surfier102613543surfi_er
surfiest112414433surfiest
surfside1244853surfside
surged84118883sur__ged
surimis938843surimis__
surlier72915443surli_er
surliest82416913surliest
surmising1247683surmising
surnamed1135113surnamed
surpassed1244133surpassed
surpliced1444153surpliced
surplused1243533surplused
surprise1037673surprise_
surpriser1144613surpriser
surprises1137433surprises
surprized2144663surprized
surtaxed1644133surtaxed
surveyed1544233surveyed
survive1335933survive_
surviver1434683surviver
survives1436333survives
suspired1135613suspired
sussed75015533su__ssed
turmoiled1242603turmoiled
unmined102612953_unmined
unmixed17228213_unmixed
unraised91811883unraised
upraised11167413upraised

Search took 7 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 Limit1461621356.45022660.8
3Display Results1351350.0632142.9
 (SQL Overall)1786911356.93625762.8
 
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.