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

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

90 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
glaringnesses155339(None) 
daringnesses1464832_daringnesses
glarinesses1239512glari__nesses
glaringness1343262glaringne_s_s
boringnesses15105013_boringnesses
darlingnesses1563043_darlingnesses
garishnesses1645883g_arishnesses
glazinesses2136403glazi__nesses
graininesses1346583gra_ininesses
graspingnesses1852053graspingnesses
lastingnesses1444133_lastingnesses
livingnesses1643653_livingnesses
lovingnesses1643673_lovingnesses
plainnesses1356203pla_in_nesses
pleasingnesses1752833pleasingnesses
amusingnesses1652834amusingnesses
aridnesses1139934__ari_dnesses
bearishnesses1844844bearishnesses
bindingnesses1753274bindingnesses
blandnesses1446624bla__ndnesses
blanknesses1744934bla__nknesses
blearinesses1446544bleari__nesses
blindnesses1446184bl__indnesses
braininesses1446544bra_ininesses
brininesses1338974__brininesses
charinesses1639564chari__nesses
cunningnesses1673244cunningnesses
daringness1244744_daringne_s_s
enduringnesses1662474enduringnesses
exactingnesses2452654exactingnesses
faintnesses1447144_fa_intnesses
feelingnesses1753514feelingnesses
fittingnesses1773404fittingnesses
flakinesses1837074flaki__nesses
fleetingnesses1872804fleetingnesses
floridnesses1654134flori_dnesses
gaminesses13410454g_ami__nesses
gauntnesses1245174g_a_untnesses
genuinenesses1475254genuinenesses
gladnesses1236684gla___dnesses
glariness1038554glari__ne_s_s
glassinesses1255244gla_ssinesses
glegnesses1245074gl___egnesses
glibnesses1344754gl__i_bnesses
gloriousnesses1556884gloriousnesses
gluinesses1138214gl_ui__nesses
gorinesses11311534g_ori__nesses
gracilenesses1655154gracilenesses
grandnesses1348114g__randnesses
grapinesses1438564grapi__nesses
griminesses14167554g__riminesses
grimnesses13106534g__ri_mnesses
guardednesses1653224guardednesses
hoarinesses14310214hoari__nesses
knowingnesses2152174knowingnesses
lacinesses12312104_laci__nesses
lanknesses1437504_la__nknesses
largenesses1247554_lar_genesses
largesses10246274_lar__g_esses
larkinesses1538994_lar_kinesses
lavishnesses1844774_lavishnesses
lazinesses19310144_lazi__nesses
liltingnesses1453574liltingnesses
longnesses1138504_l__ongnesses
lornnesses1037824_lor_n_nesses
luridnesses1246714_luri_dnesses
nothingnesses1752754nothingnesses
obligingnesses1872014obligingnesses
ongoingnesses1583104ongoingnesses
placidnesses1743944placi_dnesses
planenesses1349034pla__nenesses
quaintnesses2143794qua_intnesses
raininesses11310474_ra_ininesses
retiringnesses1552484retiringnesses
scarinesses1339904scari__nesses
slanginesses1346964sla__nginesses
slatinesses11311614slati__nesses
slavishnesses1843674slavishnesses
springinesses16104064_springinesses
sterlingnesses1553144sterlingnesses
stringinesses14124534_stringinesses
tearinesses11311694teari__nesses
teemingnesses1653064teemingnesses
thingnesses1545174__thingnesses
trignesses1188214__tri_gnesses
vainnesses1337344_va_in_nesses
warinesses131514514_wari__nesses
wearinesses14310214weari__nesses
willingnesses1753174willingnesses
wrongnesses1544924__wrongnesses

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 Filter178691950240.1261418182.5
2DLD Change Limit95024907.54612592.6
3Display Results90900.093967.7
 (SQL Overall)178691907.76523012.4
 
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.