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

216 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
listable1081031(None) 
liftable1376861liftable
bitable11312202bi_table
castable121613972castable
citable11313462ci_table
disable10516432dis_able
fishable1637592fishable
fittable1337092fittable
giftable1465892giftable
gustable11138202gustable
hittable1336852hittable
instable10313202instable
kissable1436852kissable
liable81415812li__able
lienable10188692lienable
likable13219412li_kable
likeable14166472likeable
limitable1345642limitable
linable92214342li_nable
lineable101811082lineable
linkable14187262linkable
listenable1243652listenable
livable122010322li_vable
liveable13177662liveable
losable91910952los_able
missable12311532missable
nestable101613672nestable
restable101618442restable
rustable101511362rustable
stable83921642__stable
tastable101511972tastable
testable101412622testable
tiltable10159012tiltable
twistable1444272twistable
unstable10313762unstable
visitable1445872visitable
wastable131410452wastable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
alienable1146933alienable
beatable121612243beatable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
bistate9313823bista_te
biteable1237933biteable
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
citeable1238413citeable
classable1347143classable
clickable1944303clickable
climbable1743603climbable
clippable1773463clippable
closable12168003clos_able
closeable13155023closeable
constable13311003constable
cuttable1247953cuttable
datable101714233_datable
dilatable1246853dilatable
dimmable1536113dimmable
dippable1536123dippable
disabled1248713dis_abled
disabler1147913dis_abler
disables11410903dis_ables
disenable1249673disenable
disputable1545063disputable
distal73615773dista_l_
distally1239553distally
distance11311853distance
distaste939943distaste
eatable91717603_eatable
editable11310423editable
electable13149623electable
evitable1339323evitable
fightable1844373fightable
fileable13179223fileable
fillable13179573fillable
filmable15157133filmable
filtrable1484263filtrable
finable122213623fi_nable
findable14179023findable
fineable131810333fineable
fireable131710223fireable
fixable19218193fi_xable
flickable2043983flickable
floatable1444983floatable
flushable1743573flushable
getable101712553_getable
gettable11178133gettable
giftables1572593giftables
giveable14155753giveable
gustables12165223gustables
hatable121713963_hatable
heatable131612043heatable
hidable1399403hi_dable
hirable121612313hi_rable
hireable13139083hireable
huntable1338093huntable
imitable1239123imitable
isolable1038793_isolable
issuable1046873issuable
istle52214713_ist__le
kickable1535583kickable
killable14168133killable
kissably1744073kissably
knittable1544243knittable
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
lisle53916723lis___le
listee64223063list__ee
listel64214743list_el_
listels74212433list_els
litigable1244223litigable
little63312163li_t_tle
loanable1037613loanable
locatable1345573locatable
lockable1636953lockable
lovable12179553l_ovable
loveable13187903loveable
maskable1638003maskable
meltable12310473meltable
millable121710133millable
minable112315073mi_nable
mineable121611053mineable
miscible1447673miscible
miserable1349653miserable
mislabel1296173mislabel
mistakable1843103mistakable
mistake131312623mista_ke
mistitle1038523mistitle
mixable18259173mi_xable
mutable11312303_mutable
nettable101610243nettable
notable92114903_notable
obstacle1243593obstacle
paintable1337243paintable
passable12310633passable
pettable121710713pettable
pistache1545893pistache
pistole92414313pist_ole
pitiable1238293pitiable
pivotable1644563pivotable
plantable1337273plantable
pliable111610323pli__able
pointable1337343pointable
portable12313203portable
posable112212783pos_able
potable112115363_potable
printable1338203printable
quotable1936493quotable
raisable10311643rais_able
raiseable1147243raiseable
ratable91717553_ratable
relishable1544523relishable
rentable101716333rentable
restabled12148963restabled
restables111511423restables
retable91820403_retable
ridable101412493ri_dable
rideable1158653rideable
rinsable10310043rinsable
rippable1435383rippable
risible937923ris_ible
sable74732163__s_able
seisable10311373seis_able
shiftable1744893shiftable
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeable1937113sizeable
sliceable1345443sliceable
slidable1137953sli_dable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
suable83920553__suable
suitable10310893suitable
table75429603___table
tasteable1146123tasteable
tillable10159753tillable
timetable1346873timetable
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
totable92313363_totable
trustable1147123trustable
unstabler1145623unstabler
unstably1339493unstably
usable84012553_us_able
useable9911063_useable
viable111613773vi__able
viewable1635223viewable
violable1337543violable
visible1236923vis_ible
vitiable1337503vitiable
votable122111373_votable
washable16138043washable
wettable13148043wettable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable
writable1338753writable

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 Limit1461622167.39319770.3
3Display Results2162160.0762842.1
 (SQL Overall)1786912167.88922650.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.