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

56 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
gooeynesses154419(None) 
dopeynesses1744022dopeynesses
glueynesses1543702glueynesses
gonenesses11310252gone_nesses
goodnesses1236432goo_dnesses
gooeyness1343542gooeyne_s_s
goofinesses1535962goofinesses
governesses1546722governesses
greynesses1446322g_reynesses
hokeynesses2193712hokeynesses
homeynesses1984812homeynesses
boozinesses22175803boozinesses
cageynesses1743873cageynesses
coolnesses1237193coo_lnesses
coynesses1437573_co_ynesses
donenesses11310563done_nesses
feynesses1535223__feynesses
gamenesses1368983game_nesses
gaynesses1336563g__aynesses
glegnesses1245073g_legnesses
gloominesses1544123gloominesses
godlinesses1337123godlinesses
goldennesses1443793goldennesses
gorinesses11311553g_orinesses
goutinesses1239973goutinesses
graynesses1436143g_raynesses
greennesses1247033greennesses
grossnesses1146713grossnesses
hoodednesses1744493hoodednesses
kookinesses1435373kookinesses
lonenesses10311343lone_nesses
looninesses1197993looninesses
loopinesses13116733loopinesses
loosenesses1147243loosenesses
mateynesses1645173mateynesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mootnesses1237153moo_tnesses
morenesses12811393more_nesses
notednesses1247793notednesses
onenesses9311823_one_nesses
oozinesses19178023_oozinesses
opennesses1246313_opennesses
poornesses1236803poo_rnesses
roominesses1337433roominesses
rootednesses1345333rootednesses
rootinesses1139523rootinesses
sobernesses1346593sobernesses
solenesses10412703sole_nesses
sootinesses11410053sootinesses
sorenesses101313493sore_nesses
woenesses1239133_woe_nesses
woodennesses1643653woodennesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses

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 Filter1786911216330.576310227.4
2DLD Change Limit121633566.12619855.2
3Display Results56560.063888.9
 (SQL Overall)178691566.76526414.0
 
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.