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

72 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
necklines1511572(None) 
neckline1496361neckline_
declines113315802dec_lines
neckings15346112neck_ings
necklaces1743512necklaces
necklike13104562necklike_
neckties1445902neckti_es
reclines103718542rec_lines
arecolines1246503arecolines
balklines1536743balklines
beelines103312803be_elines
beltlines1135963beltlines
berlines102315453be_rlines
clines84926043__c_lines
deadlines11138503deadlines
deckings16346683deck_ings
deckles143312803deckl__es
decline103716613dec_line_
declined123910883dec_lined
decliner113710843dec_liner
decliners12358613dec_liners
ducklings17204013ducklings
felines104718073fe__lines
headlines13119013headlines
heckles163711383heckl__es
heckling18257163hecklin_g
hemlines13310623he_mlines
inclines10313143inc_lines
keckles12318763keckl__es
keckling14245523kecklin_g
mescalines1447293mescalines
nebulises1145063nebulises
nebulizes2044413nebulizes
neckbands1842383neckbands
necking143913893neck_in_g
necklace1643643necklace_
necklaced1842593necklaced
neckless14236433neckl_ess
neckpieces2052013neckpieces
necktie1344363neckti_e_
nectarines1246893nectarines
needlings11294693needlings
negliges1034833ne_gliges
nellies73418723ne_lli_es
nephelines1544843nephelines
nervines112310463ne_rvines
nestlings1074313nestlings
neurines8311193ne_urines
nickles133713823nickl__es
nickling15278703nicklin_g
nicotines1148353nicotines
nuclides1146553nuc_lides
pectines121914683pec_tines
pemolines1348623pemolines
percalines1449743percalines
picolines1339623picolines
recline94020493rec_line_
reclined113613603rec_lined
recliner103211913rec_liner
recliners11279113rec_liners
redlines93916083re_dlines
relines75331323re__lines
rocklings16224843rocklings
setlines8312743se_tlines
sicklies14710013sickli_es
sickliness1645003sickliness
sucklings16225113sucklings
tacklings16235853tacklings
trucklines1644293trucklines
weakliness1753853weakliness
weaklings1794003weaklings
weeklies1534913weekli_es

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.440406115.9
2DLD Change Limit148641726.59322545.3
3Display Results72720.0302400.0
 (SQL Overall)178691727.06325299.6
 
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.