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

306 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
acts6692986(None) 
aces67645091aces
act59557841act_
acta69524801acta
aits46355531aits
alts46639901alts
ants47243471ants
arts49650261arts
cats66356341cats
facts107021891facts
pacts95125801pacts
tacts76524121tacts
aahs716428562aahs
aals49941142aals
aas310975392a_as
abas68642082abas
abets75621672abets
abos67734412abos
abs59356072a_bs
abuts75417072abuts
abys97221882abys
ace59656832ac_e
aced79540882aced
aceta74017352aceta
ache96829822ache
aches106132292aches
achy126316092achy
acid77533392acid
acids87121002acids
acme86924322acme
acmes96020652acmes
acne66625872acne
acnes75922622acnes
acre67330772acre
acres76327762acres
acted88521732acted
actin74922552actin
actins86321102actins
actor71116072actor
actors81016752actors
acute74720362acute
acutes83917722acutes
acyl95314292acyl
acyls104211522acyls
adds67622452adds
adits66523712adits
ados57633512ados
ads49755732a_ds
aft66849012aft_
agas55938842agas
ages55844592ages
ags47551662a_gs
ahis76135382ahis
ahs68644822a_hs
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
airts55626342airts
ais39083572a_is
ait38093902ait_
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alms65834922alms
alps65529242alps
als36663022a_ls
alt36467962alt_
alto47831262alto
altos55822952altos
amas67746292amas
amis66445322amis
amps86230342amps
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
ant37270782ant_
anta46839582anta
antas55432032antas
ante46538902ante
antes56334322antes
anti45536362anti
antis55033312antis
antsy85712792antsy
anus47131112anus
apes66047432apes
apos65433822apos
apps86319692apps
apt57352542apt_
arbs66834732arbs
arcs67834782arcs
arcus76918862arcus
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
ars37670932a_rs
art38679142art_
artsy86012962artsy
arty77531312arty
as211083072a__s
ascots85312512ascots
ascus75013582ascus
asks85721212asks
asps65622092asps
ass37844062a_ss
at212393402a_t_
ate37059242a_te
ates45047922ates
att35454652a_tt
auks85525262auks
aunts55227632aunts
auto47432082auto
autos56523322autos
aves76142602aves
avos77227012avos
awes76037552awes
awls75926092awls
awns75324432awns
axes117337852axes
axis116127912axis
ayes76543512ayes
ays67050292a_ys
backs135729622backs
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332bats
batts76727562batts
bets67051442bets
bits66148162bits
bots66453952bots
bracts105617772bracts
buts67247692buts
cabs86739422cabs
cacas95627982cacas
cacti9318632cacti
cactus104912232cactus
cads76144522cads
cams87047282cams
cans65050842cans
cants77036942cants
caps87147892caps
cars67364762cars
carts78946292carts
cast67159902cast
casts77237792casts
cat58282342cat_
cate66254592cate
cates75951872cates
caws96036102caws
cays95437672cays
cis57748032_cis
coacts105314322coacts
cos510270392_cos
cots68054842cots
cuts65841152cuts
daces85030682daces
darts67635732darts
dauts67822242dauts
dawts97216122dawts
dits56450522dits
dots55647662dots
ducts85319892ducts
easts57530322easts
eats47054872eats
ecus65421462ecus
efts76519482efts
enacts84012972enacts
epacts105010392epacts
exacts15359612exacts
faces106439432faces
facets116316652facets
fact97142542fact_
farts88336842farts
fasts86429682fasts
fats76252502fats
fets75345942fets
fits76043462fits
gaits65726012gaits
gasts66628632gasts
gats56753442gats
gets55442482gets
gits55744592gits
guts56637252guts
hacks144928712hacks
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252hats
hets75547202hets
hits75545132hits
hots78349322hots
huts76737442huts
ices66129642ices
ichs96214712ichs
ictus7249692ictus
its35538832_its
jacks185219832jacks
jets115834102jets
jots116336142jots
juts115930162juts
karts97630112karts
kats85944332kats
kits86441762kits
laces76141762laces
lacks116129202lacks
lacs66942482lac_s
lasts57731262lasts
lats45962702lats
lets47147942lets
lits46252492lits
lots47652092lots
maces97139962maces
machs125722562machs
macks135127602macks
macs86742502mac_s
malts76331752malts
marts77442232marts
masts77035762masts
mats65460282mats
matts76829182matts
mauts75927192mauts
mots66853162mots
muts64839982muts
nets45941532nets
nits45741642nits
nuts45032672nuts
oasts56529182oasts
oats46554212oats
ocas66729632ocas
oots46446442oots
opts68124742opts
orts46538332orts
outs45746962outs
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pac_s
pact86648722pact_
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852pats
pets66248332pets
pits66348742pits
pots66452362pots
puts65641752puts
qats135331342qats
races74943242races
racks115028852racks
rafts87820632rafts
rants55935342rants
rats46260372rats
reacts83616602reacts
rets45352562rets
rots46454092rots
ruts44541492ruts
sacks114228872sacks
sacs65739072sac_s
salts55431882salts
scats75930602scats
scots74025902scots
scuts74522522scuts
sects75622892sects
sets45549502sets
sits45050202sits
sots45552442sots
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tact67349032tact_
tarts57242022tarts
tats46858132tats
tauts56125512tauts
tets45847452tets
tits46145032tits
tots46654122tots
tracts85019072tracts
tuts45838452tuts
uts35534372_uts
vacs96226202vac_s
vasts86423772vasts
vats76841742vats
vets76835092vets
wacks146626282wacks
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wats
watts86923092watts
wets75940292wets
wits76044872wits
wots76342892wots
yachts1437022yachts
yacks144419812yacks
zits136030292zits

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298723060.96630923.4
3Display Results3063060.0634857.1
 (SQL Overall)1786913061.109161128.0
 
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.