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

81 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
octavo1112478(None) 
octave11157341octave
octavos12134481octavos
octad81510652octa_d
octads987332octads
octagon1045242octagon
octal71214722octa_l
octan71313482octa_n
octane81411632octane
octanol944742octanol
octans81411142octans
octant81216552octant
octaval1243582octaval
octaves12316962octaves
ottava963682ottava
acta69524803acta__
active11313743active
avo68936233___avo
bravo105214343_bravo
calo64936443_c_alo
camo85731753_c_amo
capo85829213_c_apo
catalo8314853catalo
cave95941263_c_ave
cavy125920003_c_avy
centavo1245103centavo
chao95727313_cha_o
ciao64924183_cia_o
claro75018693_claro
clave105420153_clave
clavi104912923_clavi
cotan71521783cota_n
cotans81317923cotans
crave105626313_crave
cyano105512493_cyano
gitano738043gitano
obtain839183obtain
oca56731733oc_a__
ocas66729633oc_a_s
ocean71212963ocea_n
oceans81211003oceans
octadic1245713octadic
octagons1144493octagons
octanes91111393octanes
octanols1044553octanols
octants9128733octants
octet7324063oct_et
octets839403octets
octopi1036533octopi
octopod1244893octopod
octroi837363octroi
octyl10136063oct_yl
octyls11135323octyls
onto46127663ont__o
ortho8312293ort_ho
ottar54313993otta_r
ottars64112223ottars
ottavas1093483ottavas
otto45220643o_t_to
outact8317203outact
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outdo6312703out_do
outgave11259563outgave
outgo6312093out_go
outrave102614413outrave
outsavor1194253outsavor
oxtail1337653oxtail
potato8513433potato
schav1338313schav_
schavs1436493schavs
stave85324993_stave
taco67031353__taco
tao38358953__ta_o
taro46846913__taro
tav66043213__tav_
tavs75630973__tavs
tostado895953tostado
zocalo1735803zoc_alo

Search took 10 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 Filter1786911127160.780229091.0
2DLD Change Limit112716818.81312789.7
3Display Results81810.0302700.0
 (SQL Overall)178691819.62318569.2
 
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.