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

102 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
gemminesses163498(None) 
germinesses1437881germinesses
gumminesses1634931gumminesses
gaminesses13410462g_aminesses
geekinesses1635812geekinesses
gemminess1464642gemmine_s_s
griminesses14167552griminesses
hamminesses1835772hamminesses
seaminesses13310752seaminesses
yumminesses1843872yumminesses
balminesses1537253balminesses
beadinesses1449563beadinesses
beefinesses1675953beefinesses
beerinesses1398923beerinesses
bumpinesses17126373bumpinesses
campinesses1737113campinesses
chumminesses2142863chumminesses
clamminesses1873793clamminesses
comfinesses1846913comfinesses
creaminesses1646133creaminesses
crumminesses1843653crumminesses
demonesses1346703de_monesses
dewinesses1438353de_winesses
dreaminesses1545713dreaminesses
dumpinesses16126253dumpinesses
easinesses10314443_easinesses
edginesses1236703_edginesses
eerinesses10612603_eerinesses
emptinesses1545993_emptinesses
filminesses1636233filminesses
foaminesses1658073foaminesses
gabbinesses1634903gabbinesses
gamenesses1368983g_amenesses
gassinesses1197973gassinesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
gelidnesses1355983gelidnesses
gentilesses1243493gentilesses
germiness1257693germine_s_s
giddinesses1435303giddinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
gloominesses1544123gloominesses
gluinesses1138233g_luinesses
glumnesses1344733glum_nesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
gorinesses11311553g_orinesses
goutinesses1239973goutinesses
grapinesses1438573grapinesses
greasinesses1347043greasinesses
greedinesses1446463greedinesses
grimnesses13106533grim_nesses
grumpinesses1743663grumpinesses
gumminess1454973gummine_s_s
gushinesses15127023gushinesses
gustinesses12139523gustinesses
gutsinesses12128153gutsinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hominesses15510863_hominesses
humpinesses18106243humpinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
jumpinesses22125343jumpinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
liminesses121310853_liminesses
loaminesses1358453loaminesses
lumpinesses15107113lumpinesses
mealinesses13310973mealinesses
meatinesses13311983meatinesses
merrinesses1358263merrinesses
messinesses1297513messinesses
needinesses1258103needinesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
newsinesses1436323newsinesses
peppinesses1435313peppinesses
perkinesses1748923perkinesses
peskinesses1746573peskinesses
pettinesses1338633pettinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
riminesses121211413_riminesses
roominesses1337433roominesses
seedinesses1259203seedinesses
seemlinesses1445223seemlinesses
sexinesses1739213se_xinesses
sliminesses1338093sliminesses
steaminesses1446223steaminesses
tearinesses11311693tearinesses
testinesses111210323testinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wimpinesses1835633wimpinesses
worminesses16127993worminesses

Search took 6 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.423422437.4
2DLD Change Limit1216331025.00024326.6
3Display Results1021020.0631619.0
 (SQL Overall)1786911025.48632572.2
 
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.