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

76 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
sprightlinesses2161821sprightlinesses_
sightlinesses1743863s__ightlinesses_
sprightliness1962093sprightline_s_s_
knightlinesses2282444_knightlinesses_
priestlinesses1652724_priestlinesses_
unsightlinesses1962214unsightlinesses_
uprightnesses19122784upright__nesses_
almightinesses2051835almight_inesses_
brightnesses1844185_bright__nesses_
flightinesses2053135_flight_inesses_
gristlinesses1443995_gri_stlinesses_
mightinesses1844385__might_inesses_
pricklinesses2143625_pri_cklinesses_
princelinesses1892725_princelinesses_
rightnesses1546235__right__nesses_
saintlinesses1344365s_ai_ntlinesses_
sightliness1574565s__ightline_s_s_
slightnesses1654625s_light__nesses_
sprightliest18102345sprightli____est
springinesses16104065spri__nginesses_
straightnesses1872585straight__nesses_
uptightnesses1982225uptight__nesses_
weightinesses2052905_weight_inesses_
airtightnesses1851846airtight__nesses_
benightednesses2262416benightednesses_
brittlenesses1584236_bri_ttlenesses_
delightednesses2162536delightednesses_
doughtinesses1852556_dought_inesses_
droughtinesses1951836drought_inesses_
earthlinesses1643916ear_th_linesses_
friendlinesses1852216_friendlinesses_
frightfulnesses2562906_frightfulnesses_
grislinesses1345826_gri__slinesses_
grittinesses1345846_gri__ttinesses_
haughtinesses2042166_haught_inesses_
knightliness2052736_knightline_s_s_
lightnesses1546146__light__nesses_
naughtinesses1752416_naught_inesses_
pigginesses1555616_p_ig__ginesses_
pithinesses1637506_p_i__thinesses_
portlinesses1446996_p__ortlinesses_
prettinesses1447546_pr__ettinesses_
priestliness1452926_priestline_s_s_
priggishnesses2152376_priggishnesses_
prissinesses1355956_pri__ssinesses_
privatenesses1855346_privat_enesses_
rightfulnesses2174466__rightfulnesses_
ritzinesses2096746__ri__tzinesses_
shiftinesses18105246s_hi_ft_inesses_
shrillnesses1543506shri___llnesses_
sicklinesses1844866s__i_cklinesses_
sightlessness1654156s__ightl__essness
sightlessnesses1755036s__ightlessnesses_
sightlines1465756s__ightlin___es_
sillinesses1169846s__i__llinesses_
spicinesses1547106sp_i___cinesses_
spiffinesses2043016sp_i__ffinesses_
spikinesses1746526sp_i___kinesses_
spininesses1358456sp_i___ninesses_
spiritednesses1753226sp_iritednesses_
spiritualnesses1782136spiritual_nesses_
splashinesses1742736splash__inesses_
sponginesses1544776spong___inesses_
sportinesses1447876sp__ort_inesses_
spottinesses1445686sp___ottinesses_
sprightfulness2362206sprightfulne_s_s_
sprightlier1751886sprightli____e_r
squishinesses2442946squish__inesses_
strictnesses1445416stri_ct__nesses_
stringinesses14124536stri__nginesses_
surlinesses11310056sur____linesses_
thriftinesses1952316thri_ft_inesses_
tightnesses1565586__tight__nesses_
unsightliness1762516unsightline_s_s_
uppitinesses16103706uppi__t_inesses_
uprightness1752856upright__ne_s_s_

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.0931921408.6
2DLD Change Limit65874765.11012891.2
3Display Results76760.0461652.2
 (SQL Overall)178691765.24934042.9
 
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.