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]

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

55 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

Search took 3 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 Filter178691435480.0802233637.5
2DLD Change Limit43548552.46617659.4
3Display Results55550.0461195.7
 (SQL Overall)178691552.59268939.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.