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

214 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
rustable10151136(None) 
gustable11138201gustable
restable101618441restable
trustable1147121trustable
castable121613972castable
crushable1645262crushable
cuttable1247952cuttable
gustables12165222gustables
huntable1338092huntable
instable10313202instable
listable10810312listable
mutable11312302mu_table
nestable101613672nestable
quotable1936492quotable
ratable91717552r_atable
rentable101716332rentable
restabled12148952restabled
restables111511422restables
retable91820402r_etable
reusable10811272reus_able
ruinable1039262ruinable
rulable9310532ru_lable
rustle63615412rust__le
stable83921642__stable
suitable10310892suitable
tastable101511972tastable
testable101412622testable
unstable10313762unstable
usable84012552_us_able
useable9911062_useable
wastable131410452wastable
abatable1238023abatable
abusable1236373abus_able
actable11313473_actable
adjustable2042443adjustable
agitable1138583agitable
amusable1237143amus_able
arousable1145573arous_able
auditable1245993auditable
beatable121612243beatable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
buffable1844393buffable
burnable1237263burnable
bustle84015483bust__le
buyable1437493bu_yable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
causable1239973caus_able
citable11313463_citable
constable13311003constable
countable1348853countable
creatable1339563creatable
crossable1347073crossable
crustal939023crusta_l_
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
datable101714233_datable
disable10516433dis_able
doubtable1445163doubtable
draftable1575563draftable
dubitable1445093dubitable
dupable12238383du_pable
durable102312723du_rable
dutiable1137373dutiable
eatable91717603_eatable
editable11310423editable
equatable2045193equatable
equitable2046193equitable
erasable10511043eras_able
erectable131210093erectable
eruptible1342923eruptible
eustele738193eust_ele
evitable1339323evitable
fishable1637593fishable
fittable1337093fittable
flushable1743573flushable
frustule1154483frust_ule
furlable1335893furlable
fusible1237023fus_ible
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
grantable1257293grantable
graspable1444873graspable
guessable1243733guessable
guidable1236203guidable
gullable1136463gullable
hatable121713963_hatable
heatable131612043heatable
hittable1336853hittable
huggable1543333huggable
hummable1744583hummable
hustle93113993hust__le
imitable1239123imitable
irritable1148053irritable
issuable1046873issuable
jumpable2143953jumpable
justle133211583just__le
kissable1436853kissable
liftable1376863liftable
losable91910953los_able
maskable1638003maskable
meltable12310473meltable
missable12311533missable
mountable1346303mountable
mustache15185283mustache
mutably1438613mu_tably
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
outfable1378813outfable
passable12310633passable
perusable1347453perus_able
pettable121710713pettable
portable12313203portable
posable112212783pos_able
potable112115363_potable
printable1338203printable
prunable1237843pru_nable
pursuable1344693pursuable
pustule937683pust_ule
quotably2244153quotably
radiable11611303radiable
raisable10311643raisable
raiseable1147243raiseable
ratables10159723r_atables
ratably121711513r_atably
rateable10311443rateable
readable11313163readable
reapable12311393reapable
rebuttable1443953rebuttable
reefable1339533reefable
reelable10311593reelable
refusable1476683refus_able
refutable1477863refutable
relatable11310053relatable
reliable10313073reliable
reputable1379123reputable
resalable1138733resalable
resale64025543res_a_le
rescale93215473resca_le
rescuable1347583rescuable
resectable1478123resectable
resemble1247313resemble
resettable1256513resettable
restage83316193resta_ge
restate73824883resta_te
restorable1246753restorable
restyle1038763rest_yle
resumable1347553resumable
retables101712673r_etables
reusables1175223reus_ables
ridable101412493r_idable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923ris_ible
rockable1638013rockable
ropable111611333r_opable
rotatable1146653rotatable
roundtable1383203roundtable
rowable121510303r_owable
rubble104315673ru__bble
ruble74521253ru___ble
rumble103718813ru__mble
rusticly1345183rusticly
rustily103112993rust_ily
rustled83311323rust__led
rustler73512343rust__ler
rustles73416413rust__les
rutile65217683ru_t_ile
sable74732163__s_able
scrutable1346043scru_table
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
tractable1338513tractable
treatable1139323treatable
truckable1744513truckable
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.1561145455.1
2DLD Change Limit1461622149.51615359.6
3Display Results2142140.0762815.8
 (SQL Overall)1786912149.74818331.0
 
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.