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

178 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
portaled1123920(None) 
portaged12228461portaged
mortared1137212mortared
petaled103614152p_etaled
portable12313202portable_
portables1337872portables
portage103013642portage_
portages112613222portages
portal84218462portal__
portals94015562portal_s
ported94223242port__ed
portered112311542portered
portrayed1564102portrayed
totaled839692to_taled
aortae65115473aorta_e_
aortal65217513aortal__
bobtailed1443193bobtailed
borated104116363bor_ated
bottled104611233bo_ttled
chortled14326613chort_led
coaled95022713co__aled
corbeled1338373corbeled
corotated122810053corotated
corraded12128293corraded
corralled1245283corralled
craaled10339423_craaled
curtailed1244113curtailed
dartled9409853dart_led
foaled104515963fo__aled
footled113610763foot_led
foraged124812283for_aged
forayed14368593for_ayed
fortuned1285323fortuned
goaled85014363go__aled
hosteled1237293hosteled
hurtled11339593hurt_led
jostled15267083jost_led
journaled1742673journaled
kirtled12287033kirt_led
kraaled12254983_kraaled
metaled102913883_metaled
montaged12107763montaged
morale85220553mor_ale_
morales93619403mor_ales
morseled1147193morseled
mortal84616853mortal__
mortally1339933mortally
mortals93914003mortal_s
mortgaged1442543mortgaged
morticed1377163morticed
mortised1178743mortised
mottled10409973mo_ttled
muraled10410833mur_aled
notated82713663no_tated
orated74221503_or_ated
outled74020343_out_led
paled85538723p___aled
pantalet10415903pantalet
pantiled113111593pantiled
paraded114014263par_aded
parbaked1735503parbaked
parceled1338343parceled
parlayed1435823parlayed
parled94626293par__led
paroled104217633par_oled
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
parted94228683part__ed
partied103516553part_ied
partlet92720363part_let
pealed95322813p__ealed
pedaled113711893p_edaled
peptalked1842473peptalked
percale11314093percale_
percales12313803percales
periled10316323per_iled
perilled11410113perilled
pertained1238503pertained
pervaded1535373pervaded
pestled102711453pest_led
petalled1138713p_etalled
petrale9312623petrale_
petrales10312983petrales
pettled103611513p_ettled
phrased1387383phr_ased
phreaked1834493phreaked
pigtailed1353493pigtailed
pintailed1245553pintailed
pirated102515613pir_ated
pistoled11259593pistoled
poetised1138523poetised
poetized2037983poetized
poleaxed1854823poleaxed
poled84934843po___led
polkaed1435323polka_ed
polled94022003po__lled
pomaded13377863po_maded
pommeled1543103pommeled
ponytailed1652283ponytailed
pooled94619813po__oled
poppled11339243po_ppled
pored85234513por___ed
porked134717623por__ked
portably1539313portably
portance12310123portance
portances1349833portances
portapak1642343portapak
portend103411193port_end
portended1345643portended
porter84224413port__er
porthole1349523porthole_
portholes14410373portholes
porticoed1445423porticoed
portioned1248333portioned
portless10310643port_less
portlier1038373portlier
portly114713403port_l_y
portrayer1464003portrayer
portside1138163portside
postage103214853postage_
postages112815323postages
postal84317533postal__
postally13310273postally
postals93716373postal_s
postdated1346883postdated
posted93722493post__ed
postured1139493postured
potable112115363po_table_
potables12179703po_tables
potage92715903po_tage_
potages102416423po_tages
potholed1448393potholed
pottage103310603pottage_
pottages112910453pottages
potted94624013po_t_ted
pottered112311663pottered
pottle84416103po_ttle_
pottles93816983po_ttles
pouted94021393pout__ed
prated94924923p_r_ated
prattled11246533prattled
prayed124815433p_r_ayed
preaged11612333p_reaged
pretaped13339133pretaped
prilled104713003p_rilled
probated13410863probated
profaned14207973profaned
profiled14338523profiled
pronated11414053pronated
prorated11513713prorated
protases102115033protases
protyle12229453protyle_
protyles13249833protyles
prowled13309913p_rowled
psoralea1083433psor_alea
psoralen1063453psor_alen
purfled13248733pur_fled
purled94520753pur__led
purpled12299783pur_pled
pustuled1134953pustuled
pyralid1347983pyr_alid
rootled83410533root_led
rotated82715293ro_tated
sortable10312483sortable_
sorted74523713sort__ed
sortied83314103sort_ied
spiraled1137733spir_aled
sported104015433sport__ed
staled74728103__staled
surtaxed1644133surtaxed
tootled83511043toot_led
tortile7313193tortile_
tortured935843tortured
totalled935843to_talled
turtled8309683turt_led
worthed1437873wort_hed

Search took 9 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 Limit1461621787.83018666.9
3Display Results1781780.0762342.1
 (SQL Overall)1786911788.32621461.8
 
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.