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

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
pervertednesses2162761pervertednesses_
perversenesses1952663perverse_nesses_
pervertedness1963273pervertedne_s_s_
centerednesses1753845center_ednesses_
concertednesses2064215concertednesses_
dejectednesses2553075de_jectednesses_
dementednesses1853815de_mentednesses_
deservednesses19163485de_servednesses_
devotednesses1853275de_v_otednesses_
directednesses1863385dir_ectednesses_
expectednesses2662955_expectednesses_
perfectnesses2053355perfect__nesses_
perverseness1752825perverse_ne_s_s_
preparednesses1963095prepar_ednesses_
reservednesses18163325re_servednesses_
serriednesses1454275ser__riednesses_
severenesses1545615se_ver_e_nesses_
adversenesses1753396_adverse_nesses_
affectednesses2382606_affectednesses_
aversenesses1545666__averse_nesses_
beardednesses1744146be__ardednesses_
belatednesses1644336be__latednesses_
benightednesses2262416benightednesses_
collectednesses2062596collectednesses_
conceitednesses2063696conceitednesses_
connectednesses2063356connectednesses_
contentednesses1863746contentednesses_
covertnesses1746336_covert__nesses_
delightednesses2162536delightednesses_
desperatenesses1863746desperate_nesses_
diversenesses1754106_diverse_nesses_
educatednesses1852836_educatednesses_
effetenesses1854526_effe_te_nesses_
elatednesses1346116_e__latednesses_
erectnesses1347476_er_ect__nesses_
expertnesses2144846_expert__nesses_
extendednesses2362656_extendednesses_
fervidnesses1943846ferv___idnesses_
feverishnesses2382886fe_verishnesses_
hurriednesses1752876hur__riednesses_
indebtednesses1853406_indebtednesses_
learnednesses1443646le__arnednesses_
nervelessnesses1754986nervelessnesses_
overtnesses1448716__overt__nesses_
peakednesses1945046p___eakednesses_
peartnesses1338746pe__art__nesses_
pepperinesses1653276pepper__inesses_
pertnesses12310316p___ert__nesses_
pervasivenesses2355206pervasivenesses_
perviousnesses1957306perv_iousnesses_
petitenesses14169366pe__tite_nesses_
pigheadednesses23142946pigheadednesses_
pinheadednesses22133406pinheadednesses_
pointednesses1654976p__ointednesses_
possessednesses081546possessednesses_
presentnesses1554426present__nesses_
prettinesses1447546p_r_e_ttinesses_
priestlinesses1652726p_riestlinesses_
privatenesses1855346p_rivate_nesses_
relatednesses1445006__relatednesses_
repletenesses1554496reple_te_nesses_
retirednesses1454586re_tir_ednesses_
rootednesses1345336__r_ootednesses_
serenenesses12117116ser_e_ne_nesses_
servilenesses1646306serv_ile_nesses_
spiritednesses1753226spir__itednesses_
sveltenesses1545236__svelte_nesses_
temperatenesses19113156temperate_nesses_
uprootednesses1752346upr_ootednesses_
vexednesses2244606___ve_xednesses_

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.313570897.8
2DLD Change Limit65874704.84313601.9
3Display Results70700.0461521.7
 (SQL Overall)178691705.20234350.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.