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.

46 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

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.0762351197.4
2DLD Change Limit43548462.14020349.5
3Display Results46460.0331393.9
 (SQL Overall)178691462.24979453.5
 
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.