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 “supports” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
supports124651(None) 
support11310521support_
outports1048272outports
purports1265782purports
rapports1245962rapports
seaports1038462seaports
sports84619182s__ports
subparts1246902subparts
superports1447832superports
suppers113314702supper_s
supported1444682supported
supporter1344512supporter
supporters1444092supporters
supposes1238202supposes
airports1046463airports
carports1238943carports
comports143411983comports
cuppers133712213cupper_s
deports105012883_deports
disports111111113disports
exports1647983_exports
gosports1185913gosports
imports11309623_imports
jetports1743533jetports
mugworts1443443mugworts
nonsupports1551063nonsupports
outport9714123outport_
outposts1037253outposts
ports75934593___ports
puppets10317013pupp_ets
purport1159393purport_
rapport11311223rapport_
reports94916213_reports
sapors84118813s_apor_s
sappers113518903sapper_s
scuppers1446543scupper_s
seaport9315603seaport_
sexpots1636293sexpo_ts
shorts95321743s__horts
sippers113117753sipper_s
sippets113310183sipp_ets
skorts104211303s__korts
slipouts1044893slipouts
snorts64116503s__norts
soapworts1444323soapworts
sopors85215203s_opor_s
sorts54536663s___orts
spirts85317133s__pirts
splores91910953s_plores
spoors84014033s_poor_s
spores84726613s__pores
sport75935983s__port_
sporty115112493s__porty
spots74424113s__po_ts
spouts85115113s__pouts
sprouts949983s_prouts
spurts84814973s__purts
stolports1143483stolports
stupors935883stupor_s
sublots92410913sublo_ts
suborns939493su_borns
subpart11311123subpart_
subplots1255773subplots
subverts1336973subverts
succors1137413succor_s
sudors7311103su_dor_s
suitors73012493suitor_s
sunporch1542603sunporch
sunspots1045083sunspo_ts
superport13410713superport_
supers84622403su_per_s
supper104115433supper__
supplants1344873supplants
supples11511283supp_les
supplest1248953supplest
supplies1268843supplies
supporting1545563supporting
supportive1753283supportive
supposal1244913supposal
supposals1343883supposals
suppose1137973suppo_se
supposed1345783supposed
supposer1245593supposer
supposers1344533supposers
suppress1236443suppress
suppurate1345433suppurate
suppurates1445043suppurates
surcoats1047943surcoats
surtouts846203surtouts
suspects1254863suspects
suspires1038203suspires
updarts1034203_updarts
uppers102912293_upper_s
upprops1044223_upprops
uproots937143_uproots

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.830215290.4
2DLD Change Limit146162957.21620255.3
3Display Results95950.0462065.2
 (SQL Overall)178691958.09222082.4
 
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.