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

205 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
hateable133937(None) 
dateable1149441dateable
hatable121713961hat_able
rateable10311441rateable
biteable1237932biteable
chaseable1646342chaseable
citeable1238412citeable
datable101714232dat_able
eatable91717602eat_able
faceable15108492faceable
hackable1937472hackable
hangable1438212hangable
hatchable1944792hatchable
heatable131612042heat_able
hireable13139082hireable
hittable1336852hittable
makeable1637252makeable
nameable1238862nameable
ratable91717552rat_able
rateably1337782rateably
saleable10312022saleable
satiable10310732satiable
saveable1339002saveable
shakeable1844942shakeable
shameable1645572shameable
shapeable1645742shapeable
shareable1436732shareable
stateable1136902stateable
takeable1437462takeable
tameable1238602tameable
tapeable1238822tapeable
tasteable1146122tasteable
toteable1048352toteable
voteable1347212voteable
wadeable1437442wadeable
abatable1238023abat_able
actable11313473_actable
addable11218843_addable
affable15117403_affable
alterable1149163alterable
amenable1238863_amenable
amiable11312033_amiable
arable81821003_a_rable
atonable1038793_atonable
atoneable1145853_atoneable
atremble1244113_atremble
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
beatable121612243beat_able
bitable11312203bit_able
blameable1544723blameable
boatable121610263boat_able
callable12310753callable
canoeable1347103canoeable
capable13313363ca_pable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
catchable1845713catchable
causable1239973causable
changeable1843963changeable
chantable1636893chantable
chargeable1843473chargeable
chartable1636833chartable
cheatable1646713cheat_able
chokeable2053853chokeable
citable11313463cit_able
cuttable1247953cuttable
damnable1347593damnable
danceable1445303danceable
drapeable1445673drapeable
dutiable1137373dutiable
dyeable1337303_dyeable
eatables10169793eat_ables
enterable11312643enterable
eyeable1239063_eyeable
fadable13310463fa_dable
farmable1538203farmable
fatigable1544863fatigable
fileable13179223fileable
fineable131810333fineable
fireable131710223fireable
fittable1337093fittable
frameable1645353frameable
gainable1138933gainable
gaugeable1342983gaugeable
getable101712553get_able
gettable11178133gettable
giveable14155753giveable
grazeable2144153grazeable
habitable1645953habitable
handleable1643743handleable
hateful13107683hateful_
healable131610173healable
hearable131611603hearable
helpable1536603helpable
hewable15177823h_ewable
hidable1399403h_idable
hirable121612313h_irable
holdable1437073holdable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
imageable1445443imageable
jailable1737143jailable
jammable2144513jammable
labelable1344393labelable
lacerable1346943lacerable
lapsable12117383lapsable
laudable1137893laudable
likeable14166473likeable
lineable101811083lineable
liveable13177663liveable
loveable13187903loveable
mailable1239623mailable
makable15510203ma_kable
malleable1376073malleable
mappable1635923mappable
maskable1638003maskable
matchable1845463matchable
mineable121611053mineable
moveable15168013moveable
mutable11312303mut_able
namable11312343na_mable
nettable101610243nettable
notable92114903not_able
outfable1378813outfable
packable1838633packable
palpable1448033palpable
parable111819773pa_rable
parsable12311693parsable
passable12310633passable
patchable1845633patchable
patentable1444933patentable
pawnable1535983pawnable
payable141711323pa_yable
peaceable1548253peaceable
pettable121710713pettable
pitiable1238293pitiable
placeable1536913placeable
potable112115363pot_able
radiable11611303radiable
raisable10311643raisable
raiseable1147243raiseable
ratables10159723rat_ables
ratably121711513rat_ably
retable91820403ret_able
rideable1158653rideable
sailable10310563sailable
salable91415463sa_lable
saleably1338213saleably
salvable1338403salvable
sandable111612823sandable
satiably1337823satiably
saturable1146633saturable
savable121711863sa_vable
sayable121411613sa_yable
seeable91113943_seeable
shakable17177683sha_kable
shamable15168803sha_mable
shameably1943873shameably
shapable15197803sha_pable
sharable131910693sha_rable
shavable16177273sha_vable
sizeable1937113sizeable
spareable1337263spareable
stable83921643_st_able
stageable1246343stageable
statable10310703statable
stewable1337133_stewable
table75429603__t_able
takable13310193ta_kable
talkable1437193talkable
tamable11312853ta_mable
tannable1039383tannable
tappable1436343tappable
tastable101511973tastable
taxable1639073ta_xable
teazle15329553__teazle
tenable93214493__tenable
tithable1336853tithable
titrable1038963titrable
totable92313363tot_able
traceable1338323traceable
tradeable1247413tradeable
tuneable1038913tuneable
typeable1535233typeable
untenable11410503untenable
useable9911063_useable
utterable1147153utterable
valuable1336863valuable
variable13310063variable
vitiable1337503vitiable
votable122111373vot_able
wadable13310233wa_dable
walkable1736063walkable
washable16138043washable
wastable131410453wastable
watchable1944773watchable
waxable1937673wa_xable
wettable13148043wettable
writeable1444613writeable

Search took 9 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.486367677.0
2DLD Change Limit1461622057.57619292.8
3Display Results2052050.0802562.5
 (SQL Overall)1786912058.14221946.8
 
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.