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 “attacks” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

189 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
attacks1312694(None) 
attack12148151attack_
amtracks1696632amtracks
anticks134612252anticks
arracks1387732arracks
attach11118392attac_h
attache12106692attache
attaches13137722attaches
attacked15125112attacked
attacker14144982attacker
attackers15144012attackers
attains7310982attains
attars64515312atta_rs
attics84413282attic_s
attracts1047792attracts
fatbacks1946002fatbacks
hatracks1737532hatracks
mattocks1644982mattocks
reattacks1543752reattacks
retacks132210712retacks
stacks124317262_stacks
tacks115430132__tacks
thacks154311922_thacks
tracks124818842_tracks
untacks1357502untacks
abacas104414723a_bacas
aback134816173a_back_
abacus10349763a_bacus
alack114820063a_lack_
alpacas1137073alpacas
altars64518153alta_rs
amtrack15107393amtrack_
amtracs1198883amtrac_s
amucks1466003a_mucks
anlaces92313733anlaces
antacid10311223antacid
antacids1148333antacids
antas55432033anta__s
antick124814583antick_
antics84621453antic_s
araks94820883a_ra_ks
arrack121110253arrack_
ataps76414833a_ta_ps
atlas55821583atla__s
atlases72410643atlases
atlatls744773atlatls
atmans84413963atma_ns
atmas75721013atma__s
attaboy1264303attaboy
attached14165703attached
attacher13125713attacher
attachers14134883attachers
attacking1635323attacking
attackman1751823attackman
attackmen1752153attackmen
attain6311753atta_in
attaint7313473attaint
attaints846493attaints
attar56516693atta__r
attends8257593attends
attests7278813attests
attic75618353attic__
atticism1268533atticism
atticist10811343atticist
attires72312953attires
attorns738443attorns
attract9511833attrac_t
attrits7310623attrits
attunes737823attunes
autarchs1344993autarchs
autarky1444703autarky
backs135729623__backs
barracks1636883barracks
battiks1337143batt_iks
bipacks1745043bipacks
bittocks1644443bittocks
blacks144914953_blacks
buttocks1645233buttocks
bytalks1632713bytalks
calpacks18266523calpacks
caracks152211563caracks
carjacks2345573carjacks
carracks1637713carracks
catfaces1536963catfaces
cattails1038553cattails
cattalos1037933cattalos
catwalks1744793catwalks
clacks144516343_clacks
coatracks1745403coatracks
cracks144817003_cracks
cutbacks1845813cutbacks
deticks1437353deticks
fastbacks2044253fastbacks
fatback1836923fatback_
fatstocks1843453fatstocks
flacks154114533_flacks
futtocks1743833futtocks
hacks144928713__hacks
hardtacks1943803hardtacks
hatrack1638213hatrack_
hayracks2045313hayracks
haystacks2143373haystacks
hijacks2333533hijacks
jacks185219833__jacks
knacks11428543_knacks
kyacks14416063_kyacks
lacks116129203__lacks
lattices1038383lattices
macks135127603__macks
mattock1535823mattock_
ottars64112223otta_rs
ottavas1093483ottavas
outacts9310213outacts
outasks1138173outasks
outbacks1638983outbacks
outtalks1236503outtalks
outtasks1235633outtasks
packs135528933__packs
patacas11311003patacas
paybacks2145493paybacks
placks144414153_placks
quacks214710103_quacks
racks115028853__racks
ransacks1445773ransacks
rattails837133rattails
rattans73411953ratta_ns
reattack1444123reattack_
repacks15269543repacks
reracks132310533reracks
restacks1438093restacks
retack122612823retack_
retracks14149103retracks
sacks114228873__sacks
scatbacks1974713scatbacks
seatbacks17115603seatbacks
setbacks1686303setbacks
shacks154817563_shacks
shticks16356963shticks
slacks124416533_slacks
smacks144112323_smacks
snacks124514553_snacks
stack114421693_stack_
stalks104614553_stalks
stanks104917703_stanks
steaks104415853stea_ks
sticks125118613_sticks
stocks124715633_stocks
stricks134310693stricks
taces76237803__taces
tachs105820933__tachs
tack106536293__tack_
tacky145617443__tacky
tacos77023553__tacos
tacts76524123__tacts
talks94322693__talks
tanks94624743__tanks
tasks94917583__tasks
tatamis939723tatamis
tatars64619793tata_rs
teaks94222903_tea_ks
thack144915173_thack_
thanks134313133_thanks
thicks154511993_thicks
thwacks1953613thwacks
ticks115823293__ticks
traces85329933_traces
track114823013_track_
tracts85019073_tracts
traiks104013713_traiks
tranks104017763_tranks
tricks125319013_tricks
trocks123614633_trocks
trucks124711973_trucks
tucks114721123__tucks
umiacks1534013umiacks
unpacks1576093unpacks
unstacks1446043unstacks
untack1239763untack_
untracks1437523untracks
untucks1334673untucks
uptalks1333723uptalks
upticks1535153upticks
wacks146626283__wacks
wattages12106783wattages
wattapes1395253wattapes
wetbacks1974983wetbacks
whacks184610483_whacks
wracks154711113_wracks
yacks144419813__yacks

Search took 8 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 Filter1786911340270.703254183.5
2DLD Change Limit1340271896.43620824.6
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.