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

48 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
shoreline124662(None) 
shorelines1346141shorelines
shoreside1344732shoreside
shoveling1635552shoveling
choline122915383cho__line
chorine123218363chor__ine
chortling1535563chortling
hardline12310273_hardline
harelike1539613_harelike
hireling121210993_hireling
hoelike141411163_ho_elike
homelike17179533_homelike
hornlike1536503_hornlike
horselike1646263_horselike
hoselike15179643_hoselike
hotline10712353_ho_tline
hoveling15189593_hoveling
lobeline1039963_lobeline
reline65434353___reline
shalelike1645883shalelike
sharklike1543933sharklike
shaveling1646843shaveling
shieling123512403sh_ieling
shoaling123111753sho_aling
shoeing113211883sho_e_ing
shoelace1345293sho_elace
shoeshine1543903shoeshine
shooling123012563sho_oling
shorebird1552873shorebird
shoreless1236633shoreless
shoring112820073shor__ing
shortening1445303shortening
shortie10411343shor_ti_e
shorting122514803shor_ting
shortlist1246683shortlist
shovelling1744063shovelling
showering1646403showering
shrewing15228093sh_rewing
shrewlike1943383sh_rewlike
shrine94920053sh_r__ine
sideline91011093s_ideline
smokelike1443493smokelike
snorkeling1542973snorkeling
sordine82515233s_or_dine
soricine10710883s_oricine
storewide1343093storewide
swordlike1742713swordlike
thornlike1643003thornlike

Search took 9 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 Limit148641487.67019379.5
3Display Results48480.0163000.0
 (SQL Overall)178691488.12621990.0
 
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.