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

170 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
gustable1113820(None) 
gustables12165221gustables
rustable101511361rustable
castable121613972castable
cuttable1247952cuttable
getable101712552g_etable
gettable11178132gettable
giftable1465892giftable
guessable1243732guessable
guidable1236202guidable
gullable1136462gullable
huntable1338092huntable
instable10313202instable
listable10810312listable
mutable11312302mu_table
nestable101613672nestable
quotable1936492quotable
restable101618442restable
stable83921642__stable
suitable10310892suitable
tastable101511972tastable
testable101412622testable
trustable1147122trustable
unstable10313762unstable
usable84012552_us_able
useable9911062_useable
wastable131410452wastable
abatable1238023abatable
abusable1236373abus_able
actable11313473_actable
adjustable2042443adjustable
agitable1138583agitable
amusable1237143amus_able
auditable1245993auditable
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
buffable1844393buffable
burnable1237263burnable
bustle84015483bust__le
buyable1437493bu_yable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
causable1239973caus_able
citable11313463_citable
constable13311003constable
countable1348853countable
crushable1645263crushable
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
datable101714233_datable
disable10516433dis_able
doubtable1445163doubtable
dubitable1445093dubitable
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
eatable91717603_eatable
editable11310423editable
equatable2045193equatable
equitable2046193equitable
eustele738193eust_ele
evitable1339323evitable
fishable1637593fishable
fittable1337093fittable
flushable1743573flushable
furlable1335893furlable
fusible1237023fus_ible
gable85325523g___able
gainable1138933gainable
gaugeable1342983gaugeable
gelable101710733g_elable
gestalt8411173gesta_lt
gestate83614073gesta_te
getatable1235953getatable
giftables1572593giftables
giveable14155753giveable
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
graspable1444873graspable
grazable2036223grazable
growable1435623growable
gullably1444793gullably
gullible1144063gullible
gunwale1134733gunwa_le
gustative1345683gustative
gustily113010903gust_ily
guttae73210583gutta__e
guttate8328903gutta_te
guttle74111973gu_t_tle
hatable121713963_hatable
heatable131612043heatable
hittable1336853hittable
huggable1543333huggable
hummable1744583hummable
hustle93113993hust__le
ignitable1245463ignitable
imitable1239123imitable
issuable1046873issuable
jumpable2143953jumpable
justle133211583just__le
kissable1436853kissable
liftable1376863liftable
losable91910953los_able
maskable1638003maskable
meltable12310473meltable
missable12311533missable
mountable1346303mountable
mustache15185283mustache
mutably1438613mu_tably
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
outfable1378813outfable
passable12310633passable
pettable121710713pettable
portable12313203portable
posable112212783pos_able
potable112115363_potable
pursuable1344693pursuable
pustule937683pust_ule
quotably2244153quotably
ratable91717553_ratable
rentable101716333rentable
restabled12148963restabled
restables111511423restables
retable91820403_retable
reusable10811273reus_able
ruinable1039263ruinable
rulable9310533ru_lable
rustle63615413rust__le
sable74732163__s_able
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
suable83920553__suable
suitably1347593suitably
summable1436903summable
surfable1338443surfable
table75429603___table
tasteable1146123tasteable
tiltable10159013tiltable
totable92313363_totable
tubbable1134683tubbable
tunable92511313tu_nable
tuneable1038913tuneable
turnable1037853turnable
turntable1144983turntable
twistable1444273twistable
unable83819223_u_nable
unstabler1145623unstabler
unstably1339493unstably
unusable1038953unus_able
usably11288983_us_ably
useably1287393_useably
visitable1445873visitable
votable122111373_votable
washable16138043washable
wettable13148043wettable
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.440406115.9
2DLD Change Limit1461621709.14015991.5
3Display Results1701700.0762236.8
 (SQL Overall)1786911709.65618505.7
 
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.