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

82 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
glibnesses134476(None) 
gelidnesses1355982gelidnesses
gladnesses1236682gladnesses
glegnesses1245072glegnesses
glibness1134142glibne_s_s
gluinesses1138242gluinesses
glumnesses1344732glumnesses
grimnesses13106542grimnesses
lionesses939432_lionesses
slimnesses1236422slimnesses
uglinesses1138542ugli_nesses
acidnesses1337253acidnesses
agilenesses1247783agilenesses
algidnesses1345163algidnesses
aliennesses1145863aliennesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
aridnesses1139943aridnesses
avidnesses1436463avidnesses
bignesses1267963_bignesses
blindnesses1446183blindnesses
bluenesses1237933bluenesses
chicnesses1745213chicnesses
dimnesses1238213_dimnesses
drabnesses1336483drabnesses
dumbnesses1584603dumbnesses
evilnesses1346003evilnesses
fairnesses1357383fairnesses
finesses111912343_fi_nesses
fitnesses12219373_fitnesses
flatnesses1337763flatnesses
fluidnesses1545483fluidnesses
gabbinesses1634913gabbinesses
gamenesses1368983gamenesses
gaminesses13410463gaminesses
gastnesses11129143gastnesses
gaynesses1336563g_aynesses
giantesses1143513g_iantesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
glueynesses1543703glueynesses
godlinesses1337123godli_nesses
gonenesses11310253gonenesses
goodnesses1236433goodnesses
gorinesses11311553gorinesses
graynesses1436143graynesses
greynesses1446323greynesses
griminesses14167573griminesses
hipnesses1436753_hipnesses
holinesses13511493holi_nesses
icinesses11310073ici_nesses
illnesses937283il_lnesses
laxnesses1646633_laxnesses
likenesses1449533_likenesses
liminesses121310853_liminesses
limpnesses14116653_limpnesses
litenesses10513023_litenesses
livenesses13411073_livenesses
lownesses1236983_lownesses
mildnesses1397393mildnesses
numbnesses1474693numbnesses
oilinesses101512443oilinesses
oldnesses1037703ol_dnesses
plainnesses1356203plainnesses
plumbnesses1753073plumbnesses
primnesses1497803primnesses
slicknesses1745193slicknesses
sliminesses1338093sliminesses
slownesses1344943slownesses
slynesses1235863sl_ynesses
snubnesses1245403snubnesses
solidnesses1238103solidnesses
thinnesses1346273thinnesses
trignesses1188213trignesses
trimnesses1287753trimnesses
vainnesses1337343vainnesses
validnesses1576023validnesses
vilenesses13310223vilenesses
voidnesses1436843voidnesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
witnesses12219923_witnesses

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.406440125.6
2DLD Change Limit140603826.34322166.6
3Display Results82820.0461782.6
 (SQL Overall)178691826.79526297.4
 
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.