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

143 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
heavinesses174745(None) 
headinesses1539841headinesses
beadinesses1449552beadinesses
easinesses10314412_easinesses
hazinesses2239212h_azinesses
heartinesses1547992heartinesses
heaviness15207062heavine_s_s
heftinesses1737132heftinesses
hoarinesses14310212hoarinesses
leafinesses1437872leafinesses
leakinesses1538472leakinesses
mealinesses13310972mealinesses
meatinesses13311972meatinesses
nervinesses1437302nervinesses
readinesses12611262readinesses
seaminesses13310752seaminesses
tearinesses11311692tearinesses
wavinesses16199272_wavinesses
wearinesses14310212wearinesses
avidnesses1436463__avidnesses
beefinesses1675943beefinesses
beerinesses1398903beerinesses
blearinesses1446543blearinesses
bravenesses1647943bravenesses
caginesses13310933_caginesses
cakinesses16310603_cakinesses
charinesses1639563charinesses
cheapnesses18104023chea_pnesses
cheekinesses2164203cheekinesses
cheerinesses1765823cheerinesses
cheesinesses1765373cheesinesses
chewinesses1945143che_winesses
crazinesses2237923crazinesses
creakinesses1845983creakinesses
creaminesses1646123creaminesses
deaconesses1445653deaconesses
deadlinesses1446223deadlinesses
deadnesses1238943dea_dnesses
deafnesses1436223dea_fnesses
dearnesses1139573dea_rnesses
dewinesses1438343de_winesses
dreaminesses1545703dreaminesses
drearinesses1347433drearinesses
earlinesses11311033_earlinesses
edginesses1236683_edginesses
eerinesses10612573_eerinesses
evilnesses1345983_e_vilnesses
fervidnesses1943823fervidnesses
flakinesses1837073flakinesses
foaminesses1658063foaminesses
freakinesses1945583freakinesses
gaminesses13410453_gaminesses
geekinesses1635813geekinesses
gemminesses1634973gemminesses
germinesses1437873germinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
grapinesses1438563grapinesses
gravenesses1548163gravenesses
greasinesses1347033greasinesses
hairinesses14198943hairinesses
halenesses13312033h_alenesses
halfnesses1636263h_alfnesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110213hardinesses
hardnesses141810543h_ardnesses
harnesses121812073h_a_rnesses
hastinesses141210683hastinesses
headdresses1683693headdresses
headiness132510363headine_s_s
healthinesses1942963healthinesses
heavenlinesses2051793heavenlinesses
heiresses1236963he__iresses
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hokinesses1758933h_okinesses
holinesses13511483h_olinesses
hominesses15510843h_ominesses
horninesses1458993horninesses
horsinesses1439533horsinesses
huffinesses2034113huffinesses
humpinesses18106233humpinesses
huskinesses18136523huskinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
lacinesses12312103_lacinesses
lazinesses19310143_lazinesses
leannesses10108343lea_nnesses
leerinesses11119473leerinesses
legginesses1345293legginesses
loaminesses1358443loaminesses
matinesses12314523_matinesses
mazinesses2139903_mazinesses
meannesses12128163mea_nnesses
merrinesses1358253merrinesses
messinesses1297503messinesses
nearnesses1039093nea_rnesses
neatnesses10310003nea_tnesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
newsinesses1436313newsinesses
peartnesses1338713peartnesses
peppinesses1435313peppinesses
perkinesses1748913perkinesses
peskinesses1746563peskinesses
pettinesses1338623pettinesses
quakinesses2436283quakinesses
queasinesses2144133queasinesses
racinesses12313493_racinesses
realnesses10310843rea_lnesses
reedinesses1259553reedinesses
savvinesses1735663savvinesses
scalinesses1339313scalinesses
scarinesses1339903scarinesses
seedinesses1259203seedinesses
sexinesses1739203se_xinesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
slatinesses11311613slatinesses
sleazinesses2145373sleazinesses
snakinesses1538553snakinesses
sneakinesses1645903sneakinesses
soapinesses1339703soapinesses
spacinesses1538093spacinesses
staginesses1238463staginesses
steadinesses1346903steadinesses
steaminesses1446223steaminesses
suavenesses1448393suavenesses
sweatinesses1546903sweatinesses
testinesses111210313testinesses
threadinesses1753333threadinesses
uneasinesses1246623uneasinesses
warinesses131514513_warinesses
waxinesses20138753_waxinesses
weaklinesses1944483weaklinesses
weaknesses1735463wea_knesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wheezinesses2742863wheezinesses
yeastinesses1545563yeastinesses
zaninesses19310373_zaninesses

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.266671770.7
2DLD Change Limit1216331436.45018857.8
3Display Results1431430.1101300.0
 (SQL Overall)1786911436.82626178.0
 
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.