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

141 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
hamminesses183577(None) 
balminesses1537252balminesses
campinesses1737112campinesses
chumminesses2142862chumminesses
clamminesses1873792clamminesses
gaminesses13410462ga_minesses
gemminesses1634972gemminesses
gumminesses1634932gumminesses
hairinesses14198942hairinesses
hamminess1635712hammine_s_s
handinesses151410272handinesses
happinesses1876162happinesses
hardinesses151110212hardinesses
hastinesses141210692hastinesses
hazinesses2239222ha_zinesses
hominesses15510862h_ominesses
humpinesses18106242humpinesses
yumminesses1843872yumminesses
achinesses1539303_achinesses
airinesses102613613_airinesses
artinesses10815213_artinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
bandinesses14109733bandinesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
bumpinesses17126373bumpinesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
calmnesses1436843calm_nesses
canninesses1368853canninesses
cattinesses13129703cattinesses
chancinesses1945033chancinesses
charinesses1639563cha_rinesses
chattinesses1755153chattinesses
comfinesses1846913comfinesses
crumminesses1843653crumminesses
daffinesses1834843daffinesses
dailinesses1249493dailinesses
dampnesses1535603da_mpnesses
dumpinesses16126253dumpinesses
earlinesses11311043earlinesses
easinesses10314443ea_sinesses
fancinesses1638143fancinesses
fattinesses14118973fattinesses
filminesses1636233filminesses
foaminesses1658073foaminesses
gabbinesses1634903gabbinesses
gamenesses1368983ga_menesses
gassinesses1197973gassinesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
germinesses1437883germinesses
griminesses14167553griminesses
halenesses13312043ha_lenesses
halfnesses1636263ha_lfnesses
hardnesses141810543ha_rdnesses
harnesses121812073ha__rnesses
harshnesses1745853harshnesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hoarinesses14310223hoarinesses
hokinesses1758943h_okinesses
holinesses13511493h_olinesses
homelinesses1765363homelinesses
homeynesses1984813homeynesses
horninesses1459003horninesses
horsinesses1439553horsinesses
huffinesses2034123huffinesses
humannesses1643863humannesses
humidnesses1744583humidnesses
huskinesses18136533huskinesses
jazzinesses2633373jazzinesses
jumpinesses22125343jumpinesses
lacinesses12312123la_cinesses
lamenesses12610563la_menesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
liminesses121310853_liminesses
loaminesses1358453loaminesses
lumpinesses15107113lumpinesses
maltinesses13310233maltinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
nappinesses1555923nappinesses
nastinesses111110743nastinesses
nattinesses11119323nattinesses
pastinesses13911713pastinesses
pawkinesses2036153pawkinesses
racinesses12313513ra_cinesses
raininesses11310483raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
raspinesses1338013raspinesses
riminesses121211413_riminesses
roominesses1337433roominesses
saltinesses11311453saltinesses
samenesses12410853sa_menesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
seaminesses13310753seaminesses
shabbinesses1953433shabbinesses
shadinesses1538643sha_dinesses
shagginesses1743963shagginesses
shakinesses1837613sha_kinesses
sliminesses1338093sliminesses
smarminesses1645103smarminesses
swampinesses1943713swampinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tamenesses1259973ta_menesses
tanginesses1278883tanginesses
tardinesses121110243tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503tartinesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawninesses1436153tawninesses
wackinesses2036653wackinesses
warinesses131514523wa_rinesses
warmnesses15167353warm_nesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
wimpinesses1835633wimpinesses
worminesses16127993worminesses
zaninesses19310383za_ninesses

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.1401276364.3
2DLD Change Limit1216331415.59321747.4
3Display Results1411410.0801762.5
 (SQL Overall)1786911415.81330739.9
 
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.