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

53 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
aperiodicities196281(None) 
periodicities1854901_periodicities
aperiodicity2062123aperiodicit__y
ergodicities1653733__ergodicities
apostolicities1861864apostolicities
apriorities1345404ap_rio__rities
hypertonicities2593654hypertonicities
periodicity1954204_periodicit__y
specificities2262594speci_ficities
acridities1348295a_cri_d__ities
aerobicizes2453475a_er_obici_zes
allergenicities1871585allergenicities
anelasticities16163025anelasticities
aperiodic1444065aperiodic_____
aperiodically2154195aperiodic_ally
aphrodites1644995aphr_od__it_es
appendicitis19121705ap_pendiciti_s
appendicitises2161265ap_pendicitises
aridities10911635a__ri_d__ities
atomicities1545955a___tomicities
atonicities1346685a___tonicities
atrocities1248595a_tr_o__cities
chronicities1955125_chr_onicities
erosivities1455915__er_osivities
ferocities1548245_fer_o__cities
hypermobilities2763445hypermobilities
ionicities12410035____ionicities
mendicities1646385_me__ndicities
operabilities17510055oper_abilities
peridotites1454255_peri_dotit_es
periodates1347865_period__at_es
periodicals1664075_periodic__als
periodization2556065_periodization
periodizations2655575_periodizations
periodontics1762435_period_ontics
periostitis1354135_perio_stiti_s
periostitises1553125_perio_stitises
permittivities2162435_permittivities
personalities1556475_personalities
perspicuities1952795_per_spicuities
pertinacities1754535_pertinacities
precocities1748165_preco__cities
predacities1646915_p_r_edacities
priorities1249155_p_rio__rities
prolixities2046365_p_r_olixities
proximities2255885_p_r_oximities
seismicities1653375_se_ismicities
serendipities1662625_serendipities
speciosities1653765specio__sities
sphericities19134205spher___icities
superiorities1556325superio__rities
triplicities1653985__triplicities
veridicalities2063065_veri_dicalities

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.360496363.9
2DLD Change Limit95024536.26615165.0
3Display Results53530.0301766.7
 (SQL Overall)178691536.65626846.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.