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 “bonehead” 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
bonehead144593(None) 
boneheads1545201boneheads
barehead1446602barehead
behead1239922b__ehead
bluehead1444602bluehead
bolthead1445902bolthead
boneheaded1743902boneheaded
bonemeal1245172bonemeal
bowhead1636432bo_whead
cokehead1845062cokehead
dopehead1544072dopehead
forehead1537892forehead
longhead1345082longhead
sorehead1246972sorehead
baldhead1544273baldhead
beheads1338523b__eheads
beheld1236413b__eheld
benched154713943benche_d
bighead14126653b_ighead
billhead1464433billhead
blockhead2152733blockhead
blueheads1544063blueheads
bogeyed1435673bogeye_d
bohea105013733bo__hea_
boheas114013213bo__heas
boltheads1545123boltheads
bonded104719953bon_de_d
boned85133243bon__e_d
boneless10310213boneless
bonemeals1343493bonemeals
boneset9316433bonese_t
bonesets1036843bonesets
boneyard1475323boneyard
boneyer1237403boneye_r
boneyest1347843boneyest
bonged105719603bon_ge_d
bonked135517313bon_ke_d
bonneted1136223bonnete_d
botched153611903botche_d
boughed143810263boughe_d
boweled132810693bowele_d
bowered133113043bowere_d
bowheads1745373bo_wheads
bulkhead1863673bulkhead
bullhead1464783bullhead
bunched154312413bunche_d
butthead1454513butthead
cohead123811123co__head
cokeheads1944473cokeheads
conelrad1145603conelrad
dopeheads1644143dopeheads
foreheads1647033foreheads
godhead1334763go_dhead
hogshead1673923hogshead
honeyed1437773honeye_d
hophead16337923ho_phead
hothead14349293ho_thead
jonesed1536263jonese_d
longheads1444233longheads
lunkhead1642963lunkhead
moneyed1337493moneye_d
overhead152110363_overhead
pinhead13347073pin_head
pothead133810393po_thead
softhead1545003softhead
soreheads1346073soreheads
toolhead1244353toolhead
towhead1435223to_whead

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 Filter1786911461620.420425454.8
2DLD Change Limit146162688.78316641.5
3Display Results68680.0461478.3
 (SQL Overall)178691689.24919320.0
 
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.