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

118 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
sublimer123761(None) 
sublime11310361sublime_
sublimed1337211sublimed
sublimers1345771sublimers
sublimes12310031sublimes
sublimely1643922sublimely
sublimest1346712sublimest
sublimit1247512sublimit
subline9316892subline_
sublines10315782sublines
subsider1138242subsider
subtiler10208572subtiler
surlier72915442surli_er
blamer104417143__blamer
blimey13468453__blimey
bubblier1184473bubbli_er
bullier94116433bulli_er
burblier1255603burbli_er
burlier93514413burli_er
curlier93314183curli_er
dulcimer1343173dulcimer
fubsier12367763fubsi_er
nubbier11308133nubbi_er
nubblier1254413nubbli_er
obliger1035283_obliger
outlier72216143outli_er
outliner82412113outliner
outliver11268783outliver
publisher1644213publisher
qualmier1934563qualmier
rubblier1244913rubbli_er
rubier84814743rub_i_er
rulier65016353ru_li_er
sallier73320423salli_er
scalier94316913scali_er
shalier103116423shali_er
sillier74017593silli_er
slalomer1045033slalomer
slicer84117603s__licer
slider73918363s__lider
slier54827243s__li_er
slime74925753s__lime_
slimed94915123s__limed
slimes84722043s__limes
slimier93212013s__limier
slimmer114211343s__limmer
sliver94116593s__liver
snubbier1244993snubbi_er
solider82912453s_olider
splicer114710523s_plicer
squalider1943843squalider
stolider936603stolider
stubbier1235353stubbi_er
stubblier1343203stubbli_er
studlier935473studli_er
styliser11185523styliser
stylizer20185443stylizer
subclimax2252393subclimax
subduer10107033sub_duer
suber74924503sub___er
subfile122010503subfile_
subfiles131710723subfiles
subfixes20207493subfixes
subidea1037533sub_idea
subitem1138553sub_item
sublate9315363sublate_
sublated11311503sublated
sublates10315003sublates
sublet82827243subl__et
sublevel1384783sublevel
sublimate1347443sublimate
sublimated1545873sublimated
sublimates1447173sublimates
subliming1446543subliming
sublimits1345563sublimits
sublimity1644933sublimity
sublunar1044103sublunar
submitter1345283submitter
suborder1146663suborder
suborner1047383suborner
subside10410453subside_
subsided1257663subsided
subsiders1246053subsiders
subsides11410823subsides
subsister1145983subsister
subsite9412873subsite_
subsites10312783subsites
subsoiler1145323subsoiler
subsume1146713subsume_
subsumed1344943subsumed
subsumes1246923subsumes
subtile91912623subtile_
subtler92910843sub_tler
subvicar1544583subvicar
subwriter1445623subwriter
suckier133613973sucki_er
sudsier868783sudsi_er
sufficer16225823sufficer
suiter64121813su__iter
sulker104015923su_l_ker
sulkier113811963su_lkier
sullener857243sullener
sullied83714483sulli_ed
sullies74122233sulli_es
summer104017713su__mmer
sunlike112310573sunlike_
sunnier73412153sunni_er
supplier1246603suppli_er
supremer1246483supremer
surfier102613543surfi_er
surmiser1036763surmiser
surnamer1044883surnamer
surviver1434683surviver
sutler63718393sutl__er
tubbier11237743tubbi_er
tublike1337083tublike_
uglier748953_ugli_er
unlimber1243373_unlimber

Search took 9 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.436409841.7
2DLD Change Limit1461621187.65619091.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911188.13821957.6
 
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.