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

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
spiritualnesses1782131spiritualnesses_
spiritualness1562693spiritualne_s_s_
spiritednesses1753224spirit_ednesses_
habitualnesses1962215_habitualnesses_
initialnesses1395615__initialnesses_
pitifulnesses1855575_pitifu_lnesses_
specialnesses1753865speci__alnesses_
spiritlessness1582565spirit__l_essness
spiritualisms17103825spiritual__isms_
spiritualists15123665spiritual__ists_
spiritualities1663695spiritual_ities_
spiritualizes2463385spiritual__izes_
spiritualties1562295spiritual__ties_
spitefulnesses1954415spitefu_lnesses_
sportfulnesses1964175spor_tfulnesses_
spuriousnesses1557025spuriou_snesses_
criticalnesses1853156__criticalnesses_
effectualnesses2391816effectualnesses_
factualnesses1853696__factualnesses_
finicalnesses1853836_fini_calnesses_
gradualnesses1552886__gradualnesses_
lyricalnesses1853106_lyri_calnesses_
palatialnesses1653386_palatialnesses_
poeticalnesses1853106_poeticalnesses_
scornfulnesses1953206scornfu_lnesses_
seriousnesses1249886s_eriou_snesses_
shrillnesses1543506s_hri__llnesses_
sinfulnesses1546136s_i_nfu_lnesses_
skillfulnesses2152656skillfu_lnesses_
spaciousnesses17147186spaciou_snesses_
speciousnesses17146906speciou_snesses_
spicinesses1547106spici____nesses_
spikinesses1746526spiki____nesses_
spininesses1358456spini____nesses_
spiritedness1553786spirit_edne_s_s_
spiritless1243746spirit__l_e_s_s_
spiritlessly1751746spirit__l_ess_ly
spiritualism1693996spiritual____ism
spiritualist14114256spiritual____ist
spiritualistic18112386spiritual__istic
spiritualize2363516spiritual__ize__
spiritualized2563186spiritual__ize_d
spirituals1253556spiritual_____s_
sportinesses1447876spor_t__inesses_
sportivenesses1956286spor_tivenesses_
sprightlinesses2161826sp_rightlinesses_
springinesses16104066sp_ri_nginesses_
sprucenesses1694616sp_r__ucenesses_
verticalnesses1953676_verticalnesses_
vitalnesses1456276___vit_alnesses_
wearifulnesses2054656wearifu_lnesses_

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 Filter178691658740.343520965.0
2DLD Change Limit65874515.15612776.2
3Display Results51510.0461108.7
 (SQL Overall)178691515.54532225.6
 
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.