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

43 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
tarnishable165218(None) 
perishable1745263per_ishable
punishable1743283_punishable
abolishable1851474abolishable
advisable1544574_advis_able
arbitrable1443534_arbitrable
arousable1145574_arous_able
cashable15159794ca___shable
cherishable2152354cherishable
crushable1645264_cr_ushable
diminishable2061484diminishable
establishable2061384establishable
fishable1637594___fishable
garnishee13185764garnish__ee
harvestable1951864harvestable
parsable12311694par__s_able
perishables1852824per_ishables
publishable2051584publishable
raisable10311644__rais_able
raiseable1147244__raiseable
relishable1544524_relishable
rinsable10310044__rins_able
tannable1039384ta_n__nable
targetable1383874tar_getable
tarnish101611874tarnish____
tarnished13196064tarnish__ed
tarnishes12188894tarnish__es
tarnishing1445154tarnish_ing
tastable101511974ta___stable
terminable1476604termi_nable
tithable1336854t___ithable
torchable1645534tor__chable
trainable1138944t_rai_nable
transaxle1645914tran_s_axle
transshape15134384transsha_pe
triable92515394t_r_i__able
trustable1147124t_r_ustable
turnable1037854turn___able
turntable1144984turn__table
twistable1444274t__wistable
vanquishable2961174vanquishable
variable13310064var_i__able
washable16138044wa___shable

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 Filter1786911488190.420425454.8
2DLD Change Limit148819438.78316944.0
3Display Results43430.0133307.7
 (SQL Overall)178691439.21619389.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.