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 “glossiness” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
glossiness1128499(None) 
glassiness11246001glassiness
bossiness11257422_bossiness
classiness12196312classiness
gassiness10268322g_assiness
glassines10278042glassine_s
gloominess1343832gloominess
glossies93311252glossi_e_s
glossiest10277942glossi_est
glossinas10214142glossin_as
glossinesses1254502glossinesses
grossness1045972gross_ness
lousiness9219042_lousiness
mossiness11258322_mossiness
bloodiness1344353bloodiness
blowiness1435623blo_winess
boskiness15196513_boskiness
brassiness1235493brassiness
closeness1137613clo_seness
cloudiness1344113cloudiness
clumsiness1444333clumsiness
cosiness103214283_co_siness
crossness1137093cross_ness
dressiness1145553dressiness
drowsiness1443653drowsiness
flashiness16105283flashiness
fleshiness16104293fleshiness
flimsiness1543463flimsiness
floppiness1742873floppiness
flossies112810123flossi_e_s
flossiest12296803flossi_est
folksiness1743573folksiness
frostiness1336573frostiness
fussiness12226583_fussiness
ghostliness1542563ghostliness
glariness1038553gl_ariness
glassies94012273glassi_e_s
glassiest10279253glassi_est
glassine9329313glassine__
glassinesses1255253glassinesses
glassless1043873glass_less
glaziness1935753gl_aziness
glossemes1243783glosseme_s
glossers9319053gloss__ers
glosses84014123gloss__e_s
glossier9358203glossi_e_r
glossina9275543glossin__a
glossing10278883glossin__g
glossitis10143593glossi_tis
glossitises1253073glossitises
gluiness937373gl__uiness
godliness1136593g_odliness
goofiness1365603g_oofiness
goriness9310753g_o_riness
gossipers1263543g_ossipers
goutiness1038773g_outiness
greasiness1156563greasiness
grisliness1155163grisliness
grogginess1343423grogginess
growliness1494083growliness
gushiness13206863g_ushiness
gustiness10189903g_ustiness
gutsiness10226973g_utsiness
horsiness12259483_horsiness
loaminess1137493_loaminess
loftiness1236573_loftiness
loginess9310163_lo_giness
looniness9137573_looniness
loopiness11136543_loopiness
looseness937483_looseness
lossless835473_loss_less
lostness837683_lo_stness
lowliness1236403_lowliness
lustiness92010453_lustiness
massiness112810143_massiness
messiness11248223_messiness
mousiness11219033_mousiness
mussiness11238303_mussiness
noisiness948353_noisiness
nosiness83211393_no_siness
plushiness1544093plushiness
prissiness1266153prissiness
prosiness11311693pro_siness
rosiness82613183_ro_siness
sassiness8249333_sassiness
sissiness8217973_sissiness
sloppiness1443753sloppiness
slushiness1344643slushiness

Search took 7 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 Filter1786911406030.436409841.7
2DLD Change Limit140603885.94023670.5
3Display Results88880.0461913.0
 (SQL Overall)178691886.42227824.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.