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

60 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
backbones194725(None) 
backbone1847441backbone_
backboned2045481backboned
backbends2044092backbends
backbites19108632backbites
backhoes1938542backho_es
acetones10310033_acetones
ambones11312683_a_mbones
backaches22146813backaches
backbeats1945763backbeats
backbench2452183backbench
backbenches2651783backbenches
backbend1944783backben_d
backbite1899173backbite_
backbiter191786803backbiter
backbiters2095583backbiters
backblocks2152853backblocks
backboard2047183backboard
backboards2146193backboards
backdates1848153backdates
backfires2046173backfires
backhands2146303backhands
backhoe1847153backho_e_
backhoed2047013backho_ed
backhouse2046143backhouse
backhouses2145743backhouses
backings174012213back_ings
backlands1846823backlands
backloads1846293backloads
backlogs1746633backlo_gs
backouts1698643back_outs
backrooms1945633backrooms
backshores2145323backshores
backsides1887693backsides
backwoods2146393backwoods
bacons104917583bac__on_s
balklines1536743balklines
bandboxes2143793bandboxes
bankbooks1643083bankbooks
banknotes1544313banknotes
bareboned1445103bareboned
baritones1158943baritones
barytones1455563barytones
beckoned1735783beck_oned
beckoner1654963beck_oner
beckoners1744063beck_oners
beckons15279143beck_on_s
blackbodies2252493blackbodies
blackboys2243333blackbo_ys
buckoes153810393buck_o_es
hambones1539673ha_mbones
jackboots2443643jackboots
jackstones2344053jackstones
jawbones20134853ja_wbones
kickboxes2342673kickboxes
lactones10311243lac_tones
lazybones2342273lazybones
lockboxes2453453lockboxes
sawbones13126643sa_wbones
tailbones1155263tailbones

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 Filter1786911486410.533335255.2
2DLD Change Limit148641609.18616181.3
3Display Results60600.0331818.2
 (SQL Overall)178691609.75218323.5
 
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.