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

245 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
shortly1338757(None) 
shorty124313201short_y
chortle124210442chortle
ghostly14355102ghostly
hostly124210862_hostly
hotly115815482_ho_tly
portly114713402_portly
sharply15406832sharply
shirty124312562shirt_y
shoaly124010772sho_aly
shoofly1634352shoofly
shorl84720252shor_l_
shorls94516202shor_ls
short85040532short__
shorted113614402shorted
shorten103511412shorten
shorter103515502shorter
shortia1048192shortia
shortie10411342shortie
shorts95321742short_s
showily1636222showily
smartly12497432smartly
softly12457762s_oftly
sorely94618012s_orely
sportily1337732sportily
sporty115112492sport_y
stoutly1035832stoutly
whortle13335942whortle
alertly1046793alertly
borty105522833_bort_y
charily15310283charily
cherty144612473chert_y
choral115118493choral_
chorale124313353chorale
chorally1638103chorally
chorals124614113chorals
chorten122811303chorten
chortled14326613chortled
chortler13336843chortler
chortles133611323chortles
costly114012333_costly
courtly1256923courtly
curtly1149283_curtly
dhooly13457143dho_oly
dorty96220813_dort_y
forty114824273_fort_y
ghastly14354563ghastly
ghosty13467213ghost_y
gorily10612503_gorily
hardly135112833_hardly
hoarily1338973_hoarily
hokily16409093_hokily
holily123612953_holily
holly114824433_ho_lly
holy106333433_ho__ly
homely145313173_homely
homily144712333_homily
hooly115022223_ho_oly
hooty115022443_hoot_y
horal86328683_horal_
horary12310383_horary
hornily1338283_hornily
horny115619623_hor_ny
horsey125115403_horsey
horsily1338843_horsily
horsy116318393_hor_sy
hourly12369623_hourly
hurly115819293_hur_ly
hurtle93512943_hurtle
inertly1038543inertly
lordly1038753_lordly
mostly113110943_mostly
overtly13268983overtly
partly116315473_partly
peartly1267453peartly
pertly115312553_pertly
phonily1537103phonily
phoresy1534653phoresy
poorly1137893poor_ly
saintly1039343saintly
savorily1445043savorily
scantly12419553scantly
scarily12311703scarily
schorl1179813schor_l_
schorls1248353schor_ls
scorify1535203scorify
secretly1345183secretly
shadfly1733783shadfly
shadily1437723shadily
shakily1736903shakily
shaly114322863sh__aly
shantey134210043shantey
shanty124715123shant_y
shapely1536893shapely
sharny124711833shar_ny
sharpy145211033shar_py
sheerly13337703sheerly
shelly124414473sh_elly
shelty124011553shelt_y
sherry124510413sher_ry
shiftily1744553shiftily
shifty15409263shift_y
shily115222013sh__ily
shingly143210813shingly
shinily13268933shinily
shirt84533903shirt__
shirts94918343shirt_s
shitty124110063sh_itty
shoal83920273sho_al_
shoals94215793sho_als
shoat85633953shoat__
shoats94117083shoat_s
shoddily1643573shoddily
shoddy1434543sho_ddy
shool84523153sho_ol_
shools94919013sho_ols
shoot84235913shoot__
shooter103013993shooter
shoots94619363shoot_s
shopboy1743803shopboy
shoptalk1743573shoptalk
shoran94016043shor_an
shorans102812413shorans
shore85432653shor__e
shored105723653shor_ed
shores94830413shor_es
shoring112820073shoring
shorn85722183shor__n
shortage1236313shortage
shortcut1344453shortcut
shortens11288993shortens
shortest11310783shortest
shortfall1542873shortfall
shortias1148093shortias
shorties11414583shorties
shorting122514803shorting
shortish1437423shortish
shortlist1246683shortlist
shot76150263sho_t__
shote85526103sho_t_e
shotes95321913sho_tes
shots84730853sho_t_s
shott85332193sho_t_t
shotted113912403shotted
shotten10288463shotten
shotts93614703sho_tts
should1038033sho_uld
shout85433173shout__
shouted113911553shouted
shouter103213083shouter
shouts94017723shout_s
shovel124611323shovel_
shovels13378393shovels
showery16437243showery
showy145714013sho__wy
shrill94712303sh_rill
shrilly13318563shrilly
shtetl936443shtetl_
shtetls1034583shtetls
shuttle1046103shuttle
shyly144811573sh__yly
sightly14408273sightly
skort94925643skort__
skorts104211303skort_s
slantly10399323slantly
slowly1237153slo_wly
smarty115013793smart_y
smokily1635373smokily
smoothly16203643smoothly
smoothy15205083smoothy
snarly93815003snar_ly
snootily1136253snootily
snooty94211513snoot_y
snort54833753snort__
snorted83813493snorted
snorter74412663snorter
snorts64116503snort_s
snottily1145553snottily
snotty9489203sno_tty
snouty9419953snout_y
snowily1336883snowily
softy115414483s_oft_y
solely93714213s_olely
sonly85718053s_o_nly
soothly13186923soothly
sootily101810523sootily
sooty84924843s_oot_y
sorel56231443s_orel_
sorels63921163s_orels
sorrily1039833sorrily
sorry84618253s_or_ry
sort46264813s_ort__
sorta57125413s_ort_a
sortably1338803s_ortably
sorted74523713s_orted
sorter64425093s_orter
sortie63621993s_ortie
sorts54536663s_ort_s
sourly93612213s_ourly
sparely123410673sparely
sparkly16348133sparkly
sporal82915453sporal_
sport75935983sport__
sported104015433sported
sporter93616553sporter
sportif1238803sportif
sports84619183sport_s
sporule937273sporule
spottily1335153spottily
spotty11448583spo_tty
spryly1435513s_pryly
spurtle937453spurtle
squatly1946433squatly
starkly14277033starkly
startle72511123startle
startsy10536703startsy
sternly1037853sternly
stonily1049433stonily
storey95217613stor_ey
stormily1345243stormily
stormy115510733stor_my
story86723033stor__y
subtly11249263s_ubtly
surely93816463s_urely
surly85124433s_ur_ly
swarthy16466373swarthy
swarty125812383swart_y
sweetly1335593sweetly
swiftly1633733swiftly
swirly12439253swir_ly
tartly96014023_tartly
thirdly1444633thirdly
thirty12378403thirt_y
thistly1395963thistly
thornily1444163thornily
thorny12509843thor_ny
thwartly1742703thwartly
whirly15448863whir_ly
wholly15366573who_lly
whorl114612453whor_l_
whorls124410163whor_ls
whort114623693whort__
whortles14306743whortles
whorts125111433whort_s
worthy15598803_worthy

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272457.53317792.0
3Display Results2452450.0932634.4
 (SQL Overall)1786912458.03222247.4
 
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.