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

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

65 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
admissibilities2063271admissibilities_
accessibilities2162974accessibilities_
admirabilities1956024admi_rabilities_
admissibility2183084admissibilit___y
advisabilities2055544advi_sabilities_
immiscibilities2363364immiscibilities_
miscibilities1955694__miscibilities_
adjustabilities2563235adjustabilities_
amiabilities16109875a_mi__abilities_
amicabilities19197895a_mi_cabilities_
disabilities15411105_d_i_sabilities_
divisibilities2064055_divisibilities_
impassibilities21184665impassibilities_
impossibilities21174225impossibilities_
invisibilities1956115invi_sibilities_
possibilities1756055__possibilities_
resistibilities1753975resistibilities_
risibilities1448625__ri_sibilities_
visibilities1747375__vi_sibilities_
adaptabilities1955626ad_aptabilities_
admissible1552606admissib_l___e__
adoptabilities1955266ad_optabilities_
adorabilities1647806ad__orabilities_
alienabilities1656206a_lienabilities_
amenabilities1778836a_m_enabilities_
assignabilities1853076assignabilities_
audibilities1546636a___udibilities_
availabilities1955746avai_labilities_
compatibilities2363606compatibilities_
crossabilities1855686_crossabilities_
damageabilities2153366damageabilities_
defeasibilities2153816defeasibilities_
defensibilities2164046defensibilities_
desirabilities1747526_desirabilities_
digestibilities1963286digestibilities_
disposabilities2053546_d_isposabilities_
dissimilarities1871836_d_issimilarities_
dissimilates15125186_d_issimilat_es_
dissimilitudes1871476_d_issimilitudes_
disutilities1355146_d_i_sutilities_
drillabilities1754786_drillabilities_
drinkabilities2155036_drinkabilities_
drivabilities1947246_dri_vabilities_
driveabilities2055166_driveabilities_
edibilities1458706ed____ibilities_
eligibilities1655646_eli_gibilities_
emissivities1752956_emiss__ivities_
expansibilities2693386expansibilities_
extensibilities2493466extensibilities_
feasibilities1866566__feasibilities_
fishabilities2146286__fishabilities_
fissilities1445646__fiss__ilities_
fusibilities1746226___fusibilities_
impassabilities21155246impassabilities_
inadmissibility2392356inadmissibilit___y
infeasibilities2064716infeasibilities_
infusibilities1955456_infusibilities_
insensibilities1764906insensibilities_
invincibilities2293726invincibilities_
irascibilities1854816_irascibilities_
perishabilities2255276perishabilities_
plausibilities1873756_plausibilities_
punishabilities2253176punishabilities_
reversibilities2084156reversibilities_
sensibilities1557366__sensibilities_

Search took 7 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.1701051123.5
2DLD Change Limit65874655.76611424.6
3Display Results65650.0461413.0
 (SQL Overall)178691655.98229871.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.