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 “swards” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
swards10541513(None) 
awards107113451awards
sards64736181s_ards
shards104319171shards
sward94221461sward_
swarfs125612061swarfs
swarms116112171swarms
swords104510801swords
wards97734401_wards
award97118042award_
bards87139642_bards
beards94116672beards
boards94616932boards
cards85137932_cards
chards125119732chards
cowards1339612cowards
dwarfs13436272dwarfs
fards96629842_fards
guards84611572guards
hards96435652_hards
hoards104912622hoards
inwards1138342inwards
lards65331862_lards
liards75212612liards
nards65928462_nards
onwards1137172onwards
pards85634332_pards
rewards114813992rewards
saids65328852s_aids
sands65228582s_ands
sard55344242s_ard_
saris54544952s_aris
sarks96632462s_arks
sarods74918572s_arods
saros55238062s_aros
scads85419962sca_ds
scalds94813692scalds
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scars75433532scar_s
scarts85321492scarts
sears54744912sear_s
seawards1237202seawards
sewars94018632sewar_s
shads95124482sha_ds
shairds11216262shairds
shard96125962shard_
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
sherds105614722sherds
skalds11437832skalds
skywards1943372skywards
smarms105712532smarms
smarts86218002smarts
snares65329032snares
snarfs95113422snarfs
snarks104815732snarks
snarls64016872snarls
soars54732512soar_s
sords64527802s_ords
sowars94318012sowar_s
spares84834552spares
sparids103512122sparids
sparks124616362sparks
spars75431542spar_s
stands75118052stands
stares66038752stares
stars55836572star_s
starts65423122starts
stewards1236382stewards
sunwards1236442sunwards
surds65624662s_urds
swabs105817272swa_bs
swages104417072swages
swags94921252swa_gs
swails94913122swails
swains94513952swains
swales93920762swales
swamis114212292swamis
swamps135910262swamps
swanks134811562swanks
swans84625012swa_ns
swaps104819202swa_ps
swaraj1636022swaraj
swarded1238152swarded
sware85828212swar_e
swarf115324652swar_f
swarm106218842swar_m
swart86234642swar_t
swarth126012082swarth
swarths13537322swarths
swarty125812382swarty
swaths125312642swaths
swats85726862swa_ts
sways115518462swa_ys
swears94114072swear_s
swirls94010132swirls
sword95214122sword_
towards1138782towards
upwards13135962upwards
vawards14457572vawards
wads87343142_wa_ds
wands96425482_wands
ward86542252_ward_
wares88250582_wares
warks127932402_warks
warms107726852_warms
warns87231002_warns
warps107126422_warps
wars78659802_war_s
warts814840402_warts
words95425072_words
yards95324612_yards

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511162.18637763.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911162.57569394.6
 
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.