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

261 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
swans8462501(None) 
sans45153351s_ans
scans74625101scans
sewans95215901sewans
sowans94215891sowans
spans74528731spans
swabs105817271swabs
swags94921251swags
swains94513951swains
swan76631311swan_
swang95519721swang
swank125318231swank
swanks134811561swanks
swaps104819201swaps
swats85726861swats
sways115518461sways
wans76452261_wans
alans55636172alans
awns75324432aw_ns
azans146516882azans
bans66555132_bans
beans75734692beans
brans75437432brans
bwana10310242bwana
bwanas1157442bwanas
cans65050842_cans
clans75031012clans
cyans105714812cyans
dans56748142_dans
dawns95916592dawns
deans66131392deans
dewans105215142dewans
diwans105110372diwans
elans55527752elans
fans76247362_fans
fawns115914262fawns
flans85327972flans
glans65125832glans
gowans105512292gowans
grans64832542grans
guans64419442guans
hwan105716892hwan_
jawans1657842jawans
jeans126022112jeans
khans124615172khans
koans95818622koans
lawns85215422lawns
leans55536252leans
loans56026462loans
mans66354532_mans
means75831222means
moans74624362moans
naans55815252naans
nans46139392_nans
owns76819582ow_ns
pans65855722_pans
pawns108818132pawns
peans75437642peans
pians75126962pians
plans75731272plans
roans54926442roans
rowans95715342rowans
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
sains55639972sains
sals46851672s_als
sand55338462s_and
sands65228582s_ands
sane45954332s_ane
sanes55649072s_anes
sang55441222s_ang
sank85236822s_ank
saps65346372s_aps
sarans64224432sarans
sass45035622s_ass
sawn75428162sawn_
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419952scads
scags85520972scags
scams94423972scams
scan65530452scan_
scant79735072scant
scants85219722scants
scars75433532scars
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
seawans10379942seawans
sedans74816092sedans
sewan85921292sewan_
sewars94018622sewars
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shank125422192shank
shanks135315582shanks
sharns95516982sharns
shaws116226262shaws
shays116021432shays
shins85131042shins
shuns85018142shuns
shwas116415102shwa_s
sials54227242sials
signs65516322signs
sins46755272s_ins
skags104316072skags
skank84415582skank
skanks94710832skanks
skas85325712ska_s
skats94621532skats
skeans104512912skeans
skins94723462skins
slabs75322642slabs
slags66525902slags
slams74927902slams
slang66324022slang
slangs75615342slangs
slank95822772slank
slant55238702slant
slants64819082slants
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
snags64421312snags
snaps74719562snaps
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soars54732512soars
solans64122492solans
somans84619302somans
sons46049552s_ons
sorns55028412sorns
sowars94318002sowars
sowens93613152sowens
spaes76029972spaes
spams94922192spams
span65234662span_
spang84919732spang
spank115919572spank
spanks124514122spanks
spars75431542spars
spas67036722spa_s
spats75031382spats
spawns11577922spawns
spays105520512spays
speans85417142speans
spins75327982spins
stabs76221382stabs
stags66226742stags
stains64923652stains
stand65923282stand
stands75118052stands
stane55933002stane
stanes64933402stanes
stang66424682stang
stangs75018162stangs
stank95823302stank
stanks104917702stanks
stars55836572stars
stats55933362stats
stays86022022stays
stuns54719492stuns
sunns55017352sunns
suns45841902s_uns
swab96825312swa_b
swag87526732swa_g
swage94919562swage
swages104417072swages
swail86217162swail
swails94913122swails
swain84919052swain
swale85221592swale
swales93920762swales
swam96329982swa_m
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamps135910262swamps
swamy136714402swamy
swanky16447972swanky
swanny12336822swanny
swap95925432swa_p
sward94221462sward
swards105415132swards
sware85828212sware
swarf115324652swarf
swarfs125612062swarfs
swarm106218832swarm
swarms116112162swarms
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swaths125312642swaths
sway107128232swa_y
swears94114072swears
sweats94814612sweats
swigs96213662swigs
swims105514142swims
swine85625302swine
swing96124842swing
swings104714452swings
swink125116352swink
swinks134610652swinks
swiss86712902swiss
swobs104910892swobs
swoons94511142swoons
swops105913972swops
swots85518422swots
swouns9358242swouns
swung95610562swung
tans46154812_tans
trans54933042trans
twaes86513662twaes
twains95811182twains
twang94511852twang
twangs10358092twangs
twas76824082twa_s
twats86616602twats
twins85118982twins
ulans54921302ulans
vans76236722_vans
wabs97337232_wabs
wads87343142_wads
waes76048602_waes
wags86140552_wags
wains86930862_wains
wan66761932_wan_
wand85833872_wand
wands96425482_wands
wane76344712_wane
wanes85040882_wanes
wank115632502_wank
wanks126124482_wanks
want76156162_want
wants87932212_wants
wany106432352_wany
waps96642082_waps
warns87231002_warns
wars78659802_wars
was68767562_wa_s
wats77555882_wats
waws106834902_waws
ways107737952_ways
weans85326742weans
wens76337932_wens
wins75949172_wins
wons74942042_wons
wyns105717032_wyns
yawns114213272yawns
yeans86624882yeans
yuans84613322yuans

Search took 5 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 Filter178691538000.1701051123.5
2DLD Change Limit538002613.59614961.1
3Display Results2612610.1401864.3
 (SQL Overall)1786912613.90645747.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.