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

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

49 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
interchangeable23161411interchangeable_
interchangeably26141582interchangeabl_y
exchangeable2761525___exchangeable_
interchange17104585interchang____e_
interchanged19103445interchang____ed
interchanger1883465interchang____er
interchangers1972645interchange___rs
interchanges1894265interchang____es
interchannel1752535interchanne__l__
unchangeable2053265un___changeable_
changeable1843966_____changeable_
interchanging2052996interchang___ing
interminable1656896inter_min__able_
interphalangeal21121066interphalangea_l__
merchantable2152026__merchan_table_
rechargeable2051866__re_chargeable_
unchangeably2362756un___changeabl_y
changeably2152997_____changeabl_y
chargeable1843477_____chargeable_
dischargeable2261677__dischargeable_
indeclinable1794847inde_clin__able_
ineffaceable2252427in_e_ffa_ceable_
ineradicable1754287in_er__adicable_
inescapable1753627in_esc_a__pable_
infrangible1753157in_fr__ang_ible_
intangible1354107int____ang_ible_
intangibles1452727int____ang_ibles
integrable1348407inte_____grable_
interannual1154377inter__annua_l__
intercalate13117707interc_a__la_te_
intercalated1596327interc_a__la_ted
intercalates14117267interc_a__la_tes
intercensal1356157interc_en_sa_l__
intercoastal1463987intercoa_sta_l__
interconnected1962277interc_onne_cted
interconverted2062477interc_onve_rted
interdealer1245767inter____dea_ler
interlinearly1663147inter_lin_earl_y
interminably1956437inter_min__abl_y
intermingle1445767inter_ming___le_
intermingled1653457inter_ming___led
intermingles1574397inter_ming___les
interoperable1763577inter__operable_
interpretable1753947inter__pretable_
intractable1557367int_r__a_ctable_
mechanizable3062377__me_chanizable_
understandable1891717understan_dable_
unteachable1845747unteach____able_
untraceable1546857unt_r__a_ceable_

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 Filter178691950240.360496363.9
2DLD Change Limit95024498.59611054.4
3Display Results49490.0431139.5
 (SQL Overall)178691498.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.