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

38 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
bonemeal124516(None) 
bonemeals1343471bonemeals
bonehead1445932bonehead
axonemal1743543axonem_al
bakemeat1655273bakemeat
bemean10410683b__emean
binomial1246223binomial
bodement13410123bodement
bohemia1446363bohemia_
bohemian1544763bohemian
bohemias1545983bohemias
bondman1238043bondm_an
bondmen1237893bondme_n
boneheads1545203boneheads
boneless10310213boneless
boneset9316433bonese_t
bonesets1036843bonesets
boneyer1237403boneye_r
boneyest1347843boneyest
bonspell1243163bonspell
boreal84817213bo__real
conceal113313013con_ceal
congeal104011683con_geal
cornmeal1245853cornmeal
funereal1143943funereal
monomial12410133monomial
noncereal1157743noncereal
nonequal1746053nonequal
nonideal947303nonideal
nonmeat9312773non_meat
nonmetal1049643nonmetal
oatmeal944973_oatmeal
premeal11310523_premeal
somedeal1144573somedeal
toneme8312103toneme__
tonemes9311683toneme_s
venereal1145083venereal
wholemeal1752273wholemeal

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 Filter1786911461620.470380193.6
2DLD Change Limit146162387.53319402.9
3Display Results38380.0132923.1
 (SQL Overall)178691388.01622291.8
 
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.