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

223 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
tacts7652412(None) 
acts66929861_acts
facts107021891facts
pacts95125801pacts
taces76237801taces
tachs105820931tachs
tacks115430131tacks
tacos77023551tacos
tact67349031tact_
tarts57242021tarts
tats46858131ta_ts
tauts56125511tauts
tracts85019071tracts
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
epacts105010392epacts
exacts15359612exacts
faces106439432faces
facets116316652facets
fact97142542fact_
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
gaits65726012gaits
gasts66628632gasts
gats56753442ga_ts
hacks144928712hacks
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252ha_ts
jacks185219832jacks
karts97630112karts
kats85944332ka_ts
laces76141762laces
lacks116129202lacks
lacs66942482lac_s
lasts57731262lasts
lats45962702la_ts
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512mac_s
malts76331752malts
marts77442232marts
masts77035762masts
mats65460292ma_ts
matts76829182matts
mauts75927192mauts
oasts56529182oasts
oats46554212oa_ts
outacts9310212outacts
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pac_s
pact86648722pact_
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
qats135331342qa_ts
races74943242races
racks115028852racks
rafts87820632rafts
rants55935342rants
rats46260372ra_ts
reacts83616602reacts
sacks114228872sacks
sacs65739072sac_s
salts55431882salts
scats75930602scats
sects75622892sects
stacks124317262stacks
stacte82113912stacte
stactes91914632stactes
starts65423122starts
stats55933362sta_ts
tabes76033922tabes
tabs66842982ta_bs
tabus74820922tabus
tace65342512tac_e
tacet75840022tacet
tach96132752tac_h
tache106222372tache
taches114224172taches
tacit76333672tacit
tack106536292tac_k
tackets134914362tackets
tacky145617442tacky
taco67031352tac_o
tactic10612752tactic
tactics1149322tactics
tads57143942ta_ds
taels56822072taels
tags55545232ta_gs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
taints64520532taints
tajes124920692tajes
takas95520682takas
takes94437792takes
talas55935892talas
talcs74817182talcs
tales55451372tales
talks94322692talks
talls55133432talls
talus55423262talus
tames75242012tames
tamis76728732tamis
tamps95524082tamps
tams67247932ta_ms
tangs65028342tangs
tanks94624732tanks
tans46154822ta_ns
tanto55724942tanto
taos45541002ta_os
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672ta_ps
tares57456562tares
tarns56433952tarns
taros55640822taros
tarots66422992tarots
tarps76527112tarps
tars46763952ta_rs
tart47566182tart_
tarty86328182tarty
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
taste55127232taste
tastes64126422tastes
tasty84820312tasty
tat37690292ta_t_
tate44748602ta_te
tates55444982tates
tatty84720182tatty
taunts65715662taunts
taus46342732ta_us
taut47048962taut_
tavs75630972ta_vs
taws75641592ta_ws
taxes124730822taxes
taxis126821972taxis
taxus125512482taxus
teats55636812teats
techs106915832techs
tecta74215522tecta
tents56434212tents
tests56530192tests
tets45847462t_ets
texts125515042texts
thacks154311922thacks
ticks115823292ticks
tics65729632tic_s
tilts55325612tilts
tincts84510802tincts
tints56030922tints
tits46145042t_its
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
tots46654122t_ots
touts54830392touts
traces85329932traces
tracks124818842tracks
tract75635712tract_
traits65121982traits
trets55928022trets
trots56629942trots
tucks114721122tucks
tufts85713272tufts
tuts45838452t_uts
twats86616602twats
twits86015792twits
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.0762351197.4
2DLD Change Limit538002231.61033416.1
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.749102167.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.