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

93 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
barehead144660(None) 
baldhead1544272baldhead
barehand1446152barehand
bareheaded1763962bareheaded
barrelhead1651722barrelhead
behead1239922b__ehead
bluehead1444602bluehead
bonehead1445932bonehead
forehead1537892forehead
hardhead1645882hardhead
jarhead1835172jar_head
scarehead1543802scarehead
sorehead1246972sorehead
warhead1436602war_head
ahead96817053_a__head
airhead1136993_airhead
archean1269123_archean
arched125717323_arche_d
bached145519893ba_che_d
bakemeat1655273bakemeat
baldheads1644133baldheads
barathea1345293barathea_
baratheas1444943baratheas
barbed115121313bar_be_d
barbered13259553barbere_d
barchan1469133barch_an
barded105426423bar_de_d
bareboat1249953bareboat
bared85144483bar__e_d
barege94713543barege__
bareges105212033barege_s
barehands1545263barehands
bareness10912813bareness
barfed125416383bar_fe_d
barged105822643bar_ge_d
barghest1447913barghest
barked135027313bar_ke_d
barned95623583bar_ne_d
barred95725803bar_re_d
barreled1137853barrele_d
barrelheads1751533barrelheads
bartend1038753bar_tend
bartered113113033bartere_d
bashed126225703ba_she_d
batched154114243batche_d
bathed125518743ba_the_d
beachhead2042583beachhead
beheads1338523b__eheads
beheld1236413b__eheld
berthed13259123berthe_d
bighead14126653b_ighead
billhead1464433billhead
birched15349913birche_d
birthed13228593birthe_d
blackhead2184303blackhead
blueheads1544063blueheads
bolthead1445903bolthead
boneheads1545203boneheads
bowhead1636433b_owhead
bread85523113b_r__ead
breed85526693b_re_e_d
brewed125411873b_rewe_d
bulkhead1863673bulkhead
bullhead1464783bullhead
butthead1454513butthead
cathead1338753ca_thead
cokehead1845063cokehead
dopehead1544073dopehead
earthed1139923earthe_d
fathead1437863fa_thead
foreheads1647033foreheads
gearhead1344443gear_head
hardheads1745773hardheads
hashhead1443263hashhead
jarheads1944793jar_heads
marched153813403marche_d
masthead1435883masthead
nailhead1243983nailhead
overhead152110363overhead
parched154013693parche_d
preheat12413893_preheat
railhead1244193railhead
redhead1257053__redhead
rehear93713223__rehear
reheard11309023__reheard
reheat94423943__reheat
reread71715433__reread
saphead1357773sa_phead
scareheads1643383scareheads
snakehead1742773snakehead
soreheads1346073soreheads
warheads1545853war_heads
waterhead1644403waterhead

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.436409841.7
2DLD Change Limit146162937.84618628.9
3Display Results93930.0303100.0
 (SQL Overall)178691938.31221498.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.