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

51 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
affectingly235240(None) 
affecting1845232affecting__
affectively2553972affectively
acceptingly2152623acceptingly
affectedly2252153affect_edly
affectional1953893affectional_
affectionally2453013affectionally
affectivity25103253affectivity
arrestingly1552973arrestingly
effecting1845583effecting__
effectively2554493effectively
fleetingly1743593_fleetingly
rejectingly2442943rejectingly
achingly1736624a___chingly
adjectively2753634adjectively
advecting1645114advecting__
affectable2043614affect_able
affection1745894affecti__on
affectionate2072104affectionate
affectionately2571084affectionately
affectioned2052454affectioned
affections1845894affecti_ons
affective20135414affecti__ve
afferently1954004affe_rently
affinely1743864aff___inely
afflicting1943484afflicting__
afflictively2652184afflictively
appealingly1952244appealingly
bafflingly2242214baff__lingly
befittingly2051994befittingly
covetingly1944284cove_tingly
defecting162510224defecting__
defectively2345204defectively
effectivity25103664effectivity
effectually2252654effectually
exactingly2343484_exactingly
feelingly1645104__feelingly
fetchingly2242724_fetchingly
fittingly1645274__fittingly
fleeringly1743724_fleeringly
freezingly2643364_freezingly
infecting15109674infecting__
jestingly2045954__jestingly
meltingly1546304__meltingly
nauseatingly1652094nauseatingly
refecting152413354refecting__
rivetingly1743554rive_tingly
suffocatingly256724suffocatingly
unaffecting2052164unaffecting__
unfeelingly1853134unfeelingly
unweetingly1853144unweetingly

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.423422437.4
2DLD Change Limit148819517.90618823.6
3Display Results51510.0301700.0
 (SQL Overall)178691518.35921377.1
 
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.