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

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

59 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
incapable154756(None) 
incapably1845551incapably
uncapable1547781uncapable
capable13313362__capable
escapable1544982escapable
inarable10313132in_arable
incitable13310432incitable
inculpable1645212inculpable
incunable13108742incunable
incurable131010772incurable
inescapable1753612inescapable
capabler1435353__capabler
capably1639253__capably
decayable1745623decayable
drapable1377573_drapable
enactable1338493enactable
encapsule1352283encapsule
encashable1744173encashable
encodable1446273encodable
gnawable1435683gn_awable
impalpable1843363impalpable
inclinable1447713inclinable
includable1545013includable
increasable1555393increasable
incunables1494023incunables
incurables14105143incurables
incurably16119063incurably
indexable1947033indexable
ineffable17105793ineffable
inerrable11410153inerrable
inescapably2053163inescapably
inexpiable2145653inexpiable
inferable14411263inferable
inflatable1546003inflatable
injurable18117413injurable
insatiable12107763insatiable
instable10313203in_stable
insurable111011083insurable
invaluable1545073invaluable
invariable1546843invariable
inviable1338523in_viable
kneadable1645673kneadable
locatable1345573locatable
namable11312343_n_amable
reapable12311393_reapable
recappable1843723recappable
scalable121710233_scalable
shapable15197803_shapable
unactable13310053unactable
uncurable13710073uncurable
undatable1238983undatable
uneatable11311693uneatable
unescapable1754033unescapable
unnamable1356623unnamable
unsalable1148993unsalable
unsayable1447223unsayable
unscalable1446353unscalable
untamable1347843untamable
vacatable1644643vacatable

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641596.81321817.3
3Display Results59590.0331787.9
 (SQL Overall)178691597.01625469.1
 
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.