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

109 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
subcode123716(None) 
subcodes1338141subcodes
subcool1146232subcool
subside10410452subside
subtone9310342subtone
subzone1846992subzone
suicide1038892suicide
abode85518813_ab_ode
aubade939223aub_ade
bode75838753__b_ode
buboed113010003bub_oed
buncoed12378443buncoed
code77347733___code
decode104414743_decode
encode9310443_encode
fucose11167683fu_cose
miscode12310413miscode
mucose10149313mu_cose
outcome11310573outcome
outmode10199663outmode
outrode82313423outrode
precode12311853precode
recode93618713_recode
saccade12107033saccade
sarode75317513s_arode
scone74621833s__cone
scope94821483s__cope
score75526743s__core
secede93311993s_ecede
seconde1037413s_econde
spode84617703s__pode
strode75215973s_trode
stuccoed1352853stuccoed
subacid1248473subacid_
subacute1245753subacute
subbase1139323subbase
subbed114116673subbed_
subcaste1287853subcaste
subcause1265823subcause
subcell1146753subcell
subchief1845103subchief
subclan1147173subclan
subcooled1444403subcooled
subcools1245753subcools
subcordate1553823subcordate
subcortex2043753subcortex
subcult1149603subcult
subcutes1238583subcutes
subdeb1137523sub__deb
subduce12106983subduce
subdue9128493sub_due
subdued11107113subdued
suberose10109693suberose
subfile122010503subfile
subgoal1046323subgoal
subgrade1246053subgrade
subidea1037533sub_idea
subindex1843453subindex
subjoin1645443subjoin
sublate9315363sublate
sublime11310363sublime
subline9316893subline
sublot82315523sublo_t
sublots92410913sublots
subnodal1145043subnodal
suborder1146663suborder
suborn8310013sub_orn
suboxide1845213suboxide
subrace11313003subrace
subrule939643subrule
subsale9310543subsale
subscale1247603subscale
subsere9311443subsere
subsided1257663subsided
subsider1138243subsider
subsides11410823subsides
subsidy1345973subsidy
subsite9412873subsite
subsoil967293subsoil
subsume1146713subsume
subtile91912623subtile
subtle82113433sub_tle
subtones10311383subtones
subtype1444203subtype
subvene1238493subvene
subzones1947223subzones
succeed1235983succeed
succor1036623succo_r
succored13135173succored
succorer12124683succorer
succors1137413succors
succory1444643succory
succoth1445093succoth
succour1144693succour
sucked134120493su_cked
suckle124015963su_ckle
sucre75019103su_c_re
sucrose939303sucrose
suede64419753su__ede
suicided1246033suicided
suicides1139083suicides
sulcate9314423sulcate
sulfide1138103sulfide
sulfone1037483sulfone
sunchoke1744773sunchoke
suppose1137973suppose
surcoat9412923surcoat
syncope1445383syncope
uncoded11312743_uncoded

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 Filter1786911340270.563317390.8
2DLD Change Limit1340271097.37318178.1
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.98222386.7
 
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.