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

113 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
sublimed133721(None) 
sublime11310361sublime_
sublimer1237611sublimer
sublimes12310031sublimes
slimed94915122s__limed
sublated11311502sublated
sublimated1545872sublimated
sublimely1643922sublimely
sublimers1345772sublimers
sublimest1346712sublimest
sublimit1247512sublimit
subline9316892subline_
sublines10315782sublines
subsided1257662subsided
subsumed1344942subsumed
sullied83714482sulli_ed
beslimed1335013beslimed
blamed116017953__blamed
blimey13468453__blimey
blumed114313643__blumed
bullied104514813bulli_ed
cullied104012353culli_ed
culmed114610593cu_l_med
delimed11310723_delimed
dualized1937403dualized
emblemed1544273emblemed
glimed105312283__glimed
gullied93812063gulli_ed
limed85426803___limed
obliged1134983_obliged
outlined92512953outlined
outlived12269583outlived
published1744343published
rubied94312413rub_i_ed
sallied83316953salli_ed
slalomed1134283slalomed
sliced94416313s__liced
slime74925753s__lime_
slimes84722043s__limes
slimmed12368473s__limmed
sliped95417063s__liped
spliced124310593s_pliced
splined105013113s_plined
stylised12215893stylised
stylized21175873stylized
subbed114116673sub__bed
subbreed1345873subbreed
subclimax2252393subclimax
subduced14105163subduced
subdued11107113sub_dued
subedited1345543subedited
suberised1299033suberised
suberized2198823suberized
subfield1444753subfield
subfile122010503subfile_
subfiles131710723subfiles
subfixes20207493subfixes
subhumid1642833subhumid
subidea1037533sub_idea
subitem1138553sub_item
subjoined1944233subjoined
sublate9315363sublate_
sublates10315003sublates
subleased1246123subleased
sublet82827243subl__et
sublevel1384783sublevel
sublimate1347443sublimate
sublimates1447173sublimates
subliming1446543subliming
sublimits1345563sublimits
sublimity1644933sublimity
submitted1445233submitted
suborned1137303suborned
subside10410453subside_
subsider1138243subsider
subsides11410823subsides
subsisted1245783subsisted
subsite9412873subsite_
subsites10312783subsites
subsoiled1245453subsoiled
subsume1146713subsume_
subsumes1246923subsumes
subtile91912623subtile_
subtiler10208573subtiler
subtilized2246143subtilized
subtitled1244713subtitled
suburbed1345143suburbed
subvened1436423subvened
subwayed1753723subwayed
sufficed17205663sufficed
suffixed22214343suffixed
suicided1246033suicided
suited74019423su__ited
sulked114314703su_l_ked
sullies74122233sulli_es
summed114014043su__mmed
summited13246413summited
sunlike112310573sunlike_
supplied1345993suppli_ed
surlier72915443surli_er
surmised1136863surmised
surnamed1135113surnamed
surpliced1444153surpliced
survived1534073survived
suspired1135613suspired
tublike1337083tublike_
unaimed102812493_unaimed
unblamed1337193unblamed
unliked122411283_unliked
unlined82515803_unlined
unlived112511373_unlived
unrimed102211633_unrimed
untimed102713373_untimed

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 Limit1461621136.45322650.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.92225814.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.