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

116 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
gumminesses163493(None) 
gemminesses1634981gemminesses
yumminesses1843871yumminesses
bumpinesses17126372bumpinesses
chumminesses2142862chumminesses
crumminesses1843652crumminesses
dumpinesses16126252dumpinesses
gaminesses13410462g_aminesses
germinesses1437882germinesses
griminesses14167572griminesses
grumpinesses1743672grumpinesses
gumminess1454972gummine_s_s
gushinesses15127032gushinesses
gustinesses12139532gustinesses
gutsinesses12128162gutsinesses
hamminesses1835772hamminesses
humpinesses18106242humpinesses
jumpinesses22125342jumpinesses
lumpinesses15107112lumpinesses
balminesses1537253balminesses
bugginesses1545373bugginesses
bulginesses1466133bulginesses
bulkinesses1786483bulkinesses
burlinesses1338403burlinesses
bushinesses16107473bushinesses
businesses121411393bu_sinesses
bustinesses131310103bustinesses
campinesses1737113campinesses
clamminesses1873793clamminesses
clumsinesses1644773clumsinesses
comfinesses1846913comfinesses
curlinesses1338733curlinesses
cushinesses16127413cushinesses
dumbnesses1584603du_mbnesses
duskinesses16136843duskinesses
dustinesses121110353dustinesses
filminesses1636243filminesses
foaminesses1658073foaminesses
funkinesses18137003funkinesses
funninesses14106873funninesses
furrinesses1437193furrinesses
fussinesses13126943fussinesses
fustinesses14129783fustinesses
fuzzinesses2243723fuzzinesses
gabbinesses1634913gabbinesses
gamenesses1368983g_amenesses
gassinesses1197983gassinesses
gaudinesses1337863gaudinesses
gauzinesses2136053gauzinesses
gawkinesses1935633gawkinesses
geekinesses1635813geekinesses
gemminess1464643gemmine_s_s
giddinesses1435313giddinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
gloominesses1544123gloominesses
gluinesses1138243g_luinesses
glumnesses1344733glum_nesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
gorinesses11311553g_orinesses
goutinesses1239983goutinesses
grapinesses1438583grapinesses
grimnesses13106543grim_nesses
grubbinesses1743303grubbinesses
guiltinesses1345123guiltinesses
hominesses15510873_hominesses
huffinesses2034123huffinesses
humannesses1643863humannesses
humidnesses1744583humidnesses
huskinesses18136533huskinesses
juicinesses2035893juicinesses
liminesses121310853_liminesses
loaminesses1358453loaminesses
luckinesses1746653luckinesses
luminesces1443963lu_minesces
lustinesses11910423lustinesses
muddinesses1535273muddinesses
mugginesses1544923mugginesses
murkinesses17136783murkinesses
mushinesses16127323mushinesses
muskinesses17127043muskinesses
mussinesses12147443mussinesses
mustinesses131010413mustinesses
muzzinesses2133653muzzinesses
nubbinesses1544293nubbinesses
numbnesses1474693nu_mbnesses
nuttinesses11117753nuttinesses
pudginesses1545053pudginesses
puffinesses1934513puffinesses
pugginesses1545253pugginesses
pulpinesses1536003pulpinesses
puninesses121110753pu_ninesses
punkinesses17127223punkinesses
pursinesses1338763pursinesses
pushinesses1697333pushinesses
quakinesses2436323quakinesses
riminesses121211423_riminesses
roominesses1337433roominesses
ruddinesses1336033ruddinesses
runninesses11137693runninesses
runtinesses111210963runtinesses
rustinesses11911563rustinesses
ruttinesses11128993ruttinesses
seaminesses13310753seaminesses
sliminesses1338093sliminesses
sulkinesses1557723sulkinesses
sunninesses11148383sunninesses
surlinesses11310053surlinesses
tubbinesses1544383tubbinesses
tumidnesses1444613tumidnesses
uglinesses1138543_uglinesses
wimpinesses1835633wimpinesses
worminesses16127993worminesses
yuckinesses2044763yuckinesses
yumminess1653643yummine_s_s

Search took 5 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.406440125.6
2DLD Change Limit1216331164.42327500.1
3Display Results1161160.0631841.3
 (SQL Overall)1786911164.89236527.2
 
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.