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

90 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
interestingness167155(None) 
interesting12411124interesting____
interestingly1753994interesting__ly
trustingness1352464__t_rustingness
everlastingness199885_everlastingness
fleetingness1652655_fle_e_tingness
ingressiveness1864165in_gressiveness
intensiveness1667485inte_ns_iveness
intermingles1574395inter__mingle_s
interstices1348525inter_sti__ce_s
intestines10410255int__esti__ne_s
intrepidness1552515int_re_pi_dness
intrusiveness1656315int_rus_iveness
sterlingness1383385_ster__lingness
teemingness1453165__te_e_mingness
unfeelingness1772105unfe_e_lingness
acceptingness2061736__acceptingness
alternativeness1862616alternativeness
clandestineness1871146clandestineness
enduringness1452226endur___ingness
exactingness2252126___exactingness
feelingness1553486__fe_e_lingness
fittingness1553176fit____tingness
graspingness1652096___graspingness
imperativeness2155476imper_ativeness
impressiveness2164466i_mpressiveness
inattentiveness1862896inattentiveness
indecisiveness2063966indecis_iveness
indirectness1552916indirect___ness
indistinctness1761656in__distinctness
ineffectiveness2683006ineffectiveness
inertness947976in_er__t___ness
informativeness2363156informativeness
inoperativeness2073896inoper_ativeness
insensitiveness1863546insensitiveness
instantness1154086in____stantness
instructiveness2064156instructiveness
intenseness1156576inte_ns___eness
intentness1047366int__e___ntness
interacting14411716interacting____
interactions14410466interacti_on__s
intercepting1748876intercepting____
interceptions1758186intercepti_on__s
intercessions15225886intercessi_on__s
interchangers1972646inter_chang_ers
interchanges1894266inter_chang_e_s
interested11410336interest____e_d
interests9312556interest______s
interfacings1854356interfacing___s
interjecting2248396interjecting____
interjections2277996interjecti_on__s
interliners11138696inter__li__ners
interlines101116456inter__li__ne_s
interlinings1355066inter__linin_gs
intermeshing1855056intermeshing____
intermingle1445766inter__mingle__
intermingled1653456inter__mingle_d
internationals1454246internati_onals
intersecting1549716intersecting____
intersections1598966intersecti_on__s
intersessions13195286intersessi_on__s
interstage1176406inter_st_ag_e__
interstates11710206inter_st__ate_s
interstice1249606inter_sti__ce__
interstimulus1561476inter_sti_mulus
interties9320336inter__ti___e_s
intertwines1446646inter__t_wine_s
interventionism2062376interventi_onism
interventionist1862906interventi_onist
interventions1657516interventi_on__s
intestine9411856int__esti__ne__
intolerantness1461536intole_rantness
intreating11614016int_reating____
intrusting11128176int_rusting____
intuitiveness1656196int__uitiveness
invectiveness2156736in__vectiveness
inventiveness1956976in__ventiveness
lastingness1244006____lastingness
pleasingness1552926_ple_as_ingness
restiveness1449666____restiveness
retiringness1352606retir___ingness
sweepingness1852206_swe_e_pingness
testiness9209756__t__esti__ness
trustiness1036656__t_rusti__ness
trustingnesses1582456__t_rustingnesses
unbecomingness2171026unbe_comingness
uncertainness1572336uncer_tain_ness
underestimates1762866underestimate_s
unforgivingness237916unforgivingness
uninteresting1482206uninteresting____

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 Limit95024908.20311584.1
3Display Results90900.0631428.6
 (SQL Overall)178691908.64220677.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.