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

49 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
eternalness115382(None) 
eternalnesses1353692eternalnesses
etherealness1552152etherealness
eternalizes20118173eternalizes
eternals8238953eternal___s
ethicalness1653363ethicalness
externalises1955463externalises
literalness1145493liter_alness
materialness1454663materialness
sternness946093stern__ness
eeriness8311874e_er__iness
entertainers1253664entertainers
eternal72910894eternal____
eternalize19118504eternal_ize
eternalized21117334eternalized
eternally1247494eternal__ly
eternises9119454etern_ise_s
eternities1048064eternitie_s
eternizes18118014etern_ize_s
etherealnesses1762314etherealnesses
evenness1135544eve_n__ness
eventless1244604eve_ntl_ess
everydayness226794everydayness
externalise1856084external_ise
externalised2054124externalised
externalism2055934external_ism
externalisms2154954externalisms
externalizes2855814externalizes
externals1666624external___s
fernless1136064_fern_l_ess
formalness1544834_formalness
internalises12149114internalises
liberalness1354514liber_alness
naturalness1153954natur_alness
neutralness1154374neutr_alness
rationalness1254464rationalness
realness8410444___realness
regalness1045474_re_galness
specialness1554054specialness
tearfulness1445484tearfulness
tenableness1347404_te_nableness
tenseness947114_te_nseness
tentless8229844_te_ntl_ess
termless1036234_ter_ml_ess
ternaries9311644_ternarie_s
terranes82514434_terra_ne_s
terseness948404_ter_seness
trendiness1146224_trendiness
venialness1344604_venialness

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.406440125.6
2DLD Change Limit148819499.40615821.7
3Display Results49490.0301633.3
 (SQL Overall)178691499.84218156.0
 
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.