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
gemminesses163497(None) 
germinesses1437871germinesses
gumminesses1634921gumminesses
gaminesses13410452g_aminesses
geekinesses1635812geekinesses
gemminess1464622gemmine_s_s
griminesses14167552griminesses
hamminesses1835772hamminesses
seaminesses13310752seaminesses
yumminesses1843862yumminesses
balminesses1537243balminesses
beadinesses1449553beadinesses
beefinesses1675943beefinesses
beerinesses1398903beerinesses
bumpinesses17126363bumpinesses
campinesses1737113campinesses
chumminesses2142863chumminesses
clamminesses1873793clamminesses
comfinesses1846903comfinesses
creaminesses1646123creaminesses
crumminesses1843653crumminesses
demonesses1346703de_monesses
dewinesses1438343de_winesses
dreaminesses1545703dreaminesses
dumpinesses16126243dumpinesses
easinesses10314413_easinesses
edginesses1236683_edginesses
eerinesses10612573_eerinesses
emptinesses1545983_emptinesses
filminesses1636233filminesses
foaminesses1658063foaminesses
gabbinesses1634903gabbinesses
gamenesses1368983g_amenesses
gassinesses1197963gassinesses
gaudinesses1337843gaudinesses
gauzinesses2136033gauzinesses
gawkinesses1935633gawkinesses
gelidnesses1355983gelidnesses
gentilesses1243493gentilesses
germiness1257693germine_s_s
giddinesses1435303giddinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
gloominesses1544123gloominesses
gluinesses1138213g_luinesses
glumnesses1344733glum_nesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
gorinesses11311533g_orinesses
goutinesses1239953goutinesses
grapinesses1438563grapinesses
greasinesses1347033greasinesses
greedinesses1446453greedinesses
grimnesses13106533grim_nesses
grumpinesses1743663grumpinesses
gumminess1454963gummine_s_s
gushinesses15127013gushinesses
gustinesses12139503gustinesses
gutsinesses12128133gutsinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hominesses15510843_hominesses
humpinesses18106233humpinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
jumpinesses22125333jumpinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119473leerinesses
legginesses1345293legginesses
liminesses121310843_liminesses
loaminesses1358443loaminesses
lumpinesses15107103lumpinesses
mealinesses13310973mealinesses
meatinesses13311973meatinesses
merrinesses1358253merrinesses
messinesses1297503messinesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
nervinesses1437303nervinesses
newsinesses1436313newsinesses
peppinesses1435313peppinesses
perkinesses1748913perkinesses
peskinesses1746563peskinesses
pettinesses1338623pettinesses
readinesses12611263readinesses
reedinesses1259553reedinesses
riminesses121211403_riminesses
roominesses1337423roominesses
seedinesses1259203seedinesses
seemlinesses1445223seemlinesses
sexinesses1739203se_xinesses
sliminesses1338093sliminesses
steaminesses1446223steaminesses
tearinesses11311693tearinesses
testinesses111210313testinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wimpinesses1835633wimpinesses
worminesses16127983worminesses

Search took 8 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.280638182.1
2DLD Change Limit1216331026.97017450.9
3Display Results1021020.0631619.0
 (SQL Overall)1786911027.31324434.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.