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

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

31 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
everlastingness19988(None) 
everlastings1651593everlasting___s
everlasting1543864everlasting____
everlastingly2061374everlasting__ly
lastingness1244004____lastingness
exactingness2252125__e_xactingness
graspingness1652095__gr_aspingness
interestingness1671555inter_estingness
overcastings1853955overcasting___s
pleasingness1552925ple__as_ingness
sterlingness1383385sterl___ingness
trustingness1352465__tr_ustingness
versatileness1654015_versa_tileness
aversiveness1896236aver__s_iveness
belongingness1761736_be_longingness
darlingness1373266_darl___ingness
demandingness1861866_de_mandingness
evasiveness1755746ev___as_iveness
evocativeness2154186ev_oca_tiveness
feelingness1553486_feel___ingness
fleetingness1652656___fleetingness
glaringness1343266___gla_ringness
lastingnesses1444136____lastingnesses
liltingness1253046____liltingness
operativeness1876666oper_a_tiveness
overcasting1748516overcasting____
overfatigues1971896overfa_ti_gue_s
pervasiveness2155136_pervas_iveness
superlativeness20283946superla_tiveness
volatileness1553946_v_ola_tileness
yeastiness1344886_ye__asti__ness

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 Filter178691950240.376475242.0
2DLD Change Limit95024318.57611080.2
3Display Results31310.033939.4
 (SQL Overall)178691318.98519887.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.