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

227 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
pacts9512580(None) 
acts66929861_acts
epacts105010391epacts
facts107021891facts
pacas96029401pacas
paces96741111paces
packs135528931packs
pacs85842181pac_s
pact86648721pact_
pants76536921pants
parts77743371parts
pasts75936501pasts
pats66460851pa_ts
tacts76524121tacts
aces67645092_aces
act59557842_act_
acta69524802_acta
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
backs135729622backs
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332ba_ts
batts76727562batts
bracts105617772bracts
cacas95627982cacas
cacti9318642cacti
cactus104912232cactus
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342ca_ts
coacts105314332coacts
daces85030682daces
darts67635732darts
dauts67822242dauts
dawts97216122dawts
ducts85319892ducts
easts57530322easts
eats47054872ea_ts
enacts84012972enacts
epact94921532epact_
exacts15359612exacts
faces106439432faces
facets116316652facets
fact97142542fact_
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
gaits65726012gaits
gasts66628632gasts
gats56753442ga_ts
hacks144928712hacks
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252ha_ts
impacts13266502impacts
jacks185219832jacks
karts97630112karts
kats85944332ka_ts
laces76141762laces
lacks116129202lacks
lacs66942482lac_s
lasts57731262lasts
lats45962702la_ts
maces97139962maces
machs125722562machs
macks135127602macks
macs86742502mac_s
malts76331752malts
marts77442232marts
masts77035762masts
mats65460282ma_ts
matts76829182matts
mauts75927192mauts
oasts56529182oasts
oats46554212oa_ts
pac79054082pac__
paca85132242pac_a
pace86345772pac_e
paced106931682paced
pacer96131612pacer
pacers105124542pacers
pacey126720282pacey
pacha126518062pacha
pachas135017142pachas
pack125535442pac_k
packets155114772packets
pacy115328682pac_y
padis86227142padis
pads76742952pa_ds
pages85235072pages
paiks114719852paiks
pails75833062pails
pains75138282pains
paints85921832paints
pairs75325832pairs
pales75753802pales
palets85122312palets
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
panes76148692panes
pangs84628662pangs
pans65855722pa_ns
pant66061252pant_
panto76129412panto
pantos85222742pantos
panty105929302panty
papas94927492papas
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
part65967462part_
party106630612party
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
past65959012past_
pasta76624532pasta
pastas85422872pastas
paste74932952paste
pastes85233912pastes
pastis84924322pastis
pasty105725052pasty
pat58089462pa_t_
patch125221222patch
pate65350462pa_te
pates76047892pates
path99134912pa_th
paths105521382paths
patsy105717202pa_tsy
patty104723612patty
paty95234562pa_ty
paves104833922paves
pavis106422732pavis
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
peaces106324082peaces
peats76140192peats
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pelts76128812pelts
pests75933272pests
pets66248332p_ets
phots105418492phots
phuts104613502phuts
picas94626522picas
picks135226142picks
picots104616442picots
pics85633912pic_s
pints75936222pints
pits66348742p_its
places104323702places
placets113911222placets
placks144414152placks
plaits83816472plaits
plants84921802plants
plats75531372plats
plots75025672plots
pocks135022962pocks
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362p_ots
pouts75530322pouts
prats76333392prats
preacts113211362preacts
puces94924632puces
pucks134322102pucks
punts75828002punts
puts65641752p_uts
putts75719272putts
qats135331342qa_ts
races74943242races
racks115028852racks
rafts87820632rafts
rants55935342rants
rats46260372ra_ts
reacts83616602reacts
sacks114228872sacks
sacs65739072sac_s
salts55431882salts
scats75930602scats
sects75622892sects
spaces104722632spaces
spaits85017472spaits
spats75031382spa_ts
taces76237802taces
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tact67349032tact_
tarts57242022tarts
tats46858132ta_ts
tauts56125512tauts
tracts85019072tracts
vacs96226202vac_s
vasts86423772vasts
vats76841742va_ts
wacks146626282wacks
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
yachts1437022yachts
yacks144419812yacks

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 Filter178691538000.0931921408.6
2DLD Change Limit538002271.67332157.8
3Display Results2272270.0603783.3
 (SQL Overall)1786912271.82697859.3
 
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.