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

256 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
portable1231320(None) 
portables1337871portables
portably1539311portably
potable112115361po_table
sortable10312481sortable
boatable121610262boatable
bootable12179222bootable
cartable121314092cartable
deportable1545652deportable
exportable2144602exportable
fordable1439592fordable
formable1539502formable
importable1646552importable
notable92114902no_table
parable111819772par_able
parsable12311692parsable
partible1238062partible
pettable121710712pettable
pointable1337342pointable
pokable15209502po_kable
portage103013642porta_ge
portal84218462porta_l_
portaled11239202porta_led
portals94015562porta_ls
portance12310112portance
porthole1349522porthole
posable112212782po_sable
potables12179702po_tables
pourable1239132pourable
probable1439052probable
provable1539092provable
reportable1446952reportable
sorbable1239302sorbable
sortably1338802sortably
spottable1345342spottable
totable92313362to_table
votable122111372vo_table
workable1737092workable
worktable1844722worktable
abatable1238023abatable
actable11313473_actable
adoptable1444753adoptable
adorable1138773ador_able
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
doable93115243do__able
doubtable1445163doubtable
dowable13189453do_wable
dryable13237433_dryable
durable102312723dur_able
eatable91717603_eatable
editable11310423editable
erodable1139203erodable
errable9312183_errable
evitable1339323evitable
exorable1738933exor_able
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
instable10313203instable
irritable1148053irritable
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
openable1247013openable
operable12410323operable
oracle84313293_or_acle
outfable1378813_outfable
ownable1237283_ownable
packable1838633packable
paintable1337243paintable
palatable1346373palatable
palpable1448033palpable
parables121613563par_ables
parolable1347113parolable
partake1339643parta_ke
particle1239533particle
passable12310633passable
pawnable1535983pawnable
payable141711323p_ayable
peccable1648123peccable
peelable1238553peelable
pentacle1239383pentacle
percale11314093perca_le
permeable1556823permeable
permutable1644983permutable
perusable1347453perusable
petrale9312623petra_le
pitiable1238293pitiable
pivotable1644563pivotable
placable14169243placable
plantable1337273plantable
playable15137923playable
pliable111610323p_liable
plowable1535913plowable
poachable1846243poachable
pocketable2043593pocketable
porbeagle1482253porbeagle
portabella1452273portabella
portabello1452093portabello
portaged12228463portaged
portages112613223portages
portances1349833portances
portapak1642343portapak
portative1449373portative
portholes14410373portholes
portiere1038773portiere
portly114713403port__ly
portside1138163portside
possible1245813possible
postage103214853posta_ge
postal84317533posta_l_
postally13310273postally
postals93716373posta_ls
postbase1246443postbase
posthole1339533posthole
potage92715903po_ta_ge
pothole12312173po_thole
pottage103310603potta_ge
pottle84416103po_t_tle
prattle9208833p_rattle
preamble1436383p_reamble
printable1338203printable
probables1545433probables
probably1746413probably
profitable1744963profitable
promotable1645033promotable
protyle12229453prot_yle
provably1846213provably
prunable1237843prunable
purgeable1444413purgeable
pursuable1344693pursuable
quotable1936493quotable
ratable91717553_ratable
rentable101716333rentable
restable101618443restable
retable91820403_retable
rockable1638013rockable
ropable111611333ro_pable
rotatable1146653rotatable
rowable121510303ro_wable
rustable101511363rustable
scrutable1346043scrutable
servable13310083servable
sociable1239503sociable
solvable1337473solvable
sowable121610753so_wable
sparable121611983spar_able
spareable1337263spareable
spoilable1345163spoilable
stable83921643__stable
statable10310703statable
storable10310733stor_able
suitable10310893suitable
supportable1752693supportable
surfable1338443surfable
table75429603___table
tastable101511973tastable
testable101412623testable
tiltable10159013tiltable
titrable1038963titrable
torchable1645533torchable
tortile7313193tort_ile
toteable1048353toteable
towable121910113to_wable
triable92515393_triable
turnable1037853turnable
turntable1144983turntable
unstable10313763unstable
vaporable1645543vapor_able
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.440406115.9
2DLD Change Limit1461622567.42019698.4
3Display Results2562560.1102327.3
 (SQL Overall)1786912567.97022420.5
 
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.