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

95 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
affected174479(None) 
affecter1644521affecter
effected1744991effected
advected1534532advected
affect1448902affect__
affectedly2252152affectedly
affecters1763932affecters
affects1535392affect_s
afflicted1843432afflicted
defected15289972defected
effecter1664772effecter
infected14229402infected
refected142311662refected
unaffected1942942unaffected
abducted1444093abducted
abetted1058323a_betted
abreacted1444293abreacted
absented1156613absented
accented13107773accented
accepted15105383accepted
acted88521733a___cted
addicted1345073addicted
adducted1343913adducted
adverted1336103adverted
afeared1176833a_feared
affecting1845233affecting
affection1745893affection
affectioned2052453affectioned
affective20135413affective
affectless1842133affectless
affiche1844313affiche_
affiches1945233affiches
affined1436413aff_ined
affirmed1743213affirmed
affixed2134123aff_ixed
afflicter1742823afflicter
afforded1643433afforded
afforested1752653afforested
affrayed1842843affrayed
affricated1943853affricated
affronted1642503affronted
agented939423a_gented
alerted82512223a_lerted
arrested939153arrested
assented957513assented
asserted957903asserted
attested936293attested
averted112211613a_verted
bisected1336203bisected
buffeted1753733buffe_ted
cathected1744543cathected
confected1739073confected
defeated132812163defeated
defecated1637493defecated
deflected1635983deflected
dejected19307593dejected
detected12289733detected
directed1238233directed
disaffected21172553disaffected
effaced16225573effac_ed
effect1437443effect__
effecters1764323effecters
effector1644873effector
effects1535283effect_s
effete1235183effe_te_
ejected17297653_ejected
elected102812613_elected
erected103213993_erected
expected2036743expected
exsected1835673exsected
faceted13509563face_ted
facetted1445743facetted
felted103714653__felted
feted94420933__fe_ted
fetted104817893__fetted
flecked17358073_flecked
fleeted113310233_fleeted
fracted1339373_fracted
fretted113411853_fretted
infecter13229153infecter
infested12249643infested
inflected1546053inflected
injected18226753injected
invected14258883invected
mafficked2442243mafficked
objected2043493objected
obtected1344553obtected
offended1643653offended
offered1436143offe_red
perfected1736633perfected
reflected1547983reflected
rejected182710113rejected
resected112514743resected
selected1159783selected
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.1531167915.0
2DLD Change Limit146162957.16020413.7
3Display Results95950.0462065.2
 (SQL Overall)178691957.35924282.0
 
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.