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

83 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
octadic124571(None) 
ectatic11310122ectatic
oceanic1146162oceanic
octad81510652octad__
octads987332octad_s
acidic113612133ac_idic
acmatic13311693acmatic
actinic111810553actinic
aggadic1254793aggadic
astatic9514193astatic
atavic11189293_atavic
ataxic15169203_ataxic
botanic1159583botanic
cadi75732183_c_adi_
cadis84428503_c_adis
cadmic1338983_c_admic
comatic131816933comatic
comedic14158633comedic
cyanic133110773_cyanic
dryadic1443623dryadic
dyadic1336093_dyadic
ecstatic1246153ecstatic
ectasis9249613ectasis
ectopic1338153ectopic
faradic1337693faradic
fatidic1345723fatidic
gonadic1177213gonadic
hagadic1445863hagadic
hexadic2045413hexadic
icteric1138023icteric
ictic9311803ict__ic
italic839903_italic
monadic1268883monadic
nomadic1248033nomadic
obtain839183obta_in
octagon1045243octagon
octal71214723octa__l
octan71313483octa__n
octane81411633octa_ne
octanes91111393octanes
octanol944743octanol
octans81411143octa_ns
octant81216553octa_nt
octants9128733octants
octaval1243583octaval
octave11157343octa_ve
octaves12316963octaves
octavo11124783octa_vo
octavos12134483octavos
octopi1036533octopi_
octroi837363octroi_
octrois938333octrois
odic74920573o___dic
oghamic1544043oghamic
ontic74418573ont__ic
optic93715183opt__ic
organic1038313organic
osmatic11179983osmatic
otalgic1045063o_talgic
otic66624813o_t__ic
otitic83112683o_titic
outadd837803outad_d
outadds936203outadds
outdid81210923out_did
oxalic1537093o_xalic
oxidic1635943o_xidic
oxtail1337653oxta_il
potamic13310853potamic
saccadic1244173saccadic
satanic939933satanic
scaldic1235943scaldic
scandic1237003scandic
sciatic11910163sciatic
stadia7312143_stadia
static83118673_static
tetanic9810133tetanic
tetradic1145813tetradic
titanic968553titanic
tornadic1144843tornadic
triadic1037833triadic
vanadic1336743vanadic
vocalic1446943voc_alic
voltaic1245453volta_ic

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027838.56315651.9
3Display Results83830.0302766.7
 (SQL Overall)178691838.74920424.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.