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

69 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
agreeabilities175534(None) 
agreeability1855143agreeabilit__y
alienabilities1656203alienabilities
alterabilities1667333alterabilities
amenabilities1778833a_menabilities
arabilities13413093a_r__abilities
forgeabilities2054723forgeabilities
permeabilities2056823permeabilities
acceptabilities2354224acceptabilities
actabilities1649984a__ctabilities
adaptabilities1955624adaptabilities
admirabilities1956024admirabilities
adoptabilities1955264adoptabilities
adorabilities1647804a_dorabilities
advisabilities2055544advisabilities
affabilities2046944a__ffabilities
affectabilities2553984affectabilities
amiabilities16109874a__miabilities
amicabilities19197894a_micabilities
appealabilities2163884appealabilities
assumabilities1853974assumabilities
availabilities1955744availabilities
credibilities1856064_credibilities
curabilities1649384cur__abilities
damageabilities2153364damageabilities
drapabilities1847104_drapabilities
drapeabilities1955984drapeabilities
drivabilities1947244_drivabilities
driveabilities2055164driveabilities
durabilities1549334dur__abilities
dyeabilities1847864__dyeabilities
erasabilities1549604_erasabilities
formabilities2046994for_mabilities
friabilities1789154_fr_iabilities
gracilities1447674_gr__acilities
heritabilities1958194heritabilities
ignitabilities17106304ignitabilities
irritabilities1647294irritabilities
liveabilities1846754_liveabilities
malleabilities1874974malleabilities
manageabilities2053514manageabilities
marketabilities2353734marketabilities
openabilities1748614_openabilities
operabilities17510054_operabilities
portabilities17410184por_tabilities
preferabilities2254604_preferabilities
pregnabilities1956544_pregnabilities
probabilities1958074_probabilities
readabilities1649304__readabilities
reliabilities15410444__reliabilities
renewabilities1956204renewabilities
rentabilities15411234__rentabilities
reusabilities1549264__reusabilities
severabilities1947434severabilities
sewabilities1748934__sewabilities
shareabilities1955214shareabilities
sorbabilities1746994sor_babilities
spreadabilities2054004spreadabilities
squeezabilities3562304squeezabilities
tenabilities14911484__tenabilities
tolerabilities16116604tolerabilities
traceabilities1855864traceabilities
treatabilities1657604_treatabilities
unreliabilities1754784unreliabilities
untenabilities1656994untenabilities
upgradabilities2162464upgradabilities
variabilities1848634var_iabilities
venerabilities1967354venerabilities
workabilities2245674wor_kabilities

Search took 4 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.1101624463.6
2DLD Change Limit65874693.81017289.8
3Display Results69690.0501380.0
 (SQL Overall)178691693.97045010.3
 
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.