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

300 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
scars7543353(None) 
cars67364761_cars
escars83913131escars
scabs94818641scabs
scads85419951scads
scags85520971scags
scams94423971scams
scans74625101scans
scar66434201scar_
scare75334461scare
scares85033001scares
scarf105427141scarf
scarfs114714681scarfs
scarp95724101scarp
scarps104718601scarps
scart76139771scart
scarts85321491scarts
scary105222591scary
scats75930601scats
scaurs85512041scaurs
sears54744911sears
soars54732511soars
spars75431541spars
stars55836571stars
acari75020282acari
acarus8312192acarus
afars85716512afars
agars66120642agars
ars37670932__ars
ascaris93613322ascaris
bars66564092_bars
bears75739042bears
boars75229602boars
cabs86739422_cabs
cads76144522_cads
cams87047282_cams
cans65050842_cans
caps87147892_caps
car59165562_car_
carb85143162_carb
carbs96031462_carbs
card710245872_card
cards85137932_cards
care66968372_care
cares77369182_cares
cark105539272_cark
carks115534212_carks
carl65144782_carl
carls77037422_carls
carn66245432_carn
carns75937562_carns
carp85139812_carp
carps96932252_carps
carr65434702_carr
carrs75730852_carrs
carse74934332_carse
cart66570342_cart
carts78946292_carts
cats66356342_cats
caws96036102_caws
cays95437672_cays
chars105936632chars
cors66656442_cors
curs65645542_curs
czars164812912czars
dears65736882dears
ears46356592_ears
escar74011992escar_
escarp10449002escarp
escarps11397372escarps
eschars1237172eschars
eskars10357592eskars
fears84829392fears
fiars86720832fiars
gars55750742_gars
gears64628692gears
gnars66718852gnars
guars65021042guars
haars85620472haars
hears86737372hears
hoars85925542hoars
izars145112932izars
jars117338352_jars
kbars114612602kbars
knars94416112knars
kyars124813962kyars
lars46956572_lars
lascars979012lascars
lears55938732lears
liars54723162liars
maars74621632maars
mars66261862_mars
nears55529422nears
oars46846032_oars
ocas66729632oca_s
pars67560792_pars
pears75138612pears
rears54739652rears
roars55622232roars
sabs66643742s_abs
sacks114228872sacks
sacra74516992sacra
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
sans45153352s_ans
saps65346372s_aps
sard55344242s_ard
sards64736182s_ards
sari45444042s_ari
saris54544952s_aris
sark84938972s_ark
sarks96632462s_arks
saros55238062s_aros
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scab85926712sca_b
scad75725762sca_d
scag76626892sca_g
scalars93711902scalars
scald84818122scald
scalds94813692scalds
scale74629142scale
scalers93817262scalers
scales84529312scales
scall74420372scall
scalls84218202scalls
scalp95217982scalp
scalps104315232scalps
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scamps125014172scamps
scan65530452sca_n
scant79735072scant
scants85219722scants
scape96921842scape
scapes105122262scapes
scarab10310062scarab
scarabs1137292scarabs
scarce104013632scarce
scared95227292scared
scarer84524602scarer
scarers94618502scarers
scarey115016982scarey
scarph13429602scarph
scarphs14437412scarphs
scarry116311182scarry
scarves124511622scarves
scat65848372sca_t
scatt76030092scatt
scatts85914662scatts
scaup95515992scaup
scaups105411932scaups
scaur75814902scaur
schavs1436492schavs
scops95820192scops
score75526732score
scores84725922scores
scorn75817442scorn
scorns85713012scorns
scots74025902scots
scours84913582scours
scows106617802scows
scrag85916172scrag
scrags95713802scrags
scram910621612scram
scrams105216622scrams
scrap97120402scrap
scraps106017242scraps
scry96017762sc_ry
scuds85116242scuds
scums95017422scums
scups95316652scups
scurf104719322scurf
scurfs113210812scurfs
scuts74522522scuts
seals54839692seals
seams75731662seams
sear47353842sear_
seas45755272sea_s
seats54844342seats
secpars1138412secpars
seers55136382seers
sers45746652s_ers
sewars94018622sewars
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shard96125962shard
shards104319172shards
share86437082share
shares95236412shares
shark126225022shark
sharks135019722sharks
sharn84823702sharn
sharns95516982sharns
sharp104922532sharp
sharps115516082sharps
shaws116226262shaws
shays116021432shays
shears93820902shears
sials54227242sials
simars84916932simars
sirs44338332s_irs
sitars65417592sitars
sizars154812622sizars
skags104316072skags
skas85325712ska_s
skats94621532skats
slabs75322642slabs
slags66525902slags
slams74927902slams
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slurs54123372slurs
smarm95517602smarm
smarms105712532smarms
smart75834092smart
smarts86218002smarts
smears84714432smears
snags64421312snags
snaps74719562snaps
snare54429982snare
snares65329032snares
snarf86525422snarf
snarfs95113422snarfs
snark95419942snark
snarks104815732snarks
snarl54921082snarl
snarls64016872snarls
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soar46838672soar_
socas74026182soca_s
sofars94712782sofars
sonars64818972sonars
soras55041012soras
soucars938412soucars
sours55230502sours
sowars94318002sowars
sowcars1236002sowcars
spaes76029972spaes
spams94922192spams
spans74528732spans
spar65433302spar_
spare75135562spare
spares84834552spares
spark114920892spark
sparks124616362sparks
sparse84516342sparse
spas67036722spa_s
spats75031382spats
spays105520512spays
spears84019472spears
spurs74621522spurs
stabs76221382stabs
stags66226742stags
stairs65416332stairs
star48037762star_
stare54440262stare
stares66038752stares
stark95425622stark
start55642312start
starts65423122starts
stats55933362stats
stays86022022stays
stirs55921612stirs
suers55128482suers
sugars7312422sugars
suras55336322suras
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
sward94221462sward
swards105415132swards
sware85828212sware
swarf115324652swarf
swarfs125612062swarfs
swarm106218832swarm
swarms116112162swarms
swart86234642swart
swats85726862swats
sways115518462sways
swears94114072swears
tars46763952_tars
tears55436462tears
tsars56717102tsars
tzars144914272tzars
vars75742072_vars
vicars11712262vicars
wars78659802_wars
wears86030302wears
years84527672years

Search took 4 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.0931921408.6
2DLD Change Limit538003002.62620487.4
3Display Results3003000.1701764.7
 (SQL Overall)1786913002.88961852.2
 
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.