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 “headlands” 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
headlands144490(None) 
headbands1644341headbands
headland1345611headland_
badlands1236672_badlands
headband1544842headband_
headends13326722head_ends
headlamps1742472headlamps
headlines13119012headlines
headstands1543852headstands
headwinds1743152headwinds
heartlands1462952heartlands
heathlands1743402heathlands
wheatlands1751992wheatlands
alands75418373__a_lands
badland1147653_badland_
deadlines11138503deadlines
deadpans12205173deadpan_s
deodands1144603deod_ands
dreamlands1441853dreamlands
elands74914773_e__lands
fenlands1245183fe_nlands
flatlands1364303flatlands
garlands1038323_garlands
graduands1243583graduands
hatbands1446293h_atbands
headboards1744333headboards
headend12398363head_end_
headgates1446383headgates
headhunts1643123headhunts
headings133510493head_ings
headlamp1642853headla_mp
headless12289863headl_ess
headline12129613headlin_e
headlined14135133headlined
headliner13135393headliner
headliners14144333headliners
headlocks1944463headlocks
headlong1334123headlon_g
headman13229633headman__
headpins1436103headpin_s
headraces1546623headraces
headsails1343943headsails
headstand1444523headstand_
headways1845003headwa_ys
headwind1643873headwind_
headwords1745343headwords
heartland1343653heartland_
heathland1643963heathland_
highlands17114113highlands
hollands12247273h_ollands
homelands1545453homelands
lallands9338583_lallands
leadplants1352593leadplants
meadowlands1891193meadowlands
midlands1245543_midlands
playlands1543893playlands
relands85214883re__lands
scablands1443783scablands
sealants82610743sea_lants
seaplanes1148723seaplanes
shetlands1343743she_tlands
weasands1244563wea_sands
weazands2143333wea_zands
wetlands1244763we_tlands
wheatland1641953wheatland_
wildlands1443273wildlands
woodlands1444153woodlands
yardlands1443583yardlands

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 Filter1786911486410.436409841.7
2DLD Change Limit148641686.54622707.1
3Display Results68680.0332060.6
 (SQL Overall)178691687.01525472.7
 
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.