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

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

89 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
affectively255397(None) 
effectively2554491effectively
adjectively2753632adjectively
affectingly2352402affectingly
affective20135412affective__
affectivity25103262affectivity
afflictively2652182afflictively
defectively2345212defectively
actively1647063a___ctively
affectedly2252153affect_edly
assertively1774083assertively
attentively1753863attentively
effective2076193effective__
effectives21134563effective_s
effectivity25103673effectivity
electively1846383_electively
festively1845773__festively
fictively2044603__fictively
ineffectively2753133ineffectively
invectively2255183invectively
objectively2854583objectively
offensively2352773offensively
perfectively2554833perfectively
reflectively2354813reflectively
selectively1945353selectively
ablatively1844444a_blatively
abortively1844344a_bortively
adaptively1953054a_daptively
additively1853434a_dditively
adhesively2052704adhe_sively
adjectival2351834adjectival_
adjectivally2851364adjectivally
adjective2244814adjective__
adjectives2343734adjective_s
adoptively1953324a_doptively
advective1845234advective__
affectable2043614affect_able
affected1744794affect__e_d
affecter1644524affect__e_r
affecters1763934affect__ers
affecting1845234affecti__ng
affection1745894affecti__on
affectional1953894affectional
affectionally2453014affectionally
affectionately2571084affectionately
affectioned2052454affectioned
affections1845894affecti_ons
affectless1842134affect_less
affinely1743864aff___inely
affirmatively2761814affirmatively
afflictive21102804afflictive__
amatively1745084a__matively
attractively2053584attractively
aversively1964084a_versively
collectively22114624collectively
connectively2255184connectively
correctively2254864correctively
creatively1846674_creatively
deceptively22104534deceptively
deductively2154284deductively
defective1848004defective__
defectives1945684defective_s
defensively2154164defensively
digestively1953904digestively
effectually2252654effectually
effetely1742694effe_t__ely
effusively2252864eff_usively
factitively2252854factitively
fertilely1544274__fertilely
fugitively2053194_fugitively
furtively1844844__furtively
inactively1845314_inactively
inceptively2155254inceptively
inductively2054794inductively
infective17108974infective__
infectivity2254714infectivity
inventively2045754inventively
projectively2953984projectively
protectively2254724protectively
reactively1845884_reactively
receptively2165174receptively
reductively2045164reductively
refective1749114refective__
refractively2354774refractively
respectively2285184respectively
restively1548314__restively
retentively1746084retentively
seductively2054294seductively
subjectively2953564subjectively

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819898.40617703.9
3Display Results89890.0501780.0
 (SQL Overall)178691898.87620131.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.