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

94 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
bolthead144590(None) 
boltheads1545121boltheads
baldhead1544272baldhead
billhead1464432billhead
bolted94617802bolt_e_d
bonehead1445932bonehead
bowhead1636432bo_whead
bulkhead1863672bulkhead
bullhead1464782bullhead
butthead1454512butthead
gilthead1343322gilthead
hothead14349292ho_thead
pothead133810392po_thead
softhead1545002softhead
althea938203_althea_
altheas1038223_altheas
baldheads1644133baldheads
barehead1446603barehead
bathed125518743b_athe_d
behead1239923b__ehead
belched154011843belche_d
belted94020633belt_e_d
berthed13259123berthe_d
bestead10389123best_ead
bighead14126653b_ighead
billheads1564253billheads
birthed13228593birthe_d
blockhead2152733blockhead
blotched1635653blotche_d
blotted103911833blotte_d
bluehead1444603bluehead
boated94221973boat_e_d
boatload1143403boatload
bohea105013733bo__hea_
boheas114013213bo__heas
bolled94722653bol_le_d
bolter83920753bolt_e_r
bolters94017803bolt_ers
bolthole1345463bolthole
boltless10338283boltless
boneheads1545203boneheads
booted94822733boot_e_d
botched153611903botche_d
bother115218063bo_the_r
bothered142110393bo_thered
bothers124317753bo_thers
bottled104611233bottle_d
boughed143810263boughe_d
bowheads1745373bo_wheads
bulkheads1963373bulkheads
bullheads1564283bullheads
buttheads1553903buttheads
cathead1338753_cathead
clothed134010283clothe_d
cohead123811123co__head
cokehead1845063cokehead
colead94114643col__ead
dopehead1544073dopehead
fathead1437863_fathead
flathead1535803flathead
forehead1537893forehead
giltheads1443123giltheads
goatherd1335263goatherd
godhead1334763go_dhead
hogshead1673923hogshead
hophead16337923ho_phead
hotheads15318013ho_theads
jolted143510633jolt_e_d
loathed11419443loathe_d
longhead1345083longhead
lowlihead1641693lowlihead
masthead1435883masthead
meathead1436793meathead
molted94217473molt_e_d
mouthed133811043mouthe_d
outhear10910603_outhear
outheard1288543_outheard
outlead83311103_outlead
outread82811093_outread
pithead13419593_pithead
plowhead1742803plowhead
postheat13411243postheat
potheads14298543po_theads
shithead1535523shithead
shorthead1644473shorthead
softheads1644553softheads
soothed113712743soothe_d
sorehead1246973sorehead
southed114313993southe_d
toolhead1244353toolhead
toothed113310243toothe_d
towhead1435223to_whead
wellhead1543503wellhead
worthed1437873worthe_d

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 Limit146162947.09320606.5
3Display Results94940.0303133.3
 (SQL Overall)178691947.54623680.2
 
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.