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

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

94 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
discreetnesses176243(None) 
discretenesses1753381discretenesses
discreetness1553032discreetne_s_s
directnesses1595283di__rectnesses
discreteness1554483discretene_s_s
concretenesses1854164concretenesses
deservednesses19163484deservednesses
differentnesses2271764differentnesses
directresses15123084di__rectresses
direnesses11311484di__r_e_nesses
discreetest1453914discreet_e_s_t
disparatenesses18122884disparatenesses
distantnesses1453834dis_tantnesses
distinctnesses1752564distinctnesses
diversenesses1754104diverse_nesses
indiscreetness1771424indiscreetne_s_s
screwinesses1744744__screwinesses
sincerenesses1554734sincere_nesses
sweetnesses1445724__s_weetnesses
abstractnesses1862295abstractnesses
ancientnesses1553285_ancientnesses
apparentnesses18121775apparentnesses
assurednesses1352615assur_ednesses
austerenesses1354175austere_nesses
bizarrenesses2452005bizarre_nesses
correctnesses1754215_correctnesses
creepinesses1645255___creepinesses
cruelnesses1346255___cruelnesses
currentnesses1552995_currentnesses
decidednesses1853895d_ecidednesses
deepnesses1366675d____eepnesses
deftnesses1436815d____eftnesses
demurenesses1544755demur_e_nesses
desirousnesses1456865desirousnesses
desolatenesses1553975desolatenesses
desperatenesses1863745desperatenesses
diffusenesses2052825diffuse_nesses
dilutenesses1346115di_lute_nesses
directednesses1863385directednesses
directness1344195di__rectne_s_s
dirtinesses1239885di__r_tinesses
discourtesies1672265discourt_esies
discreeter1344735discreet____er
discrepancies2061775discrepan_cies
dismalnesses1553985dis__malnesses
dissolutenesses1561995dissolutenesses
distresses1148855dis____tresses
dividednesses1952925di_vidednesses
erectnesses1347475___erectnesses
ficklenesses2144155fi_ckle_nesses
fiercenesses1744315fi_erce_nesses
firstnesses1445735fi__r_stnesses
fleetnesses1445485___fleetnesses
freenesses1339875___free_nesses
greatnesses1247795___greatnesses
greennesses1247035___greennesses
incorrectnesses1961665_incorrectnesses
indirectnesses1762165indirectnesses
ineptnesses1396385_i__neptnesses
inertnesses1198725_i__nertnesses
intentnesses1277125_i_ntentnesses
iratenesses11411445_i__ratenesses
leisurelinesses1581045leisurelinesses
licitnesses1346415li_c__itnesses
lissomenesses1453475lissome_nesses
listlessnesses1266935listlessnesses
literatenesses1464785literatenesses
meetnesses1237455____meetnesses
miserlinesses1554665miser_linesses
nicenesses12310355ni_c__e_nesses
obscurenesses1752735obscure_nesses
obsoletenesses1662225obsoletenesses
recentnesses1465375_rec_entnesses
reservednesses18163325reservednesses
sacrednesses1544875_sacr_ednesses
scantnesses1376535__sc_antnesses
scarcenesses1644495__scarce_nesses
selectnesses1446115__selectnesses
serenenesses12117115__serenenesses
sheernesses1445845__s_heernesses
shrewdnesses1942935__shrewdnesses
silentnesses1275445__silentnesses
sleeknesses1545275__s_leeknesses
sorenesses101313495__sor_e_nesses
steepnesses1345925__s_teepnesses
straitnesses1246215__straitnesses
strictnesses1445415__strictnesses
surenesses101212215__sur_e_nesses
tirednesses1247745ti__r_ednesses
viscountesses1851805viscount_esses
viscousnesses1786005visc_ousnesses
visiblenesses1855325visible_nesses
wickednesses2243275wi_c_kednesses
wisenesses13310825wis___e_nesses

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 Filter178691950240.360496363.9
2DLD Change Limit95024945.97015916.9
3Display Results94940.0631492.1
 (SQL Overall)178691946.39327951.0
 
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.