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

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

73 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
presentnesses155442(None) 
presentness1345662presentne_s_s
recentnesses1465372_recentnesses
frequentnesses2661423frequentnesses
greennesses1247033gre_en_nesses
perfectnesses2053353perfectnesses
pleasantnesses1661563pleasantnesses
presentees1247923present_e__es
presentences1655693present_ences
prestresses1346723pres__tresses
ancientnesses1553284ancientnesses
apparentnesses18121774apparentnesses
brazennesses2343284brazen_nesses
breezinesses2343944bre_ezinesses
brokennesses1843304broken_nesses
cravennesses1744114craven_nesses
creepinesses1645254cre_epinesses
currentnesses1552994currentnesses
dressinesses1245534dres_sinesses
drivennesses1643834driven_nesses
erectnesses1347474__erectnesses
evennesses1345944__even_nesses
fleetnesses1445484fle_e_tnesses
freenesses1339874fre_e__nesses
freshnesses1746104fres__hnesses
frozennesses2443224frozen_nesses
greatnesses1247794gr__eatnesses
greedinesses1446474gre_edinesses
intentnesses1277124_intentnesses
keennesses1445324_ke_en_nesses
meetnesses1237454_me_e_tnesses
obesenesses1346764obese__nesses
pastnesses12910514p_as__tnesses
peartnesses1338744p_e_artnesses
permanentnesses1961304permanentnesses
pertnesses12310314p___ertnesses
peskinesses1746574p_es_kinesses
piquantnesses2452034piquantnesses
pleasingnesses1752834pleasingnesses
pliantnesses1444454p_liantnesses
preachinesses2043754preachinesses
precisenesses1756284precisenesses
preppinesses1544884pre_ppinesses
presentee11411864present_e__e_
presentence1546394present_ence_
presentenced1754044present_enced
presenters1239864present_e__rs
presentisms1555214present__isms
presentments1654304presentme_nts
prestressed1444704pres__tressed
prettinesses1447544pre_ttinesses
priestesses13104274pr_iest_esses
priestlinesses1652724priestlinesses
primenesses1548994prime__nesses
prissinesses1355974pris_sinesses
profanenesses1853484profanenesses
promptnesses1843634pr_omptnesses
pronenesses1379264pr__onenesses
propernesses1645014prope_rnesses
prosinesses13310864pros__inesses
protectresses1762364protectresses
recentness1245464_recentne_s_s
reedinesses1259564_re_edinesses
resentences1347424_resent_ences
resentfulnesses1883744_resentfulnesses
restresses1049314_res__tresses
resyntheses1752844_resynthe_ses
selectnesses1446114_selectnesses
serenenesses12117114_serenenesses
silentnesses1275444_silentnesses
sweetnesses1445724swe_e_tnesses
tersenesses1149044terse__nesses
unevennesses1544074uneven_nesses

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 Filter178691950240.356501941.0
2DLD Change Limit95024735.91016078.5
3Display Results73730.090811.1
 (SQL Overall)178691736.35628113.8
 
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.