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

186 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
huntable133809(None) 
chantable1636892chantable
countable1348852countable
cuttable1247952cuttable
gustable11138202gustable
hangable1438212hangable
hatable121713962h_atable
heatable131612042heatable
hittable1336852hittable
huggable1543332huggable
hummable1744582hummable
mountable1346302mountable
mutable11312302mu_table
quotable1936492quotable
rentable101716332rentable
rustable101511362rustable
shunnable1443202shunnable
suitable10310892suitable
tunable92511312tun_able
tuneable1038912tuneable
turntable1144982turntable
unable83819222_un_able
unstable10313762_unstable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
auditable1245993auditable
bankable1677913bankable
bannable1278353bannable
beatable121612243beatable
bendable131510853bendable
bindable13169623bindable
bitable11312203_bitable
boatable121610263boatable
bondable13169273bondable
bootable12179223bootable
boundable1444843boundable
buffable1844393buffable
burnable1237263burnable
buyable1437493bu_yable
cantabile1346893cantabile
cartable121314093cartable
castable121613973castable
chartable1636833chartable
cheatable1646713cheatable
citable11313463_citable
constable13311003constable
countably1646293countably
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
datable101714233_datable
deniable11312083deniable
denotable1238373denotable
doubtable1445163doubtable
dubitable1445093dubitable
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
eatable91717603_eatable
editable11310423editable
enable83318483_en_able
equatable2045193equatable
equitable2046193equitable
evitable1339323evitable
finable122213623fin_able
findable14179023findable
fineable131810333fineable
fittable1337093fittable
fungible1444173fungible
furlable1335893furlable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
grantable1257293grantable
guidable1236203guidable
gullable1136463gullable
gunwale1134733gunwa_le
gustables12165223gustables
habitable1645953habitable
hackable1937473hackable
hantle94318203hant__le
hateable1339373hateable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hewable15177823h_ewable
hidable1399403h_idable
hirable121612313h_irable
hireable13139083hireable
holdable1437073holdable
honorable1446953honorable
humble133615053hu__mble
huntedly1543583huntedly
hurtle93512943hurt__le
hustle93113993hust__le
ignitable1245463ignitable
imitable1239123imitable
instable10313203instable
jumpable2143953jumpable
lendable11169463lendable
liftable1376863liftable
linable92214343lin_able
lineable101811083lineable
linkable14187263linkable
listable10810313listable
meltable12310473meltable
mendable131510583mendable
minable112315073min_able
mineable121611053mineable
munchable1844943munchable
mutably1438613mu_tably
nestable101613673nestable
nettable101610243nettable
notable92114903_notable
outfable1378813outfable
ownable1237283own_able
paintable1337243paintable
pentacle1239383pentacle
pettable121710713pettable
plantable1337273plantable
pointable1337343pointable
portable12313203portable
potable112115363_potable
printable1338203printable
prunable1237843prun_able
quotably2244153quotably
ratable91717553_ratable
restable101618443restable
retable91820403_retable
rinsable10310043rinsable
roundtable1383203roundtable
ruinable1039263ruinable
rulable9310533ru_lable
sandable111612823sandable
sendable111612043sendable
shiftable1744893shiftable
singable11159543singable
sinkable14178413sinkable
sortable10312483sortable
soundable1245983soundable
stable83921643__stable
statable10310703statable
suable83920553su__able
suitably1347593suitably
summable1436903summable
surfable1338443surfable
table75429603___table
tannable1039383tannable
tastable101511973tastable
tenable93214493ten_able
tentacle1037693tentacle
testable101412623testable
thinkable1844063thinkable
tiltable10159013tiltable
totable92313363_totable
trustable1147123trustable
tubbable1134683tubbable
tunably12218293tun_ably
tuneably1346093tuneably
turnable1037853turnable
turntables1242263turntables
unactable13310053_unactable
unbale83616403_unba_le
undatable1238983_undatable
undoable1139053_undoable
uneatable11311693_uneatable
unstabler1145623_unstabler
unstably1339493_unstably
untamable1347843_untamable
untame82513603_unta_me
untangle966323_untangle
untenable11410503_untenable
untunable1147833_untunable
unusable1038953_unusable
unviable1338703_unviable
usable84012553_u_sable
useable9911063_useable
vendable14159693vendable
votable122111373_votable
wastable131410453wastable
wettable13148043wettable
windable14159153windable
winnable13156983winnable
writable1338753writable

Search took 10 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.470380193.6
2DLD Change Limit1461621868.43617326.0
3Display Results1861860.0762447.4
 (SQL Overall)1786911868.98219894.3
 
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.