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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
peccable164812(None) 
impeccable2044522impeccable
packable1838632packable
peaceable1548252peaceable
peelable1238552peelable
percale11314092perca_le
pettable121710712pettable
placable14169242placable
actable11313473_actable
amicable1438433amicable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
cable95329913___cable
cascable141510623cascable
checkable2244743checkable
decayable1745623decayable
decidable1547223decidable
deniable11312083deniable
eatable91717603_eatable
educable1337093educable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
enable83318483_e_nable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
evocable1537103evocable
execrable2046233execrable
expectable2345063expectable
eyeable1239063_eyeable
faceable15108493faceable
feedable1437673feedable
fellable13179133fellable
fencible1545603fencible
gelable101710733ge_lable
getable101712553ge_table
gettable11178133gettable
hackable1937473hackable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
helpable1536603helpable
hewable15177823he_wable
impeccably2353933impeccably
keepable1635323keepable
kickable1535583kickable
leachable16136443leachable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
lockable1636953lockable
medicable1647503medicable
meltable12310473meltable
mendable131510583mendable
mockable1846643mockable
nestable101613673nestable
nettable101610243nettable
openable1247013ope_nable
operable12410323ope_rable
palpable1448033palpable
parable111819773p_arable
parsable12311693parsable
passable12310633passable
patchable1845633patchable
pawnable1535983pawnable
payable141711323p_ayable
peaceably1845583peaceably
pebble1238003pe__bble
peccancy1643953peccancy
peccant13311733pecca_nt
peccantly1843953peccantly
peccaries1548533peccaries
peccary1636283pecca_ry
peccavi1643093pecca_vi
peccavis1743133peccavis
pectase112410363pecta_se
pectate112214693pecta_te
pentacle1239383pentacle
percales12313803perca_les
permeable1556813permeable
perusable1347453perusable
petrale9312623petra_le
pitiable1238293pitiable
placably17156673placably
placeable1536913placeable
playable15137923playable
pleadable1445513pleadable
pliable111610323p_liable
plowable1535913plowable
poachable1846243poachable
pokable15209503p_okable
portable12313203portable
posable112212783p_osable
potable112115363p_otable
pourable1239133pourable
predicable1747193predicable
pregnable1456693pregnable
previable1647533previable
priceable1546823priceable
probable1439053probable
provable1539093provable
prunable1237843prunable
reachable16129653reachable
readable11313163readable
reapable12311393reapable
recyclable1943643recyclable
reefable1339533reefable
reelable10311593reelable
reliable10313073reliable
rentable101716333rentable
rescale93215473resca_le
rescuable1347583rescuable
restable101618443restable
retable91820403re_table
reusable10811273reusable
revocable1647003revocable
rockable1638013rockable
sealable101512693sealable
securable1347773securable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
sewable121911173se_wable
sociable1239503sociable
speakable1745373speakable
spectacle1544083spectacle
spendable1446463spendable
teachable16137603teachable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
tenable93214493te_nable
testable101412623testable
vendable14159693vendable
vocable14189673_vocable
wearable131510553wearable
weldable1436863weldable
wettable13148043wettable

Search took 7 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621446.50022486.5
3Display Results1441440.0632285.7
 (SQL Overall)1786911446.71926594.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.