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

107 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
subcodes133814(None) 
subcode1237161subcode_
subcools1245752subcools
subcutes1238582subcutes
subsides11410822subsides
subtones10311382subtones
subzones1947222subzones
suicides1139082suicides
abodes94417513_ab_odes
aubades1038753aub_ades
bodes84935103__b_odes
buboes104513993bub_o_es
codes86247293___codes
custodes1136653custodes
decodes113914983_decodes
encodes10310643_encodes
fucoses12148303fu_coses
juncoes16338073junco_es
miscodes13310423miscodes
outcomes1239763outcomes
outmodes11208963outmodes
precodes13711573precodes
recodes102918633_recodes
saccades13137253saccades
sarodes84216143s_arodes
scones84521303s__cones
scopes104719593s__copes
scores84725923s__cores
secedes103711983s_ecedes
secondes1138133s_econdes
spodes94817433s__podes
stuccoes1254273stucco_es
subbases1239063subbases
subcastes1387493subcastes
subcause1265823subcause
subcauses1346213subcauses
subcells1246283subcells
subchief1845103subchief
subchiefs1942743subchiefs
subclans1247413subclans
subclass1246623subclass
subcool1146233subco_ol
subcooled1444403subcooled
subcortex2043753subcortex
subcults1246933subcults
subcutis1246293subcutis
subdeb1137523sub__deb
subdebs1236483sub__debs
subduces1397263subduces
subdues1099893sub_dues
subechoes1644563subechoes
subfiles131710723subfiles
subfixes20207493subfixes
subgoals1145553subgoals
subgrades1346313subgrades
subidea1037533sub_idea
subideas1146443sub_ideas
subindex1843453subindex
subjoins1745453subjoins
sublates10315003sublates
sublimes12310033sublimes
sublines10315783sublines
sublots92410913sublo_ts
subnodal1145043subnodal
suborder1146663suborder
suborders1245503suborders
suborns939493sub_orns
suboxides1944993suboxides
subraces12313033subraces
subrules1039723subrules
subsales10310123subsales
subscales1347343subscales
subseres10312423subseres
subside10410453subside_
subsided1257663subsided
subsider1138243subsider
subsiders1246053subsiders
subsidies1248423subsidies
subsites10312783subsites
subsoils1076653subsoils
subsumes1246923subsumes
subtone9310343subtone_
subtypes1544553subtypes
subvenes1339633subvenes
subzone1846993subzone_
succeeds1343693succeeds
succored13135173succored
succorer12124683succorer
succorers13124203succorers
succories1347183succories
succors1137413succo_rs
succours1244593succours
suckles134516743su_ckles
sucres84218893su_c_res
sucroses1039933sucroses
suedes73918113su__edes
suicide1038893suicide_
suicided1246033suicided
sulfides1238053sulfides
sulfones1147683sulfones
sunchokes1864733sunchokes
supposes1238203supposes
surcoats1047943surcoats
syboes1139343syb_o_es
sycoses1249133s_ycoses
syncopes1545763syncopes
uncoded11312743_uncoded

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.456391866.2
2DLD Change Limit1461621077.60619216.7
3Display Results1071070.0462326.1
 (SQL Overall)1786911078.10822038.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.