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

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

46 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
resistivenesses175576(None) 
resistiveness1656022resistivene_s_s
restivenesses1679442re__stivenesses
decisivenesses2056763decis_ivenesses
derisivenesses1857233deris_ivenesses
festivenesses1998433fe__stivenesses
positivenesses1965973posi_tivenesses
reactivenesses1956923re_activenesses
receptivenesses22106053receptivenesses
recessivenesses1955813recessivenesses
reductivenesses21145723reductivenesses
retentivenesses1896403retentivenesses
sensitivenesses1775353sensi_tivenesses
assertivenesses1754934assertivenesses
costivenesses1848164__costivenesses
creativenesses1967034cre__ativenesses
deceptivenesses23125894deceptivenesses
defectivenesses2496074defectivenesses
delusivenesses1856544delus_ivenesses
divisivenesses2154964divis_ivenesses
electivenesses1957644_electivenesses
elusivenesses1697704_elus_ivenesses
erosivenesses1648314_eros_ivenesses
evasivenesses1957144_evas_ivenesses
feistinesses1555894fe_isti__nesses
fictivenesses2157124__fictivenesses
fugitivenesses2154454fugi_tivenesses
incisivenesses1966684incis_ivenesses
massivenesses1755914mas_s_ivenesses
negativenesses1855854ne_gativenesses
obsessivenesses18104444obsessivenesses
passivenesses1746664pas_s_ivenesses
pensivenesses1849024pe_ns_ivenesses
plaintivenesses2054314plaintivenesses
primitivenesses2263944primi_tivenesses
punitivenesses1965654puni_tivenesses
reclusivenesses2055284reclusivenesses
recursivenesses2055344recursivenesses
reflexivenesses2893394reflexivenesses
repulsivenesses2064894repulsivenesses
requisitenesses2463514requis_itenesses
restiveness1449664re__stivene_s_s
secretivenesses2055684secretivenesses
seductivenesses21145474seductivenesses
selectivenesses2056004selectivenesses
tentativenesses1854814tentativenesses

Search took 3 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 Filter178691435480.296603685.8
2DLD Change Limit43548462.15620198.5
3Display Results46460.0301533.3
 (SQL Overall)178691462.48271994.8
 
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.