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 “upward” 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
upward1214716(None) 
upwards13135961upwards
award97118042_award
coward12411672coward
inward10310332inward
onward1039052onward
outward11811402outward
pard76441322_p_ard
reward106017642reward
sunward1137652sunward
sward94221462_sward
toward10311062toward
unwary1239822unwary
updart9310742updart
upgird10103932upgird
uphoard1344572uphoard
upland938862upland
upwaft1444942upwaft
upwardly1742792upwardly
upwind12255822upwind
vaward13498722vaward
ward86542252__ward
aboard9312613aboard
afeard1058263afeard
airward1148133airward
apart74330673ap_art
apiary113910383apiary
aswarm11107913aswarm
awards107113453_awards
aware86420023_aware
awkward1843183awkward
bard75648863__bard
bayard124411663bayard
beard86024963_beard
bedward1497473bedward
beware11313713beware
bewared13310113bewared
board85523003_board
boyard125411283boyard
briard94311293briard
bulwark1645213bulwark
bustard10389723bustard
buzzard1844273buzzard
byword1535053byword
canard9314763canard
card710245873__card
chard116124743_chard
cowards1339613cowards
cupboard1544253cupboard
custard10389973custard
dewar95817733dewar_
dewars105117073dewars
dotard839053dotard
dullard936603dullard
dwarf126015243_dwarf
echard1249223echard
fard85639063__fard
forward1438293forward
froward1436673froward
guard74415543_guard
guisard954203guisard
gurnard944773gurnard
hard85443503__hard
hayward1736413hayward
hazard1938403hazard
heard95222753_heard
hoard94918313_hoard
holard10410573holard
inwards1138343inwards
izzard15135243izzard
jowar155211433jowar_
jowars16369653jowars
lard56742003__lard
leeward1135783leeward
liard65418593_liard
lizard16369233lizard
lyard95113213_lyard
manward1349093manward
mazard1838763mazard
mustard10359533mustard
nard56634453__nard
onwards1137173onwards
outwar91011513outwar_
outwards1299123outwards
outwars10912793outwars
pad68057323_p_a_d
paid75737483_p_aid
par57467023_p_ar_
para65242173_p_ara
pardi85723953_p_ardi
pards85634333_p_ards
pardy115523953_p_ardy
pare66760843_p_are
pared86946763_p_ared
park105237493_p_ark
parr65731153_p_arr
pars67560793_p_ars
part65967463_p_art
pawed115725613_pawed
pear69745233_pear_
pearl75324463_pearl
pears75138613_pears
peart76440753_peart
petard95013803petard
plaid85118303_plaid
regard85215773regard
retard75018933retard
rewards114813993rewards
rewarm115913493rewarm
reword106321413reword
ritard74812083ritard
sard55344243__sard
seaward1148183seaward
sewar85421103sewar_
sewars94018633sewars
shard96125963_shard
skyward1843863skyward
sowar85821343sowar_
sowars94318013sowars
spaed85522273sp_aed
spar65433303sp_ar_
spare75135563sp_are
spared95427493sp_ared
sparid94016933sp_arid
spark114920893sp_ark
spars75431543sp_ars
spear75821063spear_
speared104314423speared
spears84019473spears
steward1138063steward
sunwards1236443sunwards
swards105415133_swards
sware85828213_sware
swarf115324653_swarf
swarm106218843_swarm
swart86234643_swart
sword95214123_sword
tabard9313333tabard
thwart12311683thwart
towards1138783towards
uakari1046863uakari
ulnad65611453ulna_d
ulnar56013983ulnar_
unarm7314453u_narm
unary8315993u_nary
unaware1038033unaware
unawed103914903unawed
unbar71913613unbar_
unbars82113033unbars
ungird887973ungird
unguard955093unguard
unhand10410383unhand
unheard1136943unheard
unitard838003unitard
unlaid7311753unlaid
unpaid939473unpaid
unsaid7411833unsaid
untoward1243193untoward
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwaxed18308393unwaxed
unweary1335843unweary
unwed94114873unw_ed
unwind102610543unwind
unworn93411333unworn
unwrap11126323unwrap
upas68322383up_a_s
upbear1096493upbear_
upbears1195423upbears
upbind11246313upbind
upbore10247883upbore
upbraid1244973upbraid
upcast102710093upcast
upcurl1034963upcurl
updarted1244313updarted
updarts1034203updarts
update93810293update
updated11369423updated
updry1135483up_dry
upend85011043up_end
upfold12124953upfold
upgaze1833543upgaze
upgazed2033423upgazed
upgirds11103073upgirds
upgirt9117263upgirt
upgrade11215823upgrade
upheld12115563upheld
uphoards1443763uphoards
uphold12126903uphold
uplands1036943uplands
upload9257783upload
upped103715163up_ped
upper93714263upper_
uppers102912293uppers
uprate83916543uprate
uprated103213323uprated
uprear8168793uprear_
upreared1137073upreared
uprears9107493uprears
uproar8106933uproar_
uproars986453uproars
upsend9356883upsend
upsoar8105683upsoar_
upsoared11154353upsoared
upsoars985413upsoars
upstand1045343upstand
upstare9158683upstare
upstared11156573upstared
upstart9159753upstart
uptake1236963uptake
uptalk1234653uptalk
uptear896783uptear_
uptears9106453uptears
uptore8279453uptore
uptorn8268093uptorn
upturn8286243upturn
upwafted1742193upwafted
upwafts1541943upwafts
upwell11285803upwell
upwinds13224223upwinds
urare56322553u_rare
urari54619963u_rari
urd46427053u___rd
vanward1456943vanward
vawards14457573vawards
visard103910123visard
vizard19458853vizard
wad77053893__wa_d
wand85833883__wand
war67262423__war_
wards97734403__wards
ware76254723__ware
wared96339873__wared
wark115737773__wark
warm95935673__warm
warn75239323__warn
warp95635003__warp
wars78659803__wars
wart77866083__wart
wary106740013__wary
wayward1736053wayward
wizard19377713wizard
word89832003__word
yard85633253__yard

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162455.31321215.1
3Display Results2452450.0932634.4
 (SQL Overall)1786912455.79630830.1
 
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.