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

51 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
backlighting255247(None) 
jacklighting3051721jacklighting
backlisting2043872backli_sting
alighting1446413_a__lighting
backbiting2144293backbi__ting
backfitting2353073backfi_tting
backlashing2353433backlash_ing
backlight2155703backlight___
backlighted2452813backlight_ed
backlights2253993backlight__s
backlogging2252623backlog_ging
beknighting2251883b_eknighting
blacklisting2152233blackli_sting
blighting1635733b___lighting
cockfighting2851343cockfighting
daylighting2072063da_ylighting
acclimating1845294_acclimating
affrighting2252014_affrighting
backbitings2252334backbi__tings
backdating2045724back__dating
backfilling2352614backfi_lling
backfiring2243814backfi__ring
backflipping2861454backfli_pping
backloading2153824backl_oading
backsliding2153204backsli__ding
backwashing2653094backwash_ing
bedighting1844174b__edighting
bighting15269454b____ighting
bullfighting2251514bullfighting
cockfightings296864cockfightings
daylightings2181014da_ylightings
delighting1644994__delighting
facelifting2052124faceli_fting
facilitating1854014facilitating
flighting1736104___flighting
highlighting2091214highlighting
jacklight2643744jacklight___
jacklighted2951854jacklight_ed
jacklights2752794jacklight__s
knighting1844444___knighting
lighting132811834____lighting
limelighting1961434limelighting
mislighting1843414_mislighting
moonlighting1951694moonlighting
overlighting2044434overlighting
plighting1635564___plighting
preflighting2252654preflighting
relighting1545854__relighting
slighting1436374___slighting
spotlighting1951584spotlighting
uplighting1743364__uplighting

Search took 7 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 Filter1786911247900.393454684.5
2DLD Change Limit124790516.26619915.4
3Display Results51510.0301700.0
 (SQL Overall)178691516.68926714.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.