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

268 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
sortable1031248(None) 
portable12313201portable
sorbable1239301sorbable
sortably1338801sortably
boatable121610262boatable
bootable12179222bootable
cartable121314092cartable
fordable1439592fordable
formable1539502formable
notable92114902no_table
portables1337872portables
portably1539312portably
potable112115362po_table
scrutable1346042scrutable
servable13310082servable
sociable1239502sociable
solvable1337472solvable
sowable121610752so_wable
spottable1345342spottable
stable83921642s__table
statable10310702statable
storable10310732stor_able
suitable10310892suitable
surfable1338442surfable
totable92313362to_table
votable122111372vo_table
workable1737092workable
worktable1844722worktable
abatable1238023abatable
absorbable1343333absorbable
actable11313473_actable
adoptable1444753adoptable
adorable1138773ador_able
adsorbable1542893adsorbable
agitable1138583agitable
aortae65115473aorta__e
aortal65217513aorta_l_
arable81821003_ar_able
avertable14117343avertable
barrable1249243barrable
beatable121612243beatable
bitable11312203_bitable
boardable1444893boardable
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
burnable1237263burnable
castable121613973castable
chartable1636833chartable
citable11313463_citable
codable12311663co_dable
cogitable1446943cogitable
coinable12311583coinable
constable13311003constable
cookable16147973cookable
copyable1736623copyable
coracle112011723cor_acle
countable1348853countable
covetable1648163covetable
curable112414513cur_able
curbable1447663curbable
cuttable1247953cuttable
datable101714233_datable
deportable1545653deportable
doable93115243do__able
doubtable1445163doubtable
dowable13189453do_wable
dryable13237433_dryable
durable102312723dur_able
eatable91717603_eatable
editable11310423editable
erodable1139203erodable
errable9312183_errable
evitable1339323evitable
exorable1738933exor_able
exportable2144603exportable
farmable1538203farmable
fireable131710223fireable
fittable1337093fittable
floatable1444983floatable
foamable1537043foamable
foilable1338063foilable
foldable1437133foldable
forceable1646213forceable
forcible1545143forcible
forgeable1545403forgeable
formably1846663formably
friable122612563_friable
fryable15277463_fryable
furlable1335893furlable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
growable1435623growable
gustable11138203gustable
hatable121713963_hatable
heatable131612043heatable
heritable1439453heritable
hirable121612313hir_able
hireable13139083hireable
hittable1336853hittable
holdable1437073holdable
horrible13135233horrible
huntable1338093huntable
imitable1239123imitable
importable1646553importable
instable10313203instable
irritable1148053irritable
isolable1038793iso_lable
isolatable1244373isolatable
joinable1737283joinable
liftable1376863liftable
listable10810313listable
loanable1037613loanable
locatable1345573locatable
lockable1636953lockable
losable91910953lo_sable
lovable12179553lo_vable
loveable13187903loveable
meltable12310473meltable
mockable1846643mockable
moldable1337103moldable
morale85220553mor_a_le
mortal84616853morta_l_
mortally1339933mortally
mortals93914003morta_ls
mountable1346303mountable
movable14189433mo_vable
moveable15168013moveable
mutable11312303_mutable
nestable101613673nestable
nettable101610243nettable
notables10178243no_tables
notably12199993no_tably
oracle84313293_or_acle
outfable1378813_outfable
ownable1237283_ownable
parable111819773par_able
parsable12311693parsable
partible1238063partible
pettable121710713pettable
pointable1337343pointable
pokable15209503po_kable
portage103013643porta_ge
portal84218463porta_l_
portaled11239203porta_led
portals94015563porta_ls
portance12310113portance
porthole1349523porthole
posable112212783po_sable
potables12179703po_tables
pourable1239133pourable
probable1439053probable
provable1539093provable
quotable1936493quotable
ratable91717553_ratable
rentable101716333rentable
reportable1446953reportable
restable101618443restable
retable91820403_retable
rockable1638013rockable
ropable111611333ro_pable
rotatable1146653rotatable
rowable121510303ro_wable
rustable101511363rustable
sable74732163s___able
sailable10310563sailable
salable91415463s_alable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
savable121711863s_avable
saveable1339003saveable
sayable121411613s_ayable
scalable121710233scalable
scoopable1544863scoopable
scrabble14196993scrabble
scramble14177253scramble
screwable1644843screwable
scribble14175433scribble
sealable101512693sealable
seeable91113943s_eeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
sewable121911173s_ewable
shakable17177683shakable
shamable15168803shamable
shapable15197803shapable
sharable131910693sharable
shareable1436733shareable
shavable16177273shavable
shedable1437423shedable
shiftable1744893shiftable
shockable2044703shockable
shortage1236313shorta_ge
showable1636583showable
singable11159543singable
sinkable14178413sinkable
sizable1839893s_izable
sizeable1937113sizeable
skiable1338883s_kiable
slakable14177553slakable
slayable13157563slayable
slidable1137953slidable
smokable1636223smokable
smokeable1743853smokeable
sociables1344963sociables
sociably1546793sociably
softball1344203softball
soluble966103so_luble
sorbate9311733sorba_te
sorta57125413sorta___
sortie63621993sort__ie
soundable1245983soundable
soutache1344983soutache
soutane7312063souta_ne
sparable121611983sparable
spareable1337263spareable
spoilable1345163spoilable
sprattle1054763sprattle
stabile9312063s__tabile
stabled103514953s__tabled
stabler94014933s__tabler
stables93219073s__tables
stably113314123s__tably
stale55637103s__ta_le
staple84415823s__taple
stateable1136903stateable
stewable1337133stewable
stonable1039843stonable
stoppable1544103stoppable
storables1146283stor_ables
stowable1337613stowable
suable83920553s__uable
suitably1347593suitably
summable1436903summable
supportable1752693supportable
surtitle845283surtitle
swayable16135533swayable
syllable13177773syllable
table75429603___table
tastable101511973tastable
testable101412623testable
tiltable10159013tiltable
titrable1038963titrable
torchable1645533torchable
tortile7313193tort_ile
toteable1048353toteable
towable121910113to_wable
triable92515393_triable
turnable1037853turnable
turntable1144983turntable
unstable10313763unstable
variable13310063variable
veritable1448743veritable
vocable14189673vo_cable
voidable1466853voidable
voteable1347213voteable
wastable131410453wastable
wettable13148043wettable
wirable121610963wir_able
workably2044743workably
worktables1942613worktables
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.403443402.0
2DLD Change Limit1461622687.08020644.4
3Display Results2682680.1102436.4
 (SQL Overall)1786912687.59323533.6
 
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.