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

106 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
attacking163532(None) 
attaching1545431attaching
anticking1649242anticking
attaining1047222attaining
attracting1346562attracting
reattacking1843302reattacking
retacking1658972retacking
stacking154215082_stacking
tacking144421482__tacking
thacking183110042_thacking
tracking153715462_tracking
untacking1636642untacking
anticaking1747603anticaking
anticling12310693anticling
antiking13412073ant_iking
arcking145811963a__rcking
articling1247713articling
attack12148153attack___
attacked15125113attack_ed
attacker14144983attack_er
attackers15144013attackers
attackman1751823attackman
attackmen1752153attackmen
attacks13126943attack__s
attain6311753atta__in_
attains7310983atta__ins
attaint7313473atta__int
attainting1144783attainting
attending11136373attending
attesting1036383attesting
atticizing2246323atticizing
attiring939483att_iring
attorning1045503attorning
attriting1048683attriting
attuning935903att_uning
awaking1547813a_wa_king
backing165523443__backing
barracking1944713barracking
betaking153010153beta_king
blacking174213603_blacking
carjacking2643543carjacking
catfacing1744553catfac_ing
clacking173313493_clacking
cracking174013903_cracking
detaching1637263detaching
deticking1736043deticking
flacking184311793_flacking
hacking173720613__hacking
hijacking2642763hijacking
jacking214515263__jacking
knacking14296713_knacking
lacking143821543__lacking
latticing1246063lattic_ing
meatpacking2252223meatpacking
outacting1239213outacting
outasking1437313outasking
outtalking1545483outtalking
outtasking1545723outtasking
packing164420723__packing
partaking1698673parta_king
quacking2436743_quacking
racking144323663__racking
ransacking1744423ransacking
reattaching1743123reattaching
repacking1838283repacking
reracking1639313reracking
restacking1737183restacking
retackling1744433retackling
retaking133114283reta_king
retracking1738163retracking
sacking144122703__sacking
shacking184014083_shacking
slacking153914133_slacking
smacking173510763_smacking
snacking153411703_snacking
staking123919803_sta_king
stalking133512223_stalking
sticking153513463_sticking
stocking152912503_stocking
tackling153211123__tackling
taking114725953__ta_king
talcking1567083_talcking
talking123815823__talking
tanking123918793__tanking
tarmacking1944233tarmacking
tasking124616323__tasking
teaching143612603_teaching
thanking16409523_thanking
thwacking2253193thwacking
ticking143218753__ticking
tictacking19113313tictacking
tracing103720153_trac_ing
trackings16247543_trackings
traiking132511973_traiking
tricking152714513_tricking
trocking153612423_trocking
trucking153310163_trucking
tucking143415183__tucking
unpacking1835133unpacking
unstacking1744993unstacking
untracking1746933untracking
untucking1644693untucking
uptalking1643353uptalking
whacking21377483_whacking
wracking18349963_wracking
yacking174315683__yacking

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411067.25020502.2
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.73223110.6
 
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.