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

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

70 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
pervertednesses216273(None) 
perversenesses1952632perverse_nesses
pervertedness1963242pervertedne_s_s
centerednesses1753814center_ednesses
concertednesses2064184concertednesses
dejectednesses2553044de_jectednesses
dementednesses1853784de_mentednesses
deservednesses19163454de_servednesses
devotednesses1853234de_v_otednesses
directednesses1863354dir_ectednesses
expectednesses2662914_expectednesses
perfectnesses2053324perfect__nesses
perverseness1752794perverse_ne_s_s
preparednesses1963064prepar_ednesses
reservednesses18163294re_servednesses
serriednesses1454244ser__riednesses
severenesses1545584se_ver_e_nesses
adversenesses1753375_adverse_nesses
affectednesses2382585_affectednesses
aversenesses1545645__averse_nesses
beardednesses1744125be__ardednesses
belatednesses1644315be__latednesses
benightednesses2262395benightednesses
collectednesses2062575collectednesses
conceitednesses2063675conceitednesses
connectednesses2063335connectednesses
contentednesses1863725contentednesses
covertnesses1746315_covert__nesses
delightednesses2162515delightednesses
desperatenesses1863725desperate_nesses
diversenesses1754075_diverse_nesses
educatednesses1852785_educatednesses
effetenesses1854485_effe_te_nesses
elatednesses1346095_e__latednesses
erectnesses1347445_er_ect__nesses
expertnesses2144815_expert__nesses
extendednesses2362625_extendednesses
fervidnesses1943825ferv___idnesses
feverishnesses2382865fe_verishnesses
hurriednesses1752855hur__riednesses
indebtednesses1853385_indebtednesses
learnednesses1443625le__arnednesses
nervelessnesses1754955nervelessnesses
overtnesses1448695__overt__nesses
peakednesses1945025p___eakednesses
peartnesses1338715pe__art__nesses
pepperinesses1653255pepper__inesses
pertnesses12310295p___ert__nesses
pervasivenesses2355155pervasivenesses
perviousnesses1957245perv_iousnesses
petitenesses14169315pe__tite_nesses
pigheadednesses23142925pigheadednesses
pinheadednesses22133385pinheadednesses
pointednesses1654955p__ointednesses
possessednesses081525possessednesses
presentnesses1554405present__nesses
prettinesses1447515p_r_e_ttinesses
priestlinesses1652705p_riestlinesses
privatenesses1855285p_rivate_nesses
relatednesses1444985__relatednesses
repletenesses1554475reple_te_nesses
retirednesses1454555re_tir_ednesses
rootednesses1345315__r_ootednesses
serenenesses12117095ser_e_ne_nesses
servilenesses1646265serv_ile_nesses
spiritednesses1753195spir__itednesses
sveltenesses1545215__svelte_nesses
temperatenesses19113135temperate_nesses
uprootednesses1752325upr_ootednesses
vexednesses2244585___ve_xednesses

Search took 7 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.203880251.2
2DLD Change Limit65874706.04610895.5
3Display Results70700.0461521.7
 (SQL Overall)178691706.29528386.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.