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

214 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
attack1214815(None) 
attach11118391attach
attacks13126941attacks
aback134816172a_back
alack114820062a_lack
amtrack15107392amtrack
antick124814582antick
arrack121110252arrack
attache12106692attache
attacked15125112attacked
attacker14144982attacker
attain6311752attain
attar56516692atta_r
attars64515312attars
attic75618352attic_
attics84413282attics
attract9511832attract
fatback1836922fatback
hatrack1638212hatrack
mattock1535822mattock
reattack1444122reattack
retack122612822retack
stack114421692_stack
tack106536292__tack
thack144915172_thack
track114823012_track
untack1239762untack
abaca95118043a_baca
abaci94718843a_baci
abbacy1536623abbacy
acock132110213a_cock
acta69524803acta__
aitch105216163ait_ch
alpaca1047383alpaca
altar55520643alta_r
altars64518153altars
amtrac10109123amtrac_
amtracks1696633amtracks
amtracs1198883amtracs
amuck1389563a_muck
anlace82513923anlace
anta46839583anta__
antacid10311203antacid
antae56828293anta_e
antas55432033anta_s
antic75728863antic_
anticks134612253anticks
antics84621453antics
antitank1247193antitank
apace94718383a_pace
apeak115513453apea_k
arak86929573a_ra_k
arracks1387733arracks
artal55525473arta_l
atap66722453a_ta_p
ataps76414833a_taps
ataxy1537313a_taxy
atlas55821583atla_s
atlatl637873atlatl
atma68121773atma__
atman75520143atma_n
atmans84413963atmans
atmas75721013atma_s
att35454653att___
attaboy1264303attaboy
attached14165703attached
attacher13125713attacher
attaches13137723attaches
attackers15144013attackers
attacking1635323attacking
attackman1751823attackman
attackmen1752153attackmen
attains7310983attains
attaint7313473attaint
attend7258973attend
attent62818323attent
attest62618613attest
attire62412383attire
attorn6310793attorn
attracts1047793attracts
attrit6315743attrit
attune637983attune
atwain937813atwain
autarch1246623autarch
autarky1444703autarky
back125535763__back
barrack1538253barrack
battik1238093batt_ik
bipack1636523bipack
bittock1544433bittock
black134719073_black
buttock1545563buttock
bytalk1533473bytalk
calpack17338333calpack
carack142113173carack
carjack2246153carjack
carrack1548753carrack
catface1436763catface
cattail939173cattail
cattalo938423cattalo
catwalk1645323catwalk
clack134720173_clack
coatrack1645843coatrack
crack134120533_crack
cutback1747093cutback
detach12310413detach
detick1339383detick
fastback1944523fastback
fatbacks1946003fatbacks
fatstock1743613fatstock
flack144519413_flack
futtock1644153futtock
hack135134543__hack
hardtack1843993hardtack
hatracks1737533hatracks
hayrack1945543hayrack
haystack2044013haystack
hijack2233673hijack
intact8314663intact
jack175224863__jack
knack104311043_knack
kyack13468263_kyack
lack105837683__lack
lattice938433lattice
mack125733643__mack
manpack1746063manpack
mattocks1644983mattocks
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
outact8317203outact
outask1039103outask
outback15310653outback
outtalk1138233outtalk
outtask1137053outtask
pack125535443__pack
pataca10311193pataca
payback2056453payback
plack135017843_plack
quack203812503_quack
rack106234883__rack
ransack1346463ransack
rattail737793rattail
rattan63613603ratta_n
rattans73411953rattans
reattach1343743reattach
reattacks1543753reattacks
repack142412163repack
rerack122513163rerack
restack1339433restack
retacks132210713retacks
retrack131310723retrack
sack105337313__sack
scatback1875033scatback
seatback1675823seatback
setback1567143setback
shack145321753_shack
shtick15308013shtick
slack115021763_slack
smack134615453_smack
snack114718063_snack
stacks124317263_stacks
stalk94518003_stalk
stank95823303_stank
stark95425623_stark
steak95219803stea_k
stick115121563_stick
stock114417563_stock
strick124813203strick
struck12489263struck
stuck114515773_stuck
tace65342513__tace
tach96132753__tach
tacks115430133__tacks
tacky145617443__tacky
taco67031353__taco
tact67349033__tact
talk86230093__talk
tank85134013__tank
task85326653__task
tatami839183tatami
tatar56122063tata_r
tatars64619793tatars
teach105221123_teach
teak85930843_tea_k
thacks154311923_thacks
thank125817803_thank
thick145613353_thick
thwack1834213thwack
tick106231223__tick
trace75829613_trace
tracks124818843_tracks
tract75635713_tract
traik95418203_traik
trank96222423_trank
trick115420693_trick
trock114817603_trock
truck116115463_truck
tuck104626573__tuck
umiack1435173umiack
unpack1457833unpack
unstack1337373unstack
untacks1357503untacks
untrack1338703untrack
untuck1236403untuck
uptalk1234653uptalk
uptick1436763uptick
wack135330913__wack
wattage1186983wattage
wattape12135383wattape
wetback1875613wetback
whack174813023_whack
wrack145413883_wrack
yack135425973__yack

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162147.57614878.0
3Display Results2142140.0802675.0
 (SQL Overall)1786912147.78222962.1
 
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.