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

100 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
equitablenesses2610428(None) 
equablenesses2465462equ__ablenesses
equitableness24105422equitablene_s_s
excitablenesses2664522excitablenesses
suitablenesses1655382_suitablenesses
enviablenesses1965863envi_ablenesses
estimablenesses1954043estimablenesses
habitablenesses2254013habitablenesses
irritablenesses1755003irritablenesses
veritablenesses2055033veritablenesses
admirablenesses2074324admirablenesses
advisablenesses21113924advisablenesses
amiablenesses1756504_ami_ablenesses
amicablenesses2055174_amicablenesses
availablenesses2063704availablenesses
culpablenesses2053874_culpablenesses
curablenesses17146954_cu_rablenesses
desirablenesses1855584desirablenesses
durablenesses16156544_du_rablenesses
ediblenesses1545784e_di__blenesses
enjoyablenesses2773514enjoyablenesses
equableness22146094equ__ablene_s_s
excitableness2455364excitablene_s_s
excusablenesses2663964excusablenesses
execrablenesses2674164execrablenesses
immutablenesses2164134immutablenesses
laudablenesses1754274lau_dablenesses
laughablenesses2183114laughablenesses
likablenesses1995414__likablenesses
livablenesses18125804__livablenesses
notablenesses1546614__notablenesses
palatablenesses1973914palatablenesses
pitiablenesses1855034__pitiablenesses
pliablenesses1756044_pli_ablenesses
potablenesses1746464__potablenesses
reliablenesses1655784reli_ablenesses
sizablenesses2445374__sizablenesses
sociablenesses1855084soci_ablenesses
stablenesses1448074___stablenesses
suitableness1456264_suitablene_s_s
tractablenesses1964024tractablenesses
tunablenesses1555814_tu_nablenesses
unstablenesses1656004_unstablenesses
usablenesses1446714__u_sablenesses
variablenesses1965454vari_ablenesses
voidablenesses2054694_voidablenesses
adorablenesses1755415_adorablenesses
agreeablenesses1873345agreeablenesses
brittlenesses1584205_brit_tlenesses
capablenesses1955435__capablenesses
damnablenesses1954595_damnablenesses
doublenesses1546485dou___blenesses
enviableness1756975envi_ablene_s_s
equivalences2672265equiva_len__ces
equivalencies2761465equiva_len_cies
equivocalnesses2971175equivocalnesses
estimableness1754735estimablene_s_s
ethicalnesses1853175ethica_l_nesses
exquisitenesses3162725exqui_sitenesses
favorablenesses2354095favorablenesses
fruitfulnesses2094585fruitful_nesses
futilenesses1547175_fu_t_ilenesses
habitableness2054795habitablene_s_s
honorablenesses2064175honorablenesses
humblenesses1944955_hu__mblenesses
immovablenesses2493785immovablenesses
incapablenesses2184245incapablenesses
ineffablenesses2363995ineffablenesses
invisiblenesses2094185invisiblenesses
irritableness1576115irritablene_s_s
littlenesses1246075__lit_tlenesses
losablenesses1596045__losablenesses
lovablenesses18115815__lovablenesses
memorablenesses2154815memorablenesses
miserablenesses1954645miserablenesses
movablenesses20135625__movablenesses
nimblenesses1655985__ni_mblenesses
peaceablenesses2184305peaceablenesses
provablenesses2154855_provablenesses
readablenesses1755185_readablenesses
removablenesses2264235removablenesses
requisitenesses2463465requi_sitenesses
sensiblenesses1555225sensi__blenesses
separablenesses1954765separablenesses
squarenesses2144935squ__a_renesses
stalenesses11311085___sta_lenesses
subtilenesses1585015_subt_ilenesses
subtlenesses1485245_subt__lenesses
superablenesses1964885superablenesses
teachablenesses2283825teachablenesses
tenablenesses1546625__tenablenesses
terriblenesses1694365terri__blenesses
thinkablenesses2463005thinkablenesses
valuablenesses1954675_valuablenesses
venerablenesses2074785venerablenesses
veritableness1856495veritablene_s_s
violablenesses1984705_violablenesses
visiblenesses1855295__visiblenesses
vitalnesses1456245__vita_l_nesses
workablenesses2354415_workablenesses

Search took 10 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.186960704.3
2DLD Change Limit658741008.9407368.5
3Display Results1001000.233429.2
 (SQL Overall)1786911009.35919093.0
 
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.