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

112 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
subpart1131112(None) 
subpar1048661subpar_
subparts1246901subparts
subplot1158132subplot
subvert12312892subvert
support11310522support
apart74330673__apart
boart78835933__boart
compart134016003compart
depart94720563_depart
dispart101115283dispart
dumpcart1543463dumpcart
fubar1039923fub_ar_
gabbart1248883gabbart
impart102715143_impart
mispart111113783mispart
outport9714123outport
part65967463___part
purport1159393purport
quart144027853qu__art
rampart11311993rampart
sabbat10314713sabba_t
scart76139773s__cart
seaport9315603seaport
secpar1037923secpar_
secpars1138413secpars
smart75834093s__mart
spait75631603s__pait
spar65433303s__par_
spare75135563s__pare
spark114920893s__park
spars75431543s__pars
spat66548523s__pa_t
spirt75032953s__pirt
sport75935983s__port
sprat76635973s__prat
spurt77227983s__purt
start55642313s__tart
suba64926603sub_a__
subadar10125583subadar_
subadars11125093subadars
subah106015213sub_a_h
subahs114512383sub_ahs
subalar9118073subalar_
subarea939403sub_area
subarid10310653sub_arid
subas74724073sub_a_s
subbase1139323subbase
subbass1138033subbass
subcaste1287853subcaste
subcult1149603subcult
subduct12107583subduct
subdwarf1743383subdwarf
subedit1049403subedit
suber74924503sub_er_
subers85722643sub_ers
subject18258633subject
sublate9315363sublate
sublet82827243sub_let
sublot82315523sub_lot
submarket1796083submarket
submit10312673sub_mit
subnet82520933sub_net
suboral92011993suboral
suborn8310013sub_orn
subpanel1246073subpanel
subpena1136673subpena
subphase1555603subphase
subplots1255773subplots
subpolar1245183subpolar_
subrace11313003subrace
subrent9315083subrent
subsale9310543subsale
subsect112611843subsect
subsere9311443subsere
subset83122583sub_set
subshaft1645183subshaft
subsist9311573subsist
subspace1445683subspace
subtask1335713subtask
subtaxa1644483subtaxa
subtest9513963subtest
subtext1647653subtext
subtract1249583subtract
subunit948953subunit
suburb1037163sub_urb
subverts1336973subverts
subway1447073subwa_y
subways1536163subways
subzero1835613subzero
sudary1038703su_dary
suffari1345503suffari
sugar6312913su_gar_
sugars7312423su_gars
sugary1039013su_gary
summary14297353summary
sunfast1038503sunfast
sunward1137653sunward
super74924483su_per_
superb104410993su_perb
supers84622403su_pers
supper104115433supper_
suppers113314703suppers
supplant1247823supplant
supports1246513supports
supra73614253su_p_ra
surpass938283surpass
suspect1158513suspect
suspire937803suspire
swart86234643s__wart
tripart9311433tripart
updart9310743_updart

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.420425454.8
2DLD Change Limit1340271127.42318055.6
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.88922650.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.