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 “loggerhead” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
loggerhead165145(None) 
loggerheads1751231loggerheads
copperhead2042353copperhead
letterhead1442363letterhead
logorrhea1352203logorrhea_
logorrheas1451783logorrheas
longhead1345083long__head
overhead152110363_o_verhead
bonehead1445934bo_ne_head
buggered1335624bugger_e_d
chowderhead24111394chowderhead
cokehead1845064co_ke_head
copperheads2151894copperheads
daggered12246404dagger_e_d
doggerel1143454dogger_e_l
doggerels1252154dogger_els
doggeries1246674doggerie_s
dopehead1544074do_pe_head
dunderhead1642974dunderhead
egghead1343434_egg__head
figurehead1851034figurehead
forehead1537894fo_re_head
gearhead1344444__gearhead
hammerhead2152194hammerhead
hogshead1673924ho_g_shead
jiggered1834204jigger_e_d
laagered1055854laager_e_d
lagered92311154l_ager_e_d
letterheads1552154letterheads
lingered10129644linger_e_d
logged96622944logg___e_d
logger86420004logger____
loggers94616134logger___s
logorrheic1661734logorrheic
loitered938184loiter_e_d
longheads1444234long__heads
loppered13326754lopper_e_d
louvered1244994louver_e_d
lowered112711914lo_wer_e_d
lowlihead1641694lo_wlihead
mongered1238954monger_e_d
overheads16248934_o_verheads
overheap16257344_o_verheap
overhear14249414_o_verhear
overheard16246624_o_verheard
overheat142413774_o_verheat
overheld15197374_o_verheld
riverhead1643004_riverhead
rogered939554ro_ger_e_d
saggered11237554sagger_e_d
showerhead2051954showerhead
sorehead1246974so_re_head
timberhead18152084timberhead
toggeries1146214toggerie_s
waterhead1644404_waterhead
woodenhead1851634woodenhead

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 Filter1786911614500.436409841.7
2DLD Change Limit161450569.36017248.9
3Display Results56560.0331697.0
 (SQL Overall)178691569.82918180.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.