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

91 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
teachable1613760(None) 
leachable16136441leachable
reachable16129661reachable
teachably19135181teachably
attachable1743192attachable
bleachable1943382bleachable
coachable1846302coachable
detachable1844612detachable
peaceable1548252peaceable
poachable1846242poachable
searchable1744142searchable
tearable101512672tea_rable
teasable101511172tea_sable
torchable1645532torchable
touchable1645022touchable
traceable1338322traceable
trackable1736742trackable
tractable1338512tractable
unteachable1845742unteachable
actable11313473__actable
beachball1843463beachball
bearable121512363bea_rable
beatable121612243bea_table
breathable1744143breathable
cashable15159793_cashable
catchable1845713catchable
decayable1745623decayable
detachably2153213detachably
eatable91717603_ea_table
enactable1338493enactable
exactable2046433exactable
faceable15108493_faceable
hackable1937473_hackable
hatchable1944793hatchable
healable131610183hea_lable
hearable131611613hea_rable
heatable131612043hea_table
impeachable2253923impeachable
leachate1347443leacha_te
learnable1145563learnable
leasable101510133lea_sable
matchable1845463matchable
munchable1844943munchable
packable1838633_packable
patchable1845633patchable
peaceably1845593peaceably
peccable1648123pe_ccable
placable14169243plac_able
placeable1536913placeable
quenchable2642213quenchable
readable11313163rea_dable
reapable12311393rea_pable
rescuable1347583rescuable
sealable101512693sea_lable
stackable1735993stackable
stealable1136573stea_lable
stretchable1852813stretchable
takable13310193t_a_kable
takeable1437463t_akeable
talkable1437193t_alkable
tamable11312853t_a_mable
tameable1238603t_ameable
tannable1039383t_annable
tapeable1238823t_apeable
tappable1436343t_appable
tastable101511973t_astable
taxable1639073t_a_xable
teacake1335453teac_a_ke
teacherly1743513teacherly
tellable10169773te_llable
temptable1545813temptable
tenable93214493te__nable
tenantable1244183tenantable
tenurable1147423tenurable
testable101412623te_stable
tithable1336853t_ithable
traceably1646223traceably
tracheole1445573tracheole
trachle12311853trach__le
tractably1646243tractably
tradable1139873tra_dable
tradeable1247413tradeable
trainable1138943trainable
treatable1139323trea_table
truckable1744513truckable
unactable13310053unactable
unreachable1846093unreachable
washable16138043_washable
watchable1944773watchable
wearable131510563wea_rable
weighable1843143weighable

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.423422437.4
2DLD Change Limit148641917.18620684.8
3Display Results91910.0461978.3
 (SQL Overall)178691917.65523343.0
 
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.