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

63 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
effectualities226220(None) 
effectivities2453853effect_ivities
effectuality2382313effectualit__y
effectuates1952533effectua__t_es
eventualities1653513e_ventualities
factualities1754533__factualities
actualities1346824___actualities
affectabilities2553984affectabilities
affectivities2453514affect_ivities
effectualness2171934effectual_ness
effectualnesses2391814effectualnesses
effectuate1852584effectua__t_e_
effectuated2051994effectua__t_ed
effectuating2151784effectua__ting
effectuation2052284effectua__tion
effectuations2151954effectuati_ons
efficacities2252194effic__acities
erectilities1447124e_rect_ilities
essentialities1473244essentialities
punctualities1753464_punctualities
asexualities1994575_ase_xualities
bestialities1455495__bestialities
bisexualities22103635bise_xualities
centralities1448625__centralities
coequalities2355565_coe_qualities
conceptualities2174295conceptualities
dentalities1249545__dent_alities
effectives21134565effect___i_ves
effectual1752765effectual_____
effectually2252655effectual___ly
electabilities1857585e_lectabilities
electricities1755225e_lectricities
electuaries1354235e_lectua__ries
ephemeralities2171785ephemeralities
equalities1949015___e_qualities
etherealities1653695ethe_realities
ethicalities1754445ethic__alities
externalities2055185exte_rnalities
extralities1848235___extralities
farcicalities2053575_farcicalities
fatalities1349445__f_at_alities
fecundities1753335__fec_undities
fertilities1448825__fert_ilities
feudalities1545345__fe_udalities
frontalities1555575_front_alities
ineffectuality2591995ineffectualit__y
inequalities2156145_ine_qualities
infectivities2155125infect_ivities
infertilities1656215infert_ilities
lethalities1446415__le_thalities
mentalities13410025__ment_alities
mutualities1395835___mutualities
neutralities1246465__neutralities
perfectivities2483875perfect_ivities
potentialities1674205potentialities
reflectivities2263625reflect_ivities
sectilities1348695__sect_ilities
sensualities1265945__sensualities
sexualities1857405__se_xualities
specialities1656795_spec_ialities
spiritualities1663695spiritualities
unpunctualities1971385unpunctualities
virtualities1554695__virtualities

Search took 7 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 Filter178691950240.1231452772.4
2DLD Change Limit95024635.86016215.7
3Display Results63630.0461369.6
 (SQL Overall)178691636.02929638.6
 
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.