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

50 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
limelighted185179(None) 
limelight1544242limelight__
limelights1652792limelight_s
delighted1546203__delighted
highlighted1951383highlighted
lamplighter1951553lamplighter
limelighting1961433limelighting
mislighted1743653mi_slighted
relighted1436863__relighted
alighted1347674___alighted
backlighted2452814backlighted
bedighted1744584__bedighted
benighted1644744__benighted
blighted1546864___blighted
daylighted1952194_daylighted
delighter1445584__delighter
firefighter2172034firefighter
firelight1655534firelight__
firelights1764014firelight_s
flighted1646974___flighted
floodlighted2161014floodlighted
foresighted1952904foresighted
freighted1755204_fre_ighted
greenlighted1861264greenlighted
implicated1745974_implicated
jacklighted2951854jacklighted
lamplight1743844lamplight__
lamplighters2051284lamplighters
lamplights1852664lamplight_s
levigated1445644l__evigated
lighted122913504____lighted
likelihood1861344likeli_hood
limited102310234lim__i__ted
litigated1146564li__tigated
livelihood1751304liveli_hood
longsighted1751384longsighted
moonlighted1851944moonlighted
overlighted1944214overlighted
plighted1546464___plighted
preflighted2172784preflighted
resighted1436524__resighted
sidelight14175484sidelight__
sidelights15153704sidelight_s
skylighted2251804_skylighted
slighted1357394___slighted
spotlighted1851664spotlighted
unlighted1455774__unlighted
unweighted1843154unwe_ighted
uplighted1653844__uplighted
weighted1635594__we_ighted

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819509.17316223.6
3Display Results50500.0301666.7
 (SQL Overall)178691509.37619058.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.