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

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

61 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
affectionless216187(None) 
actionless1244143a___ctionless
affectedness2153203affectedn_ess
affectioned2052453affection_e_d
affections1845893affection___s
affectless1842133affect___less
directionless1661923directionless
frictionless1752553_frictionless
functionless1752413_functionless
affection1745894affection____
affectional1953884affection__al
affectionally2453014affectionally
affectionate2072104affection_ate
affectionately2571084affectionately
ambitionless1661664a_mbitionless
effectiveness2455674effectiveness
effectualness2171934effectualness
questionless2152004_questionless
abjections2145675abjection___s
abjectness2152185abject__n_ess
actioners1147725a___ction_ers
advections1645555advection___s
affectable2043615affect_able__
affectations2043435affectation___s
affectednesses2382605affectednesses
affecters1763935affect____ers
affecting1845235affecti_n___g
affectingly2352395affecti_n_gly
affective20135415affecti__ve__
affectively2553975affecti__vely
affectivities2453515affectivities
affectlessness2271915affectlessness
afficionados21181225affic_ionados
afflictions1943405affliction___s
auctioneers1362275a__uctioneers
captionless1552505__captionless
cohesionless1752015cohe_sionless
confectioners2073375confection_ers
defections161510205defection___s
defectiveness2256545defectiveness
dimensionless1661555dimensionless
effectives21134565effecti__ve_s
effeteness1643675effe_t_en_ess
electioneers1453695_electioneers
electroless1356005_electro_less
emotionless1352855__emotionless
fetidness1345445__fe_tidn_ess
fictioneers1652685__fictioneers
flections14239215_flection___s
frictionlessly226705_frictionlessly
infections15510235infection___s
infectiousness1954305infectiousness
motionless1243485___motionless
pensionless1353175__pensionless
portionless1344025__portionless
radiationless1481685radiationless
refections151811645refection___s
tensionless1152675__tensionless
traditionless1462085traditionless
unaffectedness2372085unaffectedn_ess
vibrationless1861425vibrationless

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 Filter1786911247900.1401276364.3
2DLD Change Limit124790618.72014310.8
3Display Results61610.0302033.3
 (SQL Overall)178691618.89020100.2
 
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.