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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
wrynesses153484(None) 
drynesses1335361drynesses
awaynesses1644272awaynesses
coynesses1437572coynesses
feynesses1535222feynesses
gaynesses1336562gaynesses
graynesses1436142graynesses
greynesses1446322greynesses
shynesses1535312shynesses
slynesses1235862slynesses
sprynesses1544972sprynesses
waenesses1239772waenesses
wannesses1239232wannesses
warinesses131514522warinesses
warmnesses15167352warmnesses
wetnesses12208212wetnesses
wirinesses131811522wirinesses
witnesses12219922witnesses
woenesses1239132woenesses
wornnesses1337132wornnesses
wryness13113982wryne_s_s
airinesses102613613airinesses
aptnesses11168993aptnesses
archnesses1547173archnesses
aridnesses1139933aridnesses
artinesses10815213artinesses
awarenesses1447253awarenesses
badnesses1239253badnesses
barenesses12311703barenesses
baronesses1238913baronesses
bignesses1267963bignesses
busynesses15145503busynesses
cresses94219813cr__esses
curtnesses1238373curtnesses
darknesses1537013darknesses
dimnesses1238213dimnesses
direnesses11311483direnesses
drabnesses1336483drabnesses
dresses83716173dr__esses
dryness11114783dryne_s_s
duenesses1039333duenesses
dulnesses1037763dulnesses
dunnesses1037703dunnesses
dwarfnesses1843293dwarfnesses
eerinesses10612603eerinesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fewnesses1534953fewnesses
finesses111912343_finesses
firmnesses1535613firmnesses
fitnesses12219373fitnesses
freenesses1339873freenesses
fulnesses1239053fulnesses
gorinesses11311553gorinesses
grimnesses13106533grimnesses
hardnesses141810543hardnesses
harnesses121812073harnesses
hipnesses1436753hipnesses
hotnesses1238903hotnesses
icinesses11310073icinesses
illnesses937283illnesses
ironnesses1047833ironnesses
laxnesses1646633laxnesses
lionesses939433lionesses
lornnesses1037823lornnesses
lownesses1236983lownesses
madnesses1239833madnesses
mirinesses121512313mirinesses
morenesses12811393morenesses
nesses64718323___nesses
newnesses1236123newnesses
nownesses1236893nownesses
oddnesses1136353oddnesses
oldnesses1037703oldnesses
onenesses9311823onenesses
oyesses1037333_oy_esses
patnesses111611793patnesses
pertnesses12310313pertnesses
precesses13310463precesses
presses93523153pr__esses
primnesses1497803primnesses
princesses14206263princesses
processes13310233processes
professes1437873professes
prowesses1437193prowesses
purenesses12810743purenesses
rarenesses10313113rarenesses
rawnesses1288123rawnesses
recesses10312323_recesses
rednesses10312313rednesses
sadnesses10310303sadnesses
sorenesses101313493sorenesses
surenesses101212213surenesses
swartnesses1436713swartnesses
synesises1245613_synesises
tartnesses101110713tartnesses
tresses73719543tr__esses
trignesses1188213trignesses
trimnesses1287753trimnesses
truenesses1039313truenesses
tweenesses1345803tweenesses
wardresses1445413wardresses
wavinesses16199283wavinesses
waxinesses20138763waxinesses
weaknesses1735463weaknesses
wearinesses14310213wearinesses
weirdnesses1545213weirdnesses
wellnesses1335783wellnesses
whatnesses1635733whatnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirelesses1345333wirelesses
wisenesses13310823wisenesses
witnessed13214723witnessed
witnesser12224533witnesser
witnessers13173103witnessers
wordinesses15138883wordinesses
worminesses16127993worminesses
wrasses103812593wr__asses
wrongnesses1544923wrongnesses
wrynecks2041293wryne_cks
yesses93615813__y_esses

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411236.11024327.5
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.59627090.8
 
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.