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

41 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
discoverable2011330(None) 
indiscoverable2291442indiscoverable
undiscoverable2281212undiscoverable
coverable1649103___coverable
discernable1654453disc__ernable
discountable1753853discountable
dishonorable1862193dishonorable
recoverable1853763_recoverable
covetable1648164___covetable
deliverable1753114d_eliverable
disagreeable1662164disagreeable
disavowable2052514dis_avowable
discardable1753464disc_ardable
discernible1653364disc__ernible
discomfortable2471524discomfortable
discourage1454624disco_ura_ge
discover1439564discover____
discovered1765884discover__ed
discoverer1674814discover__er
discoverers1773464discover_ers
discoveries1745804discover_ies
discovering1845364discover_ing
discovers1538154discover___s
discovert1548794discover___t
discovery1845274discover___y
discussable1653554disc_ussable
disenable1249674dis___enable
dishonorably2161704dishonorably
dislikeable1852314dislike_able
disposable1545874dispo__sable
disprovable1953464disprov__able
disseverance1862314disseverance
dissociable1653974disso_ciable
dissolvable1753144disso_lvable
inoperable1448184_i_noperable
intolerable1355434_intolerable
irrecoverable2062184irrecoverable
miserable1349654mis___erable
overable13513574____overable
severable1438544__s_everable
unrecoverable2062394unrecoverable

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 Filter1786911247900.410435831.7
2DLD Change Limit124790417.53016572.4
3Display Results41410.0162562.5
 (SQL Overall)178691417.95622459.9
 
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.