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

123 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
support1131052(None) 
supports1246511supports
outport9714122outport
purport1159392purport
rapport11311222rapport
seaport9315602seaport
sport75935982s__port
subpart11311122subpart
superport13410712superport
supper104115432supper_
suppers113314702suppers
supported1444682supported
supporter1344512supporter
suppose1137972suppose
airport9511383airport
aport75432173__aport
carport11316033carport
comport133616843comport
cupper124313863cupper_
cuppers133712213cuppers
deport94922393_deport
disport101015953disport
export15412183_export
gosport101010283gosport
import102713763_import
jetport1646643jetport
mugwort1346753mugwort
nonsupport1451943nonsupport
outports1048273outports
outpost9612443outpost
port66059633___port
puppet93514593pupp_et
purports1265783purports
rapports1245963rapports
report85326023_report
sapor75119253s_apor_
sapors84118813s_apors
sapper103822353sapper_
sappers113518903sappers
scupper1367423scupper_
scuppers1446543scuppers
seaports1038463seaports
sexpot1539543sexpo_t
short85040533s__hort
sipper103920993sipper_
sippers113117753sippers
sippet103519393sipp_et
skort94925643s__kort
slipout949083slipout
snort54833753s__nort
soapwort1347553soapwort
sopor74016493s_opor_
sopors85215203s_opors
sort46264813s___ort
spirt75032953s__pirt
splore81611303s_plore
spoor75016353s_poor_
spoors84014033s_poors
spore75428593s__pore
sports84619183s__ports
sporty115112493s__porty
spot65540693s__po_t
spout75029633s__pout
sprout8419403s_prout
spurt77227983s__purt
stolport1046013stolport
stupor836013stupor_
stupors935883stupors
suasory1046043suasory
sublot82315523sublo_t
suborn8310013su_born
subpar1048663subpar_
subparts1246903subparts
subplot1158133subplot
subvert12312893subvert
succor1036623succor_
succors1137413succors
succory1444643succory
sudor6312623su_dor_
sudors7311103su_dors
suitor63311053suitor_
suitors73012493suitors
sukkot936643sukko_t
sunporch1542603sunporch
sunspot947163sunspo_t
super74924483su_per_
superb104410993su_perb
superports1447833superports
supers84622403su_pers
supped114415703supp_ed
supping123814533supping
supplant1247823supplant
supple10410203supp_le
suppled1248463suppled
suppler1148433suppler
supples11511283supples
supplest1248943supplest
supply1346893supp_ly
supporters1444093supporters
supporting1545563supporting
supportive1753283supportive
supposal1244913supposal
supposed1345783supposed
supposer1245593supposer
supposers1344533supposers
supposes1238203supposes
suppurate1345433suppurate
supra73614253su_p_ra
surcoat9412923surcoat
surtout7411673surtout
suspect1158513suspect
suspire937803suspire
upbore10247883_upbore
upcourt1146103_upcourt
updart9310743_updart
upgirt9117263_upgirt
upmost1068193_upmost
upper93714263_upper_
uppers102912293_uppers
upprop944093_upprop
uproot8314123_uproot
uptore8279453_uptore
uptorn8268093_uptorn

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.403443402.0
2DLD Change Limit1340271237.06318975.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.51223787.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.