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

81 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
hopheads1727660(None) 
hophead16337921hophead_
hotheads15318011hotheads
bowheads1745372bowheads
coheads13289232co_heads
dopeheads1644142dopeheads
dropheads1643872dropheads
godheads1443982godheads
hogsheads1773662hogsheads
hoptoads1444142hoptoads
hothead14349292hothead_
potheads14298542potheads
sapheads1466082sapheads
towheads1544812towheads
airheads1246133airheads
beheads1338523_beheads
bigheads15145653bigheads
boheas114013213bo_hea_s
boltheads1545123boltheads
boneheads1545203boneheads
bowhead1636433bowhead_
catheads1438123catheads
cepheids1644243cepheids
cohead123811123co_head_
cokeheads1944473cokeheads
coleads102911423co_leads
copyreads1743323copyreads
cowherds1735423cowherds
dopehead1544073dopehead_
drophead1544613drophead_
eggheads1442923eggheads
fatheads1536763fatheads
foreheads1647033foreheads
godhead1334763godhead_
gophers1338983gophe_rs
hardheads1745773hardheads
hashheads1543393hashheads
heads95127113___heads
heptads1335873hep_tads
hodads1147963ho__dads
hogshead1673923hogshead_
hogweeds1642853hogweeds
hoped115628183hop_e_d_
hopers114222973hop_e_rs
hopes105835643hop_e__s
hopped144318113hoppe_d_
hoppers143115143hoppe_rs
hoptoad1344323hoptoad_
hotbeds13315003hotbe_ds
hotheaded1744853hotheaded
hyphens1836043hyphe_ns
impleads13294593impleads
jarheads1944793jarheads
jugheads2042923jugheads
lipreads1144223lipreads
longheads1444233longheads
mopeds11499663mop_e_ds
oreads73915773_o_reads
pinheads14336243pinheads
pitheads14338143pitheads
pleads94613953__pleads
plowheads1842563plowheads
poppyheads2051393poppyheads
pothead133810393pothead_
redheads1336173redheads
repleads11357203repleads
saphead1357773saphead_
sheepheads1943653sheepheads
shepherds1843223shepherds
shitheads1645043shitheads
shophars1646353shoph_ars
shortheads1743813shortheads
softheads1644553softheads
soreheads1346073soreheads
spreads1039763_spreads
subheads1496533subheads
toolheads1343673toolheads
tophes115218423tophe__s
towhead1435223towhead_
upheaps1494233_upheaps
warheads1545853warheads

Search took 7 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.1731032896.0
2DLD Change Limit146162816.53022383.2
3Display Results81810.0332454.5
 (SQL Overall)178691816.73626527.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.