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

57 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
fashionability257194(None) 
fissionability2261832fissionability
assignability1962863_assignability
fashionably22122523fashionab_l__y
machinability2573903machi_nability
alienability1745684_a_lienability
falsifiability2591734falsifiability
fashionable19123104fashionab_l__e
fashionables20111964fashionab_l_es
fatigability2154984fa_ti_gability
fishability2245274fish___ability
machineability26132494machineability
reasonability1854784reas__onability
washability2245304wash___ability
admirability2055685_admi_rability
adorability1746875_a__dorability
advisability2155045_advi_sability
amenability1847465_a__menability
amiability1748695_a_mi__ability
amicability2047285_a_mi_cability
assimilability2162465_assimilability
assumability1954015_as_sumability
attainability18103975_attainability
availability2055475_avai_lability
castability1848395cas___tability
desirability1847255des_i_rability
detonability1856145__detonability
disposability2163555dis_posability
fallibility1953885falli___bility
fashionista1761915fashion__i_sta
feasibility1945935feas_i___bility
fictionality2054615fictiona__lity
formidability2463965formi_dability
friability1847885f__ri__ability
fusibility1845705fus_i___bility
germinability2155045germi_nability
habitability2255085ha_bi_tability
inability14411085____i_nability
inalienability1954535inalienability
inviolability2155095_inviolability
justiciability2861945justiciability
justifiability2961605justifiability
mailability1847285ma__i_lability
nationality14147925na_tiona__lity
navigability2155425na_vi_gability
obtainability2053555obtai_nability
rationality1458075ra_tiona__lity
shareability2054915__shareability
stainability1755665__stainability
suitability1647115__sui_tability
sustainability1962335sustainability
trainability1746825_trai_nability
unfashionably2482195unfashionab_l__y
unsuitability1865125unsui_tability
unthinkability2662345unthinkability
variability1947505va_ri__ability
violability1946265___violability

Search took 8 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 Filter178691950240.1231452772.4
2DLD Change Limit95024576.98613602.1
3Display Results57570.0461239.1
 (SQL Overall)178691577.15524974.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.