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

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

64 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
erectness114612(None) 
directness1344192directness
electress1146122electress
erecters102611612erect_ers
erectnesses1347472erectnesses
exactness1843622exactness
greatness1036902greatness
perfectness1853502perfectness
selectness1245452selectness
abjectness2152183abjectness
adeptness1273953adeptness
alertness946053alertness
archness1337513ar_chness
bractless1335543bractless
correctness1553813correctness
crestless1146783crestless
deftness1236303_deftness
directress1343103directress
earnestness1152813earnestness
earwitness1342623earwitness
eeriness8311873e_eriness
electees10238723elect_ees
electrets1146553electrets
erected103213993erect_e_d
erecter93113393erect_e_r
erections112515213erections
erectors103514263erect_ors
erects84116183erect___s
evenness1135543eve_nness
eventless1244603eventless
expertness1944823expertness
eyedness1245103eye_dness
eyewitness1641473eyewitness
fleetness1244753fleetness
freeness11710443fre_eness
freshness1545943freshness
fretless1138063fre_tless
greenness1046793greenness
greyness1235243gre_yness
ineptness1145083ineptness
inertness947973inertness
meetness1036653_meetness
neatness839153_neatness
overtness1238223overtness
pertness10310093_pertness
precess11310863prec__ess
prestress1138133prestress
prettiness1257393prettiness
raciness102413453_raciness
raptness1046733_raptness
realness8410443_realness
recanes93222263_recane_s
recentness1245463recentness
recess8314263_rec__ess
reckless14257973_reckless
redness82012443_re_dness
reediness10239613reediness
restless82713163_restless
restress82511773_restress
richness1337433_richness
sereneness1047133sereneness
strictness1245643strictness
sweetness1245683sweetness
wetness10277723_we_tness

Search took 9 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.436409841.7
2DLD Change Limit148641647.92318760.7
3Display Results64640.0302133.3
 (SQL Overall)178691648.38921300.6
 
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.