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 “applaudable” 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
applaudable185179(None) 
applaudably2161301applaudably
appealable1643853appea_lable
appeasable1644593appea_sable
appliable1545053appl__iable
applicable1844373appl_icable
illaudable13132713_illaudable
laudable1137893___laudable
abradable1495064a_bra_dable
alarmable1345014a__larmable
applaud1293904applaud____
applauded1542174applaud__ed
applauder1442364applaud__er
applauders1542124applaud_ers
applauding1642104applaud_ing
applauds13103284applaud___s
applause1243664applau___se
apposable1545604app__osable
appreciable1953844appreciable
approachable2362254approachable
approvable1963934app_rovable
awardable1543954a__wardable
excludable2252544excl_udable
expandable2243124exp_andable
explainable2252524explainable
illaudably16132274_illaudably
implacable1844614impla_cable
implantable1753334implantable
implausible1752574implausible
includable1545014incl_udable
laudably1445124___laudably
palatable1346384_pala_table
placable14169244__pla_cable
placeable1536914__placeable
plantable1337274__plantable
plausible1343804__plausible
playable15137924__pla_yable
pleadable1445514__pleadable
replaceable1743224replaceable
spreadable1544424sprea_dable
unplausible1552024unplausible
unplayable1745314unpla_yable
upgradable1652804upgra_dable

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.436409841.7
2DLD Change Limit148819439.36015899.5
3Display Results43430.0331303.0
 (SQL Overall)178691439.82918180.0
 
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.