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

68 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
jawbones2013485(None) 
jawbone19134441jawbone_
jawboned21133551jawboned
jawboner20133361jawboner
jawboners21133051jawboners
sawbones13126641sawbones
ambones11312682_ambones
hambones1539672hambones
jawlines18126362jawlines
rawboned14114252rawboned
abodes94417513_a_bodes
aboves114512843_a_boves
agones75719863_a_gones
ancones93116343_ancones
arbores94016033_arbores
atones65225773_a_tones
axones134614513_a_xones
backbones1947253backbones
bawbees14337243bawb_ees
bones76446533___bones
cajones163311333ca_jones
calzones1948763calzones
canzones1939153canzones
carbines123617533carbines
carbons115418943carbon_s
cowbanes1537423cowbanes
daemones11209163daemones
daimones11208803daimones
dapsones1138383dapsones
debones103315113_debones
drawbores1542643drawbores
gamboges1435653gamboges
hambone1439313hambone_
hamboned1637003hamboned
hatboxes2055003hatboxes
hipbones1546023hipbones
jabots1538883ja_bo_ts
jaconet16311483ja_conet
jaconets1745613ja_conets
jambes175914053jamb__es
jamboree1944863jamboree
jamborees2043273jamborees
janes124928123ja___nes
jargoned1735233jargoned
jargonel1643683jargonel
jargonels1743153jargonels
jargons1558203jargon_s
jasmines1736623jasmines
jawans1657843jaw_an_s
jawboning22133413jawboning
jawbonings23131683jawbonings
jawline17137063jawline_
jones125028183j___ones
lactones10311223lactones
ladrones92710973ladrones
lawbooks1743743lawbooks
lawines103313563law_ines
lazybones2342273lazybones
madrones112912283madrones
mamboes135011823mambo_es
padrones112711043padrones
pinbones1238143pinbones
rabbonis1245013rabbonis
redbones1137593redbones
sabines94318483sa_bines
sawboneses1541603sawboneses
tailbones1155263tailbones
umbones1138013_umbones

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 Filter1786911461620.423422437.4
2DLD Change Limit146162687.00020880.3
3Display Results68680.0302266.7
 (SQL Overall)178691687.45323975.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.