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

140 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
helpable153660(None) 
culpable1436282culpable
fellable13179132fellable
gelable101710732gel_able
healable131610172healable
hearable131611602hearable
heatable131612042heatable
hewable15177822he_wable
holdable1437072holdable
keepable1635322keepable
meltable12310472meltable
palpable1448032palpable
reapable12311392reapable
reliable10313072reliable
sellable101711822sellable
tellable10169772tellable
weldable1436862weldable
alliable1038433alliable
bearable121512363bearable
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
billable12179503billable
callable12310753callable
capable13313363_capable
cheatable1646713cheatable
checkable2244743checkable
chelatable1743603chelatable
chewable1835443che_wable
chippable2073353chippable
culpably1744313culpably
delayable1546063delayable
delegable13136643delegable
deletable12149503deletable
deniable11312083deniable
dippable1536123dippable
drapable1377573drapable
dupable12238383_dupable
eatable91717603_eatable
effable15106673_effable
empale102611263_empa_le
enable83318483_e_nable
equable1849253_equable
errable9312183_errable
expiable1946113_expiable
eyeable1239063_eyeable
feedable1437673feedable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
flyable15307123_flyable
foldable1437133foldable
getable101712553ge_table
gettable11178133gettable
gullable1136463gullable
hackable1937473hackable
hangable1438213hangable
hatable121713963h_atable
hateable1339373hateable
hellhole1445243hellhole
helpful1543963helpful_
helpmate1545603helpmate
heritable1439453heritable
hidable1399403h_idable
hirable121612313h_irable
hireable13139083hireable
hittable1336853hittable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
jumpable2143953jumpable
killable14168133killable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liable81415813__liable
mappable1635923mappable
mendable131510583mendable
millable121710133millable
moldable1337103moldable
nestable101613673nestable
nettable101610243nettable
palpably1745363palpably
peccable1648123peccable
peelable1238553peelable
pettable121710713pettable
pliable111610323_pliable
quellable2043673quellable
readable11313163readable
reefable1339533reefable
reelable10311593reelable
relabel938163rel_abel
relatable11310053relatable
relaxable1836363relaxable
relegable1258103relegable
reliables1145903reliables
reliably1339243reliably
relivable1438513relivable
rentable101716333rentable
restable101618443restable
retable91820403re_table
reusable10811273reusable
rippable1435383rippable
ropable111611333_ropable
rulable9310533rul_able
salable91415463sal_able
saleable10312023saleable
salvable1338403salvable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sendable111612043sendable
servable13310093servable
sewable121911173se_wable
shapable15197803shapable
shedable1437423she_dable
sheddable1643693sheddable
shippable1853793shippable
solvable1337473solvable
syllable13177773syllable
talkable1437193talkable
tappable1436343tappable
tearable101512673tearable
teasable101511173teasable
temptable1545813temptable
tenable93214493te_nable
testable101412623testable
tillable10159753tillable
tiltable10159013tiltable
tippable1435263tippable
typable1435883_typable
valuable1336863valuable
vendable14159693vendable
walkable1736063walkable
wearable131510553wearable
wettable13148043wettable
wieldable1543813wieldable
willable13168683willable
yieldable1543353yieldable

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621407.08020644.4
3Display Results1401400.0602333.3
 (SQL Overall)1786911407.56023636.4
 
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.