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

54 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
affectivity2510326(None) 
effectivity25103671effectivity
affectively2553972affectively
infectivity2254712infectivity
activity1647593a___ctivity
affectability2663853affectability
affectingly2352403affectingly
affective20135413affectiv__e
affectivities2453513affectivities
directivity2054103directivity
effectively2554493effectively
festivity1845113__festivity
objectivity2853953objectivity
perfectivity2563853perfectivity
reflectivity2353823reflectivity
selectivity1954793selectivity
acclivity1943264a__cclivity
adaptivity1952554a_daptivity
additivity1852744a_dditivity
adjectively2753634adjectively
affability2145694aff_ability
affectation1943844affectation
affectedly2252154affect_edly
affecting1845234affect__ing
affection1745894affect__ion
affectional1953894affectional
affectionate2072104affectionate
affectioned2052454affectioned
affections1845894affecti_ons
affinity1744994aff___inity
afflictively2652184afflictively
bioactivity2152584bioactivity
collectivity2254234collectivity
connectivity2254554connectivity
creativity1845174_creativity
declivity1844494__declivity
defectively2345214defectively
effective2076194effectiv__e
effectives21134564effectiv_es
effectivities2453854effectivities
effectuality2382314effectuality
erectility1546264_erectility
facticity1945964__facticity
fertility1547214__fertility
fetidity1545864__fe_tidity
inactivity1854704_inactivity
infertility1755484infertility
reactivity1845404_reactivity
receptivity2153884receptivity
refractivity2353514refractivity
retentivity1754184retentivity
sectility1447374__sectility
subjectivity2973534subjectivity
vasoactivity2361634vasoactivity

Search took 10 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 Limit148819548.62617252.4
3Display Results54540.0301800.0
 (SQL Overall)178691549.07619688.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.