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

83 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
analyticities186250(None) 
analyticity1952343analyticit__y
anelasticities16163023anelasticities
adaptivities1853124ada_ptivities
analcites1147484anal___cit_es
analities9715874anal____ities
analytics1445514analytic____s
analyzabilities2952714analyzabilities
aromaticities1754714aromaticities
causticities1654004_causticities
elasticities1455104ela_sticities
facticities1846874_fa_cticities
inactivities1755594ina_ctivities
inelasticities16162924inelasticities
nativities1348434_na__tivities
plasticities1655554pla_sticities
spasticities1654624spa_sticities
acclivities1844375accl__ivities
activities1548905__a_ctivities
additivities1753115a_dditivities
affectivities2453515affectivities
algidities1245955__al_gidities
alkalinities1653005alkal__inities
alterities10411045__al_terities
analcimes1344325anal___ci_mes
analcite1049335anal___cit_e_
analytes11169205analy____t_es
analytic1348185analytic_____
analytical1554265analytic___al
analytically2055865analytic_ally
anglicises1344405angl__ici_ses
anglicizes2243715angl__ici_zes
anilities9516005an____ilities
anonymities1653125anony__mities
anticaries12412475an___ticaries
antigenicities1763715antigenicities
antiquities2056625an___tiquities
arabilities13413105ara__bilities
atomicities1545955__atomicities
atonicities1346685__atonicities
authenticities1963435authenticities
automaticities1862965automaticities
availabilities1955755availabilities
banalities1249815banal____ities
basicities1446865_ba__sicities
canonicities1654705_canonicities
captivities1845945_ca_ptivities
clonicities1546185__clonicities
cyclicities1754705cycl__icities
domesticities1863805domesticities
duplicities1645335dupl__icities
ellipticities1762325ellipticities
endemicities1754025en_demicities
fanaticizes2553425fana__tici_zes
felicities1549745_fel__icities
helicities1549855_hel__icities
inabilities13412755ina__bilities
infantilities1665265infantilities
infectivities2155125infectivities
infelicities1755105in_felicities
infertilities1656215infertilities
inutilities1148185in__utilities
invalidities1653905inval__idities
latinities10410165___latinities
natalities10410665_na__talities
negativities1654875_negativities
nonutilities1256685_nonutilities
pneumaticities2062385pneumaticities
prolificities2053475prolificities
publicities1745485publ__icities
reactivities1756175rea_ctivities
relativities1555775_relativities
rusticities1346845__rusticities
salabilities1449615_salabilities
salacities1248245_sal__acities
salinities10410955_sal__inities
septicities1547315__septicities
syllabicities2062915syllabicities
tactilities1347675_ta_ctilities
unanimities1344815una__nimities
validities1447305_val__idities
volatilities1546515_volatilities
vorticities1647095__vorticities

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 Filter1786911247900.406440125.6
2DLD Change Limit124790839.17313604.1
3Display Results83830.0631317.5
 (SQL Overall)178691839.64218532.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.