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

189 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
vawards1445757(None) 
awards107113451_awards
vaward13498721vaward_
award97118042_award_
bayards13379682bayards
canards10311202canards
cowards1339612cowards
haywards1845872haywards
hazards2037462hazards
inwards1138342inwards
manwards1447612manwards
mazards1937702mazards
onwards1137172onwards
rewards114813992rewards
seawards1237202seawards
swards105415132_swards
tabards10310382tabards
towards1138782towards
upwards13135962upwards
vanward1456942vanward_
visards11328152visards
vizards20377262vizards
wards97734402__wards
acarids105312243_acarids
acarus8312193_acarus
afars85716513_afar_s
agars66120643_agar_s
alands75418373_alands
alarms85913053_alarms
avatars1036443avatar_s
awaits96411953_awaits
awakes135012473_awakes
awarded1236223_awarded
awardee1137563_awardee
awardees1243993_awardees
awarder1135893_awarder
awarders1245073_awarders
aware86420023_awar_e
backwards2147463backwards
bards87139643__bards
barwares13610093barwares
bastards113310313bastards
bawds116115493baw__ds
bayard124411663bayard_
bazars174613113bazar_s
beards94116673_beards
bedwards1596393bedwards
bewares12313373bewares
boards94616933_boards
boyards13399323boyards
briards10398553briards
bywords1634283bywords
cairds96411513ca_irds
canard9314763canard_
cards85137933__cards
chards125119733_chards
coward12411673coward_
damars93815003damar_s
dastards10278083dastards
dewars105117073dewar_s
dotards937253dotards
dwarfs13436273_dwarfs
eastwards1344253eastwards
echards1337963echards
farads104713273fara_ds
fards96629843__fards
forwards1537043forwards
gabbards1445753gabbards
gazars164811553gazar_s
guards84611573_guards
haars85620473ha_ar_s
haggards14366763haggards
halyards1576243halyards
hards96435653__hards
hawalas13348353hawalas
hayward1736413hayward_
hazard1938403hazard_
hoards104912623_hoards
holards1148433holards
innards837153innards
inward10310333inward_
izzards16143963izzards
jawans1657843jawa_ns
jowars16369653jowar_s
kabars124513953kabar_s
laggards11307053laggards
lahars94013163lahar_s
lairds74711613la_irds
landwards1445503landwards
laniards967313laniards
lanyards1266393lanyards
lards65331863__lards
lazars153812393lazar_s
leewards1244983leewards
liards75212613_liards
lizards17427613lizards
maars74621633ma_ar_s
makars124612633makar_s
malars85020683malar_s
mallards1138323mallards
mansards1148013mansards
manward1349093manward_
marauds1037553marauds
mazard1838763mazard_
mazzards1943943mazzards
misawards1563793misawards
naiads739013naia_ds
nards65928463__nards
navaids1134803navaids
navars92810573navar_s
nawabs1185063nawa_bs
onward1039053onward_
outwards1299123outwards
pards85634333__pards
pawers114818783pawer_s
petards104311153petards
placards1345813placards
radars71314673radar_s
rearwards1344803rearwards
regards94112563regards
retards85015003retards
reward106017643reward_
rewarms12439603rewarms
rewords115413983rewords
ritards8439943ritards
safaris101110663safaris
saggards11397493saggards
salads75316963sala_ds
samaras9312913samaras
sards64736183__sards
sataras7315063sataras
sawers94620163sawer_s
seaward1148183seaward_
seawares1139333seawares
sewars94018633sewar_s
shards104319173_shards
skywards1943373skywards
sowars94318013sowar_s
stewards1236383stewards
sunwards1236443sunwards
sward94221463_sward_
swarfs125612063_swarfs
swarms116112173_swarms
swords104510803_swords
tabard9313333tabard_
talars66021683talar_s
tamaris9413603tamaris
tankards1366253tankards
tanyards1276183tanyards
tatars64619793tatar_s
tawers94118603tawer_s
teawares1148083teawares
thwarts1345023thwarts
toward10311063toward_
uakaris1146633uakaris
unawares1137053unawares
upward12147163upward_
vacates12312833vacates
vagaries12310293vagaries
vagary1337333vagar_y
vairs85019133va_ir_s
valors93413773valor_s
vanguards1443273vanguards
vapors113812693vapor_s
varas86028193v__aras
vars75742073v__ar_s
varus85921183v__arus
vaws105527323vaw___s
velars93913723velar_s
viands1047813v_iands
vicars11712263vicar_s
visard103910123visard_
vizard19458853vizard_
vowers124317183vower_s
wads87343143__wa_ds
wands96425483__wands
ward86542253__ward_
wares88250583__wares
warks127932403__warks
warms107726853__warms
warns87231003__warns
warps107126423__warps
wars78659803__war_s
warts814840403__warts
wayward1736053wayward_
wizards20326403wizards
words95425073__words
yairds10448023ya_irds
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.406440125.6
2DLD Change Limit1340271897.14018771.3
3Display Results1891890.0633000.0
 (SQL Overall)1786911897.60923484.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.