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

334 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
act5955784(None) 
ace59656831ace
acta69524801acta
acts66929861acts
aft66849011aft
ait38093901ait
alt36467961alt
ant37270781ant
apt57352541apt
art38679141art
at212393401a_t
att35454651att
cat58282341cat
fact97142541fact
pact86648721pact
tact67349031tact
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abet610547942abet
abo59045962abo
abs59356072abs
abut66834952abut
aby810238062aby
aced79540882aced
aces67645092aces
aceta74017352aceta
ache96829822ache
achy126316092achy
acid77533392acid
acme86924322acme
acne66625872acne
acre67330772acre
acted88521732acted
actin74922552actin
actor71116072actor
acute74720362acute
acyl95314292acyl
ad311975032a_d
add510132362add
adit56443652adit
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aff95537612aff
ag311067462a_g
aga410447232aga
age47154332age
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahi68040232ahi
ahs68644822ahs
ai211288392a_i
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
airt45757782airt
ais39083572ais
aits46355532aits
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
alit46155692alit
all36148232all
alp56641132alp
als36663022als
alto47831262alto
alts46639902alts
am411875562a_m
ama510853302ama
ami56646802ami
amp77541022amp
amu58237322amu
an211879072a_n
ana39559822ana
and47244162and
ane37866942ane
ani37751172ani
anta46839582anta
ante46538902ante
anti45536362anti
ants47243472ants
any68440482any
ape57251182ape
apo511142122apo
app76827602app
ar211379382a_r
arb510448422arb
arc510250902arc
arch98628442arch
arco68331542arco
arcs67834782arcs
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
arts49650262arts
arty77531312arty
as211083072a_s
asci66519142asci
ascot76522512ascot
ash67944602ash
ask77130702ask
asp57235342asp
ass37844062ass
ate37059242ate
auk76234142auk
aunt46553652aunt
auto47432082auto
ava610139322ava
ave67748702ave
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
ay511773892a_y
aye67151762aye
ays67050292ays
azo128233392azo
bach116131392bach
back125535762back
baht96740012baht
bait66556002bait
bast66362412bast
bat510988952bat
batt65053872batt
bet58376672bet
bit57070892bit
bot59680402bot
bract96332722bract
but55963022but
cab78355402cab
caca85528082caca
cacti9318632cacti
cad67456362cad
cam78058982cam
can57760132can
cant66362022cant
cap76758982cap
car59165562car
cart66570342cart
cast67159902cast
cate66254592cate
cats66356342cats
caw86647932caw
cay87155982cay
coact96130572coact
cot510483222cot
cut57957662cut
dace76934922dace
daft85537252daft
dart55857872dart
daut56443562daut
dawt85435942dawt
dit47071332dit
dot47573182dot
duct75735462duct
each95530582each
east46659102east
eat36989052eat
echt95722902echt
ecu56828232ecu
eft66038822eft
enact73525362enact
epact94921532epact
et26964192_et
exact143516932exact
face96140122face
facet106038522facet
facts107021892facts
fart76860562fart
fast77052312fast
fat68178082fat
fet66471632fet
fit66365452fit
gait56150192gait
gast56052562gast
gat46880512gat
get47467462get
git46266052git
got49870442got
gut46753852gut
hack135134542hack
haet75659502haet
haft105941842haft
halt76056302halt
hant75461582hant
hart76865772hart
hast76259482hast
hat67289962hat
haut75949732haut
het67674312het
hit66569192hit
hot67776052hot
hut66457292hut
ice56737242ice
ich86227742ich
ick97329322ick
icy86322122icy
it28455682_it
jack175224862jack
jet106754822jet
jot108259022jot
jut105944012jut
kart86750802kart
kat77468292kat
kit78559872kit
lac510155822lac_
lace66848472lace
lack105837682lack
lacs66942482lacs
lacy95829632lacy
last46260322last
lat37593402lat
let36481472let
lit39377312lit
lot38179262lot
mac78053922mac_
mace87345782mace
mach116134472mach
mack125733642mack
macs86742502macs
malt66254802malt
mart66865972mart
mast65959952mast
mat58083932mat
matt65752652matt
maut65448442maut
met56072432met
mot57279422mot
mut58357182mut
net36670292net
nit37065942nit
not39474662not
nut36651962nut
oast47156322oast
oat39888262oat
oca56731732oca
oft67744062oft
oot311274692oot
opt57545542opt
ort39465232ort
out38072152out
pac79054082pac_
paca85132242paca
pace86345772pace
pack125535442pack
pacs85842182pacs
pacts95125802pacts
pacy115328682pacy
pant66061252pant
part65967462part
past65959012past
pat58089462pat
pet56477302pet
pht86030522pht
pit56471922pit
pot58078432pot
pst57932512pst
put55759072put
qat125253332qat
race66746262race
rack106234882rack
racy95825682racy
raft76245912raft
rant45864672rant
rapt67245312rapt
rat37892742rat
react74634332react
ret35982832ret
rot37282952rot
rut35560522rut
sac57452862sac_
sack105337312sack
sacs65739072sacs
salt45758522salt
sat36288482sat
scat65848372scat
scot66242602scot
scut65835542scut
sect67443622sect
set36681252set
sit35877752sit
sot310384292sot
tace65342512tace
tacet75840022tacet
tach96132752tach
tacit76333672tacit
tack106536292tack
taco67031352taco
tacts76524122tacts
tart47566182tart
tat37690292tat
taut47048962taut
tet39274982tet
tit36771042tit
tot38884772tot
tract75635712tract
tut36758092tut
ut28647032_ut
vac86537142vac_
vacs96226202vacs
vast75045122vast
vat67863452vat
vet65958522vet
wack135330912wack
waft106139002waft
wait75553692wait
want76156162want
wart77866082wart
wast75655852wast
wat67378922wat
watt75545412watt
wet65966622wet
wit66563772wit
wot610467482wot
yacht13417392yacht
yack135425972yack
yet66960692yet
zit126049992zit

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 Filter178691140840.0632836365.1
2DLD Change Limit140843340.87316132.9
3Display Results3343340.1262650.8
 (SQL Overall)1786913341.062168258.9
 
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.