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

382 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
shorten10351141(None) 
chorten122811301chorten
shorted113614401shorted
shortens11288991shortens
shorter103515501shorter
shotten10288461shotten
chortens13308792chortens
sharpen12389722sharpen
shodden12265762shodden
shooter103013992shooter
shopmen14277202shopmen
shoran94016042shor_an
shore85432652shor_e_
shored105723652shor_ed
shores94830412shor_es
shorn85722182shor__n
short85040532short__
shortened1345662shortened
shortener1245772shortener
shortest11310782shortest
shortia1048192shortia
shortie10411342shortie
shorties11414582shorties
shorting122514802shorting
shortly13387572shortly
shorts95321742short_s
shorty124313202short_y
shote85526102sho_te_
shotes95321912sho_tes
shotted113912402shotted
shouted113911552shouted
shouter103213082shouter
showmen15227172showmen
smarten9348862smarten
snorted83813492snorted
snorter74412662snorter
soften9429492s_often
sorted74523712s_orted
sorter64425092s_orter
sported104015432sported
sporter93616552sporter
stouten7307332stouten
torten65314352_torten
aborted10310423aborted
aborter939933aborter
ahorse9311513ahorse_
ashore9414613ashor_e_
assorted956603assorted
assorter866673assorter
boreen8314313_boreen
charted135116853charted
charter123918303charter
chasten124312403chasten
chirren12388743chirren
chorded144710553chorded
chore105126763chor_e_
chorea115216083chor_ea
chored125321883chor_ed
choremen1597603choremen
chores114828023chor_es
chorine123218363chorine
chorion12311773chorion
chortle124210443chortle
chortled14326613chortled
chortler13336843chortler
chortles133611323chortles
chosen116014133cho_sen
cortex15311473_cortex
cortin82423153_cortin
dehorted1357303dehorted
doormen1036753doormen
escorted1136703escorted
exhorted1935013exhorted
exhorter1845353exhorter
forte86131463_forte_
fortes95327183_fortes
ghosted1236273ghosted
gorhen1038893_gorhen
gotten73410113_gotten
hapten115312983_hapten
harden105718533_harden
harken135116343_harken
hasten95718563_hasten
hearten102411753hearten
hoarsen10367993_hoarsen
hodden113811453_hodden
hoiden103612333_hoiden
holden104113953_holden
holpen11299413_holpen
hooted104422663_hooted
hooter94123933_hooter
horde94623053_horde_
horded115420483_horded
hordein1138753_hordein
hordes104921633_hordes
horn76735613_hor__n
horned105718703_horned
hornet94926433_hornet
horrent10313553_horrent
horse86132653_horse_
horsed105321083_horsed
horses94729343_horses
horsey125115403_horsey
horste94817413_horste_
horstes104516113_horstes
hosen85623883_ho_sen
hosted105020343_hosted
hostel93914153_hostel
hotel85520753_ho_tel
hotted104319943_hotted
hotter94720083_hotter
hoyden13328933_hoyden
hurter93915853_hurter
marten84518263_marten
molten83311813_molten
moorhen1236023moorhen
moreen8313343_moreen
morgen9312203_morgen
oaten55222403__oaten
often84611413__often
phorate12413363phorate_
phorates13413043phorates
photon1111514833pho_ton
ported94223243_ported
portend103411193_portend
portent93619643_portent
porter84224413_porter
rotten64115433_rotten
sarsen6314233s_arsen
scarted104816123scarted
scooted103612283scooted
scooter93312873scooter
score75526743scor_e_
scored94621133scor_ed
scorer84818263scor_er
scores84725923scor_es
scorn75817453scor__n
scorned10229953scorned
scorner9259763scorner
scoter83815483sco_ter
scouted104112033scouted
scouter93313323scouter
screen85216023s_creen
shafted14288813shafted
shagreen1243443shagreen
shaitan1036893shaitan
shaken134113613sh_aken
shantey134210043shantey
shapen114414653sh_apen
share86437083shar_e_
shared105829063shar_ed
sharer95025483shar_er
shares95236413shar_es
sharked153613913sharked
sharker144313813sharker
sharn84823703shar__n
sharped134112053sharped
sharpens13377813sharpens
sharper124312703sharper
shatter103615703shatter
shaven124213303sh_aven
shebeen1234553shebeen
sheen85023313sh__een
sheeted113813043sheeted
sheeter103814913sheeter
sheitan1036573sheitan
shelter103214963shelter
sherbet12311383sherbet
shereef1337743shereef
shifted14359983shifted
shifter132911083shifter
shipmen14317283shipmen
shippen14298863shippen
shire84727133shir_e_
shires95225573shir_es
shirked153710463shirked
shirker143711343shirker
shirred113710503shirred
shirt84533903shirt__
shirtier1137943shirtier
shirting123213613shirting
shirts94918343shirt_s
shirty124312563shirt_y
shitted114212053shitted
shnorrer1143523shnorrer
shoaled113810973shoaled
shoaler102610083shoaler
shoat85633953shoat__
shoats94117083shoat_s
shocked174611813shocked
shocker163411433shocker
shoe75933443sho__e_
shoed95723013sho__ed
shoer84722163sho__er
shoes85429663sho__es
shoetree1146573shoetree
shogged13397963shogged
shogun1045713sho_gun
shone83725983sho_ne_
shooed103916083sho_oed
shooled115212663shooled
shoon84022013sho__on
shoot84235913shoot__
shooters112811583shooters
shooting122812863shooting
shoots94619363shoot_s
shopman14247263shopman
shoppe133110323shoppe_
shopped153512213shopped
shopper143312633shopper
shoppes143411393shoppes
shorans102812413shorans
shoring112820073shoring
shorl84720253shor__l
shorls94516203shor_ls
shortage1236313shortage
shortages1336513shortages
shortcut1344453shortcut
shorteners1345083shorteners
shortening1445303shortening
shorthand1643753shorthand
shorthead1644473shorthead
shorthorn1543993shorthorn
shortias1148093shortias
shortish1437423shortish
shortness1236733shortness
shot76150263sho_t__
shotgun1143003shotgun
shots84730853sho_t_s
shott85332193sho_t_t
shotting123012383shotting
shotts93614703sho_tts
shout85433173shout__
shouters113510623shouters
shouting122711793shouting
shouts94017723shout_s
shove114421043sho_ve_
shoved134214283sho_ved
shovel124611323sho_vel
shover124515993sho_ver
shoves124919423sho_ves
showed135016973sho_wed
shower124315113sho_wer
showier1339103showier
showman15257293showman
shown115216483sho__wn
shred98125613sh_r_ed
shrew119720173sh_r_ew
shriek134211103sh_riek
shrine94920053sh_rine
shriven13379653shriven
shrove125412233shrove_
shtetel1033943shtetel
shunted11339783shunted
shunter103611733shunter
shute84520353sh_ute_
shuted103913173sh_uted
shutes93518223sh_utes
shutter103712143shutter
shyster13116563shyster
siren54525823s_ir_en
sitten64113823s_itten
skirted12388613skirted
skirter11338483skirter
skort94925643skort__
skorts104211303skort_s
slotted84613883slotted
slotter73314453slotter
sloven9389633slo_ven
smarted105012613smarted
smartens10286663smartens
smarter94113133smarter
smitten936693smitten
smoothen13204963smoothen
smote75820283smo_te_
snooted84213283snooted
snore55424953snor_e_
snored74819543snor_ed
snorer64316763snor_er
snores64324323snor_es
snorkel1135423snorkel
snort54833753snort__
snorters83410583snorters
snorting92613373snorting
snorts64116503snort_s
snouted84311343snouted
snowmen12246153snowmen
socmen1039193s_ocmen
sodden84011513s_odden
softens10347623s_oftens
softer94015313s_ofter
sooted73922593s_ooted
sorbed94916523s_orbed
sorbent92915243s_orbent
sorbet83924083s_orbet
sore47059533s_or_e_
sored66141783s_or_ed
sorel56231443s_or_el
sorer56236593s_or_er
sores55454283s_or_es
sorites73825243s_orites
sorn46641063s_or__n
sorned74820043s_orned
sorner64720393s_orner
sorrel6413553s_orrel
sort46264813s_ort__
sorta57125413s_ort_a
sorters74221133s_orters
sortie63621993s_ortie
sortied83314103s_ortied
sorties74126403s_orties
sorting83221813s_orting
sorts54536663s_ort_s
sotted74121403s_otted
souter64225923s_outer
spartan948333spartan
spirted103913073spirted
spoken124610003spo_ken
spore75428593spor_e_
spored94821793spor_ed
spores84726613spor_es
sporran936743sporran
sport75935983sport__
sporters103714063sporters
sportier102010053sportier
sportif1238803sportif
sporting112415463sporting
sports84619183sport_s
sportsmen1343543sportsmen
sporty115112493sport_y
spotted103713143spotted
spotter94514883spotter
spouted103412263spouted
spouter94213223spouter
spurted103111973spurted
spurter94013003spurter
started84217323started
starter73817883starter
stolen64315063sto_len
stollen747583stollen
store56333813stor_e_
stored75524213stor_ed
storer64721673stor_er
stores65533663stor_es
storey95217613stor_ey
storied8515163storied
stories7324273stories
stormed1039043stormed
stotin63215063sto_tin
stotted83511423stotted
stoutens8255273stoutens
stouter74012053stouter
sweeten10267313sweeten
swollen1034263swollen
swordmen1443003swordmen
swore84920823swor_e_
sworn86115313swor__n
swotted11398713swotted
swotter10399473swotter
syren85216743s_yr_en
thirteen1143303thirteen
thorite10313443thorite_
thorites11312393thorites
thorn85318703thor__n
thorned11479403thorned
thoron94713903thor_on
thorpe113610093thorpe_
thorpes125010353thorpes
torte55431703_torte_
tortes64826053_tortes
vortex1635923_vortex
wheaten1336403wheaten
whiten124111923wh_iten
whore116018043whor_e_
whored135512123whor_ed
whores125617103whor_es
whorled14366903whorled
whort114623693whort__
whortle13335943whortle
whortles14306743whortles
whorts125111433whort_s
worsen95513873_worsen

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273826.15621771.8
3Display Results3823820.1263031.7
 (SQL Overall)1786913826.68826718.2
 
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.