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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
effected174499(None) 
affected1744801affected
effecter1664771effecter
affecter1644522affecter
defected15289972defected
deflected1635982deflected
effaced16225572effac_ed
effect1437442effect__
effecters1764322effecters
effector1644872effector
effects1535282effect_s
effete1235182effe_te_
ejected17297652e_jected
elected102812612e_lected
erected103213992e_rected
expected2036742expected
exsected1835672exsected
infected14229402infected
perfected1736642perfected
refected142311662refected
reflected1547982reflected
advected1534543advected
affect1448903affect__
affectedly2252153affectedly
affecters1763933affecters
affects1535393affect_s
afflicted1843433afflicted
beflecked2142653beflecked
befretted1544373befretted
bisected1336203bisected
buffeted1753733buffe_ted
confected1739073confected
defeated132812163defeated
defecated1637493defecated
dejected19307593dejected
detected12289733detected
directed1238233directed
efface14366673effac_e_
effacer15255413effac_er
effaces15277273effac_es
effecting1845583effecting
effective2076193effective
effectives21134563effectives
effectors1755033effectors
effectual1752763effectual
effectuated2051993effectuated
effetely1742693effe_tely
effulged1642013effulged
effused1434143eff_used
egested938123e_gested
electee92513243e_lectee
enacted10310643e_nacted
enfaced13218913enfac_ed
enfetter1145353enfetter
erecter93113393e_recter
eructed10228653e_ructed
everted112711853e_verted
evicted1337243e_victed
exacted1737303e_xacted
excepted2055253excepted
executed1835503e_xecuted
exerted152210053e_xerted
expecter1936513expecter
experted1838053experted
exserted1636213exserted
faceted13509573_faceted
felted103714653__felted
feted94420933__fe_ted
fetted104817893__fetted
flecked17358073_flecked
fleeted113310233_fleeted
fracted1339373_fracted
fretted113411853_fretted
infecter13229153infecter
infested12249643infested
inflected1546053inflected
injected18226753injected
invected14258883invected
neglected1354693neglected
objected2043493objected
obtected1344553obtected
offended1643653offended
offered1436143offe_red
perfecter1646043perfecter
redefected1743853redefected
reejected1955093reejected
reelected1238313reelected
reerected1238613reerected
refracted1557393refracted
reinfected1645253reinfected
rejected182710113rejected
resected112514743resected
respected1438493respected
selected1159783selected
unaffected1942943unaffected
unfelted1279403unfelted

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 Filter1786911461620.436409841.7
2DLD Change Limit146162966.87621256.8
3Display Results96960.0462087.0
 (SQL Overall)178691967.35824285.3
 
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.