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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
desirablenesses185558(None) 
desirableness1666942desirablene_s_s
admirablenesses2074323admirablenesses
durablenesses16156543d__urablenesses
estimablenesses1954043_estimablenesses
memorablenesses2154813memorablenesses
miserablenesses1954643miserablenesses
reliablenesses1655783reli_ablenesses
separablenesses1954763separablenesses
sizablenesses2445373__sizablenesses
venerablenesses2074783venerablenesses
veritablenesses2055033veritablenesses
adorablenesses1755414_adorablenesses
advisablenesses21113924advisablenesses
amiablenesses1756504_ami_ablenesses
amicablenesses2055174_amicablenesses
availablenesses2063704availablenesses
curablenesses17146954__curablenesses
damnablenesses1954594d_amnablenesses
desirousnesses1456844desir_ousnesses
desolatenesses1553964desola_tenesses
desperatenesses1863724despera_tenesses
despicableness2164114despicablene_s_s
ediblenesses1545784_edi__blenesses
enviablenesses1965864_enviablenesses
equablenesses2465464_e_quablenesses
equitablenesses26104284equitablenesses
excitablenesses2664524excitablenesses
execrablenesses2674164execrablenesses
favorablenesses2354094favorablenesses
habitablenesses2254014habitablenesses
honorablenesses2064174honorablenesses
irritablenesses1755004irritablenesses
likablenesses1995414__likablenesses
livablenesses18125804__livablenesses
losablenesses1596044los__ablenesses
peaceablenesses2184304peaceablenesses
pitiablenesses1855034piti_ablenesses
pliablenesses1756044_pli_ablenesses
readablenesses1755184re_adablenesses
removablenesses2264234removablenesses
sensiblenesses1555224sensi__blenesses
sociablenesses1855084soci_ablenesses
stablenesses1448074__s_tablenesses
suitablenesses1655384_suitablenesses
superablenesses1964884superablenesses
teachablenesses2283824teachablenesses
tenablenesses1546624te__nablenesses
terriblenesses1694364te_rriblenesses
undesirableness18103624undesirablene_s_s
unstablenesses1656004uns_tablenesses
usablenesses1446714_us__ablenesses
variablenesses1965454vari_ablenesses
visiblenesses1855294visi__blenesses
voidablenesses2054694_voidablenesses
admirableness1855135admirablene_s_s
agreeablenesses1873345agreeablenesses
capablenesses1955435__capablenesses
culpablenesses2053875_culpablenesses
dastardlinesses1761835dastardlinesses
deadlinesses1446225de___adlinesses
decisivenesses2056725deci_sivenesses
definitenesses1864225defi_nitenesses
deliriousnesses1656025deliriousnesses
demurenesses1544745demur___enesses
deplorableness1963665deplorablene_s_s
depravednesses2152365de_pravednesses
derisivenesses1857185deri_sivenesses
deservednesses19163455deser_vednesses
desirables1344215desirabl_____es
destitutenesses1662655destitutenesses
detailednesses1653185de__tailednesses
direnesses11311485d__ir___enesses
discretenesses1753365discr_etenesses
dismalnesses1553975dis_ma_l_nesses
disparatenesses18122885disparatenesses
doublenesses1546485d___oublenesses
drabnesses1336485d___rab__nesses
durableness1446705d__urablene_s_s
enjoyablenesses2773515enjoyablenesses
estimableness1754735_estimablene_s_s
excusablenesses2663965excusablenesses
feeblenesses1745525fe___eblenesses
femalenesses1746845fe__ma_lenesses
fertilenesses1648005fe__rtilenesses
horriblenesses1953885_horriblenesses
immovablenesses2493785immovablenesses
immutablenesses2164135immutablenesses
incapablenesses2184245incapablenesses
ineffablenesses2363995ineffablenesses
insolublenesses1763425insolublenesses
invisiblenesses2094185invisiblenesses
iratenesses11411405___ira_tenesses
laudablenesses1754275_laudablenesses
laughablenesses2183115laughablenesses
lovablenesses18115815__lovablenesses
memorableness1955635memorablene_s_s
miserableness17145755miserablene_s_s
movablenesses20135625__movablenesses
neutralnesses1354335neutra_l_nesses
nimblenesses1655985__ni_mblenesses
notablenesses1546615__notablenesses
palatablenesses1973915palatablenesses
potablenesses1746465__potablenesses
provablenesses2154855_provablenesses
reliableness1457125reli_ablene_s_s
resistivenesses1755745resistivenesses
separableness1755675separablene_s_s
separatenesses1654255separa_tenesses
servilenesses1646265__servilenesses
simplenesses1645615__si_mplenesses
singlenesses1346095__si_nglenesses
sizableness2265585__sizablene_s_s
stalenesses11311085__s_ta_lenesses
strangenesses1454955__strangenesses
thinkablenesses2463005thinkablenesses
tractablenesses1964025tractablenesses
tunablenesses1555815__tunablenesses
valuablenesses1954675_valuablenesses
venerableness1856015venerablene_s_s
venialnesses1555685veni_a_l_nesses
veritableness1856495veritablene_s_s
violablenesses1984705_violablenesses
workablenesses2354415_workablenesses

Search took 6 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 Filter178691658740.0931921408.6
2DLD Change Limit658741245.53311905.7
3Display Results1241240.0931333.3
 (SQL Overall)1786911245.71931245.1
 
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.