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

192 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
onwards113717(None) 
inwards1138341inwards
onward1039051onward_
awards107113452_awards
cowards1339612cowards
downwards1743832downwards
forwards1537042forwards
innards837152innards
inward10310332inward_
manwards1447612manwards
moonwards1574202moonwards
nards65928462_n_ards
nonwars10109002nonwar_s
nonwords1247462nonwords
outwards1299122outwards
poniards1145822poniards
rewards114813992rewards
sunwards1236442sunwards
swards105415132_swards
towards1138782towards
upwards13135962upwards
vawards14457572vawards
wards97734402__wards
anears63717183anear_s
award97118043_award_
bards87139643__bards
bayards13379683bayards
beards94116673_beards
bedwards1596393bedwards
bewares12313373bewares
boards94616933_boards
bollards11339153bollards
bombards1536493bombards
boneyards1584623boneyards
boyards13399323boyards
briards10398553briards
bywords1634283bywords
canards10311203canards
cards85137933__cards
chards125119733_chards
collards113310193collards
concords1358593concords
costards113510793costards
coward12411673coward_
dewars105117073dewar_s
dotards937253dotards
downward1644443downward_
dwarfs13436273_dwarfs
echards1337963echards
engirds995053engirds
enwinds11255553enwinds
enwraps1284833enwraps
fards96629843__fards
forward1438293forward_
foulards12266463foulards
frontwards1742343frontwards
gnarls74210773gn_arls
gnarrs7407663gn_arrs
gnars66718853gn_ar_s
goliards1045133goliards
gonads84511733gon_a_ds
guards84611573_guards
hards96435653__hards
haywards1845873haywards
hazards2037463hazards
hoards104912623_hoards
holards1148433holards
homewards1844513homewards
inarms8410093in_arms
inboards1145843inboards
infares10313023infares
inlands838783inlands
invars9310003invar_s
inwalls1037283inwalls
inwardly1543783inwardly
inwinds11216273inwinds
inwraps12105253inwraps
ironwares1244553ironwares
izzards16143963izzards
jowars16369653jowar_s
knars94416113kn_ar_s
kneads11357093knea_ds
landwards1445503landwards
laniards967313laniards
lanyards1266393lanyards
lards65331863__lards
leewards1244983leewards
liards75212613_liards
lizards17427613lizards
loanwords1343943loanwords
mansards1148013mansards
manward1349093manward_
mazards1937703mazards
monads94515303mon_a_ds
monarda1046613mon_arda
monardas1145713mon_ardas
moonward1474473moonward_
narcs76122023_n_arcs
nard56634453_n_ard_
nares55544153_n_ares
naris55735293_n_aris
narks96026033_n_arks
nears55529423_near_s
nerds65719253_n_erds
nomads94711603noma_ds
nonarts7311303nonarts
nonhardy1544333nonhardy
nonwar9159423nonwar__
nonword1149153nonword_
noways12127733nowa_ys
nurds65518523_n_urds
oars46846033o__ar_s
octads987333octa_ds
onboard1046503onboard_
onlays9398713onla_ys
onloads8246673onloads
orchards1445913orchards
oreads73915773orea_ds
ottars64112223ottar_s
ouraris73512933ouraris
outadds936203outadds
outward11811403outward_
outwars10912793outwar_s
ovenwares1543973ovenwares
owners94210703owner_s
oxcarts1634313oxcarts
oxfords1842893oxfords
pards85634333__pards
petards104311153petards
pochards1646853pochards
pollards11299523pollards
poniard1037583poniard_
poulards11288233poulards
regards94112563regards
retards85015003retards
reward106017633reward_
rewarms12439593rewarms
rewords115413973rewords
ritards8439943ritards
sards64736183__sards
seawards1237203seawards
sewars94018623sewar_s
shards104319173_shards
skywards1943373skywards
snares65329033sn_ares
snarfs95113423sn_arfs
snarks104815733sn_arks
snarls64016873sn_arls
sonars64818973son_ar_s
sowars94318013sowar_s
stewards1236383stewards
sunward1137653sunward_
sward94221463_sward_
swarfs125612063_swarfs
swarms116112173_swarms
swords104510803_swords
tabards10310383tabards
tankards1366253tankards
tanyards1276183tanyards
thwarts1345023thwarts
tinwares1137913tinwares
tonearms1044713tonearms
toward10311063toward_
unarms839243un_arms
unawares1137053unawares
unbars82113033unbar_s
ungirds9105303ungirds
unguards1053993unguards
unhands1137773unhands
unitards945623unitards
unwary1239823unwar_y
unwinds11286733unwinds
unwraps1255513unwraps
upward12147163upward_
vanward1456943vanward_
vaward13498723vaward_
visards11328153visards
vizards20377263vizards
wads87343143__wa_ds
wands96425483__wands
ward86542253__ward_
wares88250583__wares
warks127932403__warks
warms107726853__warms
warns87231003__warns
warps107126423__warps
wars78659803__war_s
warts814840403__warts
windwards1764513windwards
wizards20326403wizards
words95425073__words
yards95324613__yards

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271926.87619492.0
3Display Results1921920.0762526.3
 (SQL Overall)1786911927.10825139.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.