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 “illuminatingly” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

41 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
illuminatingly209125(None) 
illuminating1553922illuminating__
illuminati1253994illuminati____
illumination1455164illuminati__on
illuminations1554444illuminati_ons
illuminative1763244illuminati__ve
illumining1343504illumin__ing__
illuviating1552944illuvi_ating__
infuriatingly2062084infuri_atingly
intimidatingly21131584intimidatingly
unilluminating1761234unilluminating__
acuminating1645805_acuminating__
calumniating1752485calumniating__
culminating1645735cul_minating__
delaminating1645685delaminating__
eliminating1445545_eliminating__
fascinatingly2261345_fascinatingly
flauntingly1842185flau__n_tingly
fulminating1744685ful_minating__
hallucinating1952335hallucinating__
humiliatingly2261295__humiliatingly
illuminable1552815illumina___ble
illuminance1552815illumina__n_ce
illuminances1652475illumina__nces
illuminant1253995illumina__n__t
illuminants1352905illumina__n_ts
illuminate1245685illuminat____e
illuminated1454435illuminat___ed
illuminates1345085illuminat___es
illuminator1353865illuminat___or
illuminators1453275illuminat__ors
illustrating1372725illustrating__
illustratively2061595illustratively
inseminating1554555inseminating__
insinuatingly1761795i__nsinuatingly
irritatingly1652025i__rritatingly
laminating1348735__laminating__
limitingly1643505__limi__tingly
ruminating1348145__ruminating__
ruminatively2053485__ruminatively
squintingly2442705_squ_in_tingly

Search took 6 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 Filter178691950240.393454684.5
2DLD Change Limit95024415.46617384.6
3Display Results41410.0331242.4
 (SQL Overall)178691415.89230327.7
 
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.