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

106 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
sulfone103748(None) 
sulfones1147681sulfones
subtone9310342subtone
subzone1846992subzone
sulfate10311652sulfate
sulfide1138102sulfide
sulfite10310472sulfite
sulfo8313362sulfo__
sulfonate1245012sulfonate
sulfonic1344702sulfonic
sulfonyl1442372sulfonyl
sulphone1345982sulphone
alone55732963_al_one
calzone1848623calzone
clone75728163_cl_one
colone85425003col_one
duotone836893duotone
fulmine1257963fulmine
fulsome1245363fulsome
gulfing12339473gulfing
halftone1445153halftone
leone55018823__leone
lone45849133__l_one
outdone8311643outdone
outgone8311463outgone
quinone16217463quinone
saline65132703sal_ine
salmon84614183salmon_
salmons93713263salmons
salon55228553sal_on_
salons63823693sal_ons
saloon64418023saloon_
saloons74415323saloons
saltine75018563saltine
scone74621833s__cone
selfing112911623selfing
shone83725983s__hone
silane62718053sil_ane
silicone1096733silicone
sinfonie1145253sinfonie
sloe45534953s_l_o_e
slope75823563s_l_ope
solfege1144223solfege
solion6616383solion_
solions7513753solions
solon55026133sol_on_
solons65120023sol_ons
someone938813someone
sone46649983s___one
spline86020533spl_ine
splore81611303spl_ore
spumone1154383spumone
stone55431183s__tone
subcode1237163subcode
subfile122010503subfile
subline9316893subline
subtones10311383subtones
subvene1238493subvene
subzones1947223subzones
sucrose939303sucrose
suffice15197573suffice
suffuse1335443suffuse
sulcate9314423sulcate
suldan72611043suldan_
suldans8299723suldans
sulfa8313923sulf__a
sulfas9311563sulf_as
sulfated1238833sulfated
sulfates11310793sulfates
sulfid1039063sulf_id
sulfides1238053sulfides
sulfids1137293sulfids
sulfinyl1442953sulfinyl
sulfites1139903sulfites
sulfonated1443903sulfonated
sulfonates1344573sulfonates
sulfonium1443903sulfonium
sulfonyls1552133sulfonyls
sulfoxide2042903sulfoxide
sulfur937913sulf_ur
sulfured1236113sulfured
sulfuret1149273sulfuret
sulfurs1037343sulfurs
sulfury1345163sulfury
sulking124514313sulking
sullage859913sullage
sullen62914293sullen_
sullener857243sullener
sulphones1446063sulphones
sultan63012593sultan_
sultana7257803sultana
sultans72411833sultans
summon1037623summon_
summoned1345723summoned
summoner1245533summoner
summons1158003summons
sunstone847793sunstone
supine84216693su_pine
suppose1137973suppose
surface1238653surface
surfing112914483surfing
surfmen1235993surfmen
sylvine13216543sylvine
undone7914253_undone
unfond10149113_unfond
vulpine1235903vulpine

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 Filter1786911340270.470380193.6
2DLD Change Limit1340271066.09321996.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.60927037.5
 
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.