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

181 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
potables1217970(None) 
notables10178241notables
portables1337871portables
potable112115361potable_
eatables10169792eatables
movables15175572movables
notable92114902notable_
parables121613562parables
payables15166482payables
pokable15209502pokable_
portable12313202portable_
posable112212782posable_
potages102416422pota_ges
potashes1337832potashes
potatoes1039942potatoes
potholes13312932potholes
pottles93816982pot_tles
probables1545432probables
ratables10159722ratables
retables101712672retables
stables93219072_stables
tables84524892__tables
totable92313362totable_
vocables15145732vocables
votable122111372votable_
ables75935543___ables
actable11313473actable_
arables91814973_arables
bitable11312203bitable_
boatable121610263boatable_
bobbles104514913bo_bbles
bootable12179223bootable_
botanies10312853botanies
bottles94216273bot_tles
cables104527553__cables
citable11313463citable_
cobbles133814823co_bbles
cobles104622883co__bles
codable12311663codable_
constables1446733constables
coracles121811163coracles
datable101714233datable_
disables11410903disables
doable93115243do_able_
dotages92311793dota_ges
dottles83912283dot_tles
doubles103113353do_ubles
dowable13189453dowable_
durables11237013durables
eatable91717603eatable_
enables92813123_enables
fables114921673__fables
foibles1238853fo_ibles
gables94222333__gables
getable101712553getable_
giftables1572593giftables
gobbles123512583go_bbles
gustables12165223gustables
hatable121713963hatable_
hobbles143313783ho_bbles
locales93715093loca_les
losable91910953losable_
lovable12179553lovable_
morales93619403mora_les
motiles93317433mot_iles
mottles93415803mot_tles
movable14189433movable_
moveables16163963moveables
mutable11312303mutable_
nobbles114014523no_bbles
nobles83319723no__bles
nombles113212343no_mbles
nopales93812523nopa_les
notably12199993notabl_y
notaries8314933notaries
notates72817483nota_tes
oracles93212423_oracles
outfables1485563outfables
padles95221123p__adles
pales75753803p__a_les
parable111819773parable_
parles86334403p__arles
payable141711323payable_
pebbles1337573p_ebbles
pentacles1338773pentacles
petabytes1642793petabytes
petaled103614153peta_led
petalled1138713petalled
petals84719813peta_l_s
petioles10311643petioles
petrales10312983petrales
pettable121710713pettable_
pettles93916483pet_tles
pitiable1238293pitiable_
pivotable1644563pivotable_
pliable111610323pliable_
plowable1535913plowable_
poaches144416943po_aches
pointable1337343pointable_
poles75351003po___les
pomaces132712123poma_ces
pomades123711733poma_des
poodles103013513po_odles
popples103011873po_pples
portably1539313portabl_y
portages112613223porta_ges
portaled11239203porta_led
portals94015563porta_l_s
portances1349833portances
portholes14410373portholes
posoles9314883po_soles
postages112815323posta_ges
postals93716373posta_l_s
postholes14410453postholes
potableness1547193potableness
potage92715903pota_ge_
potboys1475273pot_boys
potences12710693potences
potfuls1236293potful_s
pothole12312173pothole_
potholed1448393potholed
potiches1539203potiches
potlaches16115263potlaches
potlines10714213potlines
potpies113116173pot_pies
potsies93019483pot_sies
pottages112910453pottages
potties93723543pot_ties
pottle84416103pot_tle_
pourable1239133pourable_
pozoles1839063po_zoles
prattles10189403prattles
preambles1545333preambles
probable1439053probable_
protases102115033prota_ses
protyles13249833prot_yles
provable1539093provable_
quotable1936493quotable_
ratable91717553ratable_
restables111511423restables
retable91820403retable_
robles85321693ro__bles
ropable111611333ropable_
rotaries8315693rotaries
rotates72819773rota_tes
roubles93413513ro_ubles
rowable121510303rowable_
sables85026693__sables
sociables1344963sociables
solubles1065893solubles
sortable10312483sortable_
sowable121610753sowable_
sparables13167163sparables
spottable1345343spottable_
stabiles10311403_stabiles
stable83921643_stable_
stabled103514953_stabled
stabler94014933_stabler
stablers103611153_stablers
stablest103312943_stablest
stales65538293_sta_les
staples93617213_staples
storables1146283storables
tabes76033923__tab_es
tablas83716163__tablas
table75429603__table_
tabled94020043__tabled
tablet84227643__tablet
tablets94714383__tablets
tales55451373__ta_les
taxables1734383taxables
totaled839693tota_led
totalled935843totalled
totals63115163tota_l_s
toteable1048353toteable_
towable121910113towable_
vocable14189673vocable_
votaries11312013votaries
voteable1347213voteable_
wobbles143412433wo_bbles
worktables1942613worktables

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.423422437.4
2DLD Change Limit1461621817.37319824.0
3Display Results1811810.0802262.5
 (SQL Overall)1786911817.87622688.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.