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

59 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
uplighted165384(None) 
plighted1546461_plighted
unlighted1455781unlighted
uprighted1654211uprighted
alighted1347672_alighted
blighted1546862_blighted
delighted1546202delighted
flighted1646972_flighted
lighted122913502__lighted
plighter1476622_plighter
relighted1436862relighted
slighted1357392_slighted
unsighted1455432unsighted
uplifted1454422upli_fted
uplight13167362uplight__
uplights14165052uplight_s
bedighted1744583bedighted
benighted1644743benighted
bighted142810923__bighted
blighter1466853_blighter
daylighted1952193daylighted
delighter1445583delighter
dighted132511493__dighted
duplicated1655833duplicated
enlighten1344353enlighten
freighted1755203freighted
frighted1657173_frighted
highted152710163__highted
knighted1745123_knighted
lichted13268803__lichted
ligated92414143__ligated
lighten112811523__lighten
lighter113113443__lighter
mislighted1743653mislighted
obligated13186903obligated
plicated13310643_plicated
plight123513363_plight__
plighters1545533_plighters
plights13299313_plight_s
resighted1436523resighted
righted122912143__righted
sighted123111523__sighted
skylighted2251803skylighted
slighter1257823_slighter
splinted11369253spli_nted
spotlighted1851663spotlighted
unbigoted1343993unbigoted
unlimited1245923unlimited
unlisted9311153unli_sted
unweighted1843153unweighted
uplifter1363903upli_fter
uplighting1743363uplighting
uplinked15254203upli_nked
upright13178293upright__
uprightly18142403uprightly
uprights14145313upright_s
uptight13176033uptight__
uptilted1174683upti_lted
weighted1635593_weighted

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.750238254.7
2DLD Change Limit148641597.59319576.1
3Display Results59590.0301966.7
 (SQL Overall)178691598.37321341.3
 
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.