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

150 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
happinesses187616(None) 
hippinesses1845491hippinesses
nappinesses1555921nappinesses
sappinesses1567561sappinesses
campinesses1737112campinesses
choppinesses2143352choppinesses
dippinesses1635242dippinesses
hairinesses14198942hairinesses
hamminesses1835772hamminesses
handinesses151410272handinesses
happiness1636002happine_s_s
hardinesses151110222hardinesses
hastinesses141210692hastinesses
hazinesses2239222ha_zinesses
hippienesses1943442hippienesses
humpinesses18106242humpinesses
lippinesses1535512lippinesses
nippinesses1545062nippinesses
peppinesses1435312peppinesses
raspinesses1338012raspinesses
snappinesses1684322snappinesses
soppinesses1566842soppinesses
unhappinesses2052482unhappinesses
waspinesses1636702waspinesses
achinesses1539303_achinesses
airinesses102613613_airinesses
aptnesses11168993_a_ptnesses
artinesses10815213_artinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
battinesses13169453battinesses
bawdinesses17126323bawdinesses
bumpinesses17126373bumpinesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
canninesses1368853canninesses
cattinesses13129703cattinesses
chancinesses1945033chancinesses
charinesses1639563cha_rinesses
chattinesses1755153chattinesses
daffinesses1834843daffinesses
dailinesses1249493dailinesses
dampnesses1535603damp_nesses
dappernesses1743243dappernesses
dopinesses13159723_dopinesses
dumpinesses16126253dumpinesses
earlinesses11311043earlinesses
easinesses10314443ea_sinesses
emptinesses1545993emptinesses
fancinesses1638143fancinesses
fattinesses14118973fattinesses
floppinesses1942953floppinesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
grapinesses1438573grapinesses
halenesses13312043ha_lenesses
halfnesses1636263ha_lfnesses
hardnesses141810543ha_rdnesses
harnesses121812073ha__rnesses
harshnesses1745853harshnesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
hillinesses1458503hillinesses
hipnesses1436753h_ip_nesses
hippiness1635463hippine_s_s
hoarinesses14310223hoarinesses
hokinesses1758943h_okinesses
holinesses13511493h_olinesses
hominesses15510863h_ominesses
horninesses1459003horninesses
horsinesses1439553horsinesses
huffinesses2034123huffinesses
huskinesses18136533huskinesses
jazzinesses2633373jazzinesses
jumpinesses22125343jumpinesses
lacinesses12312123la_cinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
lazinesses19310153la_zinesses
loopinesses13116733loopinesses
lumpinesses15107113lumpinesses
maltinesses13310233maltinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128693massinesses
matinesses12314543ma_tinesses
mazinesses2139923ma_zinesses
mopinesses14139123_mopinesses
nappiness1335233nappine_s_s
nastinesses111110743nastinesses
nattinesses11119323nattinesses
paperinesses1646053paperinesses
pastinesses13911713pastinesses
pawkinesses2036153pawkinesses
pipinesses1448603_pipinesses
preppinesses1544883preppinesses
pulpinesses1536003pulpinesses
racinesses12313513ra_cinesses
raininesses11310483raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
rapidnesses1476473rapidnesses
raptnesses1248523ra_ptnesses
ropinesses121311023_ropinesses
saltinesses11311453saltinesses
sandinesses12911393sandinesses
sappiness1337443sappine_s_s
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
scrappinesses1952293scrappinesses
shabbinesses1953433shabbinesses
shadinesses1538643sha_dinesses
shagginesses1743963shagginesses
shakinesses1837613sha_kinesses
shapelinesses1843413shapelinesses
sharpnesses1645233sharp_nesses
sloppinesses1644053sloppinesses
soapinesses1339713soapinesses
spacinesses1538103spacinesses
swampinesses1943713swampinesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tanginesses1278883tanginesses
tardinesses121110253tardinesses
tarrinesses11129083tarrinesses
tartinesses111011503tartinesses
tastinesses111110783tastinesses
tattinesses11128943tattinesses
tawninesses1436153tawninesses
tipsinesses1336363tipsinesses
vapidnesses1774893vapidnesses
wackinesses2036653wackinesses
warinesses131514523wa_rinesses
washinesses1737263washinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
weepinesses1646133weepinesses
wimpinesses1835633wimpinesses
wispinesses1636273wispinesses
zaninesses19310383za_ninesses

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.390458182.1
2DLD Change Limit1216331504.26628512.2
3Display Results1501500.0931612.9
 (SQL Overall)1786911504.74937627.1
 
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.