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

351 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
shorties1141458(None) 
shortias1148091shortias
shortie10411341shortie_
sorties74126401s_orties
chortles133611322chortles
dhooties1237642dhooties
forties104323862_forties
hogties112813992_hogties
hotties103016962_hotties
scotties1039752scotties
shanties113116582shanties
sharpies13411222sharpies
shelties111111382shelties
sherries111812892sherries
shirtier1137942shirtier
shirtiest1239322shirtiest
shoddies1336052shoddies
shores94830412shor__es
shortages1336512shortages
shorted113614402short_ed
shorten103511412short_en
shortens11288992shortens
shorter103515502short_er
shortest11310782short_est
shortia1048192shorti_a
shorting122514802shorting
shortish1437422shortish
shortness1236732shortness
shorts95321742short__s
shotes95321912sho_t_es
showtimes1743652showtimes
smarties10312872smarties
softies103414612s_ofties
sorites73825242s_orites
sortie63621992s_ortie_
sortied83314102s_ortied
sportier102010052sportier
sportiest111711022sportiest
stories7324272stor_ies
thirties1139722thirties
thorites11312392thorites
whortles14306742whortles
agouties9337693agouties
amortise10428513amortise
amortises1178823amortises
amortizes2087283amortizes
bhisties1339003bhisties
booties94124613_booties
bortzes1838223_bortzes
chanties132615803chanties
charities14312743charities
charlies133414233charlies
cherries131812983cherries
chertier1387873chertier
chertiest1438793chertiest
chitties13310773chitties
chlorites142311963chlorites
chorales133712883chorales
chores114828023chor__es
chorines132917253chorines
choroids1438693choroids
chorten122811303chort_en
chortens13308793chortens
chortle124210443chortle_
chortled14326613chortled
chortler13336843chortler
chortlers14305663chortlers
choruses1339983choruses
chowtimes1943143chowtimes
coonties10513803coonties
cooties93725733_cooties
corbies113520123_corbies
corries94026793_corries
cortices12615013_cortices
cortins92421333_cortins
dhoolies1246963dhoolies
dhootie1136473dhootie_
dhootis1135683dhooti_s
dhotis1038973dho_ti_s
dhurries1255583dhurries
diorites9313523diorites
dirties83119383_dirties
dories75232363_dor_ies
footies103721543_footies
fortes95327183_fort_es
fortis95418613_forti_s
gharries12318203gharries
ghostier1235383ghostier
ghostiest1336543ghostiest
ghoulies1235393ghoulies
glories81915913glor_ies
hardies114923233_hardies
harpies123818313_harpies
harries103525493_harries
hearties11315413hearties
herries104025073_herries
hertzes1938303_hertzes
hoagies112811993_hoagies
hobbies143813343_hobbies
hogtie102711773_hogtie_
hogtied12226653_hogtied
holies94630033_ho_lies
hollies103420813_hollies
homies114524723_ho_mies
hongies112716473_hongies
honkies143015143_honkies
hoodies113419833_hoodies
hookies144017443_hookies
hootier104915353_hootier
hootiest113115643_hootiest
hordes104921633_hor_des
hornier103012463_hornier
horniest112814043_horniest
horses94729343_hor_ses
horsier103013243_horsier
horsiest112513263_horsiest
horstes104516113_horstes
hostiles11312213_hostiles
hottie92514383_hottie_
hourlies1138343_hourlies
howdies142911953_howdies
hurdies114015663_hurdies
hurlies103315333_hurlies
hurries103919653_hurries
hurtles103913753_hurtles
ivories10310713ivor_ies
lories64933043_lor_ies
lorries74518343_lorries
mortices12711563_mortices
mortise9713533_mortise
mortises10713613_mortises
norites74018803_norites
orgies72316093__orgies
parties93230863_parties
phonies123717513pho_nies
phorates13413043phorates
phoresies1447993phoresies
photics142810483pho_tics
plotties103111413plotties
porgies103017003_porgies
porkies133416493_porkies
posties93128813_posties
potties93723543_potties
prosties101421193prosties
safeties1139163safeties
salties73725773s_alties
sanities81219773sanities
sauries72821623saur_ies
savories11311273savor_ies
scanties103215423scanties
scorches15189143scorches
scores84725923scor__es
scorifies1448023scorifies
scotias939753sco_tias
scottie937463scottie_
scries85226823s_cr_ies
scurries102911483scurries
scurvies13248123scurvies
sentries81318053sentries
series64540973s_er_ies
serotines9312073serotines
serries73925353s_erries
shammies15259683shammies
shandies122714103shandies
shannies113411253shannies
shantihs14276213shantihs
shantis103313103shanti_s
shares95236413shar__es
sharias102516003shar_ias
sharifs13279903shar_ifs
sharpie1238393sharpie_
shavies134213203sh_avies
sheathes14610193sheathes
sheenies111411543sheenies
sheltie10109913sheltie_
sherifs13299683sher_ifs
sherris10168803sherri_s
sherrises12156863sherrises
shies86136553sh___ies
shiftier1436343shiftier
shiftiest1537363shiftiest
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shires95225573shir__es
shirting123213613shirting
shirtings13276603shirtings
shirtless12266413shirtless
shirts94918343shirt__s
shittier1137313shittier
shittiest1238333shittiest
shittims1344423shittims
shoalier1137073shoalier
shoaliest1238503shoaliest
shoats94117083shoat__s
shoddier1334213shoddier
shoddiest1434753shoddiest
shoes85429663sho___es
shoetree1146573shoetree
shoetrees1244353shoetrees
shogis103810943sho_gi_s
shojis16348493sho_ji_s
shooflies1544143shooflies
shooter103013993shoot_er
shooters112811583shooters
shooting122812863shooting
shootings13266063shootings
shoots94619363shoot__s
shoppes143411393sho_ppes
shorans102812413shor_ans
shore85432653shor__e_
shored105723653shor__ed
shoreless1236633shoreless
shorelines1346143shorelines
shoring112820073shor_ing
shorings12269483shorings
shorls94516203shor__ls
short85040533short___
shortage1236313shortage
shortcakes1943023shortcakes
shortcut1344453shortcut
shortcuts1442513shortcuts
shortened1345663shortened
shortener1245773shortener
shorteners1345083shorteners
shorthairs1672813shorthairs
shorthead1644473shorthead
shortheads1743813shortheads
shortlist1246683shortlist
shortlists1344083shortlists
shortly13387573short_ly
shortwaves1942563shortwaves
shorty124313203short__y
shote85526103sho_t_e_
shots84730853sho_t__s
shotted113912403sho_tted
shotten10288463sho_tten
shotting123012383shotting
shotts93614703sho_t_ts
shouted113911553shout_ed
shouter103213083shout_er
shouters113510623shouters
shouting122711793shouting
shouts94017723shout__s
shoves124919423sho__ves
showier1339103sho_wier
showiest1438783sho_wiest
showtime1643773showtime
shriek134211103sh_r_iek
shrieks14377673sh_r_ieks
shrikes144412393sh_rikes
shrines104618693sh_rines
shris84221453sh_r_i_s
shrives134416173sh_rives
shtiks13297833sh__tiks
shutes93518223sh_ut_es
shuttles1136553shuttles
shvartzes2442103shvartzes
sixties14310973s_ixties
skerries12168673skerries
skorts104211303skort__s
slurries82710413slurries
smartie9310173smartie_
smoothes13218543smoothes
smoothies1456133smoothies
snootier8278383snootier
snootiest9178753snootiest
snores64324323snor__es
snorted83813493snort_ed
snorter74412663snort_er
snorters83410583snorters
snorting92613373snorting
snorts64116503snort__s
snottier8217383snottier
snottiest9167973snottiest
snoutier8206973snoutier
snoutiest9178253snoutiest
soddies92312853s_oddies
softie93312483s_oftie_
somites94219123s_omites
sonnies7315223s_onnies
sonorities10910653sonorities
soothes103917113s_oothes
sootier73916613s_ootier
sootiest84016753s_ootiest
sophies12314613s_ophies
sopites93817173s_opites
sordines92414073s_ordines
sores55454283s_or__es
sororities10109193sororities
soroses73117483s_oroses
sorrier72313733s_orrier
sorriest8413883s_orriest
sorted74523713s_ort_ed
sorter64425093s_ort_er
sorters74221133s_orters
sorting83221813s_orting
sorts54536663s_ort__s
spoonies101911753spoonies
spores84726613spor__es
sported104015433sport_ed
sporter93616553sport_er
sporters103714063sporters
sportif1238803sporti_f
sportily1337733sportily
sportiness1278233sportiness
sporting112415463sporting
sportive1348333sportive
sports84619183sport__s
sporules1037703sporules
spottier10207313spottier
spottiest11177683spottiest
sprites94220333s_prites
spurries102311323spurries
spurtles1037783spurtles
startles82111963startles
sties55132983s___ties
stogies8413693sto_gies
stoolies8311083stoolies
storages9311103storages
storaxes1536883storaxes
stores65533663stor__es
storied8515163stor_ied
stormier1036103stormier
stormiest1137003stormiest
stotins73213873sto_tins
sturdies92110273sturdies
sureties8316583sureties
sweeties11159723sweeties
theories11311593theor_ies
thoraces13118943thoraces
thoraxes1896363thoraxes
thorias102312053thor_ias
thorite10313443thorite_
thornier1135323thornier
thorniest1236483thorniest
thorpes125010353thor_pes
tories65435883_tor_ies
tortes64826053_tort_es
vortices1369123_vortices
wherries14179023wherries
whirlies14167373whirlies
whirries14136693whirries
whities133113253wh_ities
whoopies16267373whoopies
whores125617103whor__es
whortle13335943whortle_
whorts125111433whort__s
worries104117133_worries
worthies14310283_worthies
zloties1639913zlo_ties

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.406440125.6
2DLD Change Limit1461623516.67021913.3
3Display Results3513510.1402507.1
 (SQL Overall)1786913517.21624763.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.