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

52 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
permittivities216243(None) 
perceptivities2363263perceptivities
perfectivities2483873perfectivities
permittivity2271993permittivit__y
primitivities2073563p_rimitivities
emissivities1752954_e_missivities
emotivities1645754_e_m_otivities
periodicities1854904per_iodicities
permeabilities2056844permeabilities
positivities1755454p_osi_tivities
resistivities1694494re_sistivities
sensitivities1654534sensi_tivities
additivities1753115_addi_tivities
aperiodicities1962815aper_iodicities
commutativities2471505commutativities
creativities1755785_cr_eativities
directivities1954195dir_ectivities
effectivities2453855_effectivities
ellipticities1762325_ellipticities
erectilities1447125_er_ectilities
erosivities1455915_er__osivities
femininities1753375fe_mi_ninities
fertilities1448825fer___tilities
festivities1746585fe___stivities
germinabilities2084505germinabilities
heritabilities1958215her_itabilities
hyperactivities2873775hyper_activities
motivities1547695___m_otivities
negativities1654875ne__gativities
overactivities2274465over_activities
partibilities1748095parti_bilities
peritonitis1355105per_i_toniti_s
peritonitises1573325per_i_tonitises
permittees1444245permi_t___tees
perpetuities1653475per_pet_uities
pertinacities1754535perti_nacities
pneumaticities2062385pneum_aticities
prematurities1753015prem_aturities
privities14312045p_r____ivities
proclivities1964685p_r_oclivities
productivities2282595productivities
reactivities1756175__reactivities
receptivities2053905re_ceptivities
reflectivities2263625reflectivities
refractivities22103975refractivities
relativities1555775__relativities
retentivities1654545re_tentivities
retroactivities2062555retroactivities
selectivities1854875se_lectivities
semiaridities1652455se_miaridities
superactivities2283775super_activities
versatilities1656085ver_satilities

Search took 8 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.356501941.0
2DLD Change Limit95024527.26613077.9
3Display Results52520.0301733.3
 (SQL Overall)178691527.65223352.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.