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

55 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
barytones145556(None) 
baritones1158941baritones
barytone1356021barytone_
barytons1345571baryton_s
barbitones1454752barbitones
baritone1058642baritone_
baryons121010472bary_on_s
barytes124611152baryt__es
baryton1246002baryton__
burstones1187152burstones
earstones948522earstones
acetones10310033_acetones
atones65225773_a__tones
backbones1947253backbones
barbitone1354653barbitone_
bareboned1445103bareboned
barites94322333barit__es
baritonal1144673baritonal
baroness101210063bar__oness
baronet91022203bar__onet
baronets101410903bar__onets
barongs105310833bar__ongs
baronies10315023bar__onies
baronnes1038553bar_onnes
barons85025383bar__on_s
barstools1143543barstools
bartends1136793bar_tends
baryes116218503bary___es
baryon111211613bary_on__
baryonic1546203bary_onic
barytas12378283baryt__as
baryte115312883baryt__e_
batons85519423ba__ton_s
bayonet121212213ba_y_onet
bayonets13135583ba_y_onets
bryonies1336843b_ry_onies
buhrstones1592933buhrstones
burrstones12113833burrstones
burstone1057133burstone_
burtons9310853bur_ton_s
bygones1335913b__ygones
capstones1347373capstones
carotenes11410203carotenes
cartoned111312833car_toned
cartons94122473car_ton_s
earphones1448393earphones
earstone848603earstone_
halftones1545213halftones
lactones10311223la_ctones
lazybones2342273lazybones
marlstones1244513marlstones
maryjanes2142983maryjanes
oxytones1844053_oxytones
partons94620513par_ton_s
tritones83413443_tritones

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641557.34320242.5
3Display Results55550.0134230.8
 (SQL Overall)178691557.52923733.7
 
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.