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

60 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
vasoactivities227236(None) 
bioactivities2063293_bioactivities
radioactivities21132003radioactivities
vasoactivity2361633vasoactivit__y
absorptivities2161894absorptivities
activities1548904____activities
adaptivities1853124_a_daptivities
affectivities2453514_affectivities
inactivities1755584__inactivities
overactivities2274464overactivities
reactivities1756164__reactivities
refractivities22103964refractivities
retroactivities2062554retroactivities
vasoactive1852474vasoactiv___e_
acclivities1844375_a__cclivities
additivities1753115_a_dditivities
aromaticities1754685_aromaticities
associativities2091505associativities
captivities1845935___captivities
castabilities1748795casta_bilities
collectivities2174165collectivities
conductivities2283565conductivities
connectivities2164475connectivities
creativities1755765_crea_tivities
destructivities2162495destructivities
directivities1954195_directivities
effectivities2453855_effectivities
emotivities1645755_emo__tivities
facticities1846875___facticities
festivities1746575fes___tivities
hyperactivities2873745hyperactivities
infectivities2155125_infectivities
motivities1547695__mo__tivities
nativities1348435___na_tivities
negativities1654875_nega_tivities
objectivities2754315_objectivities
passivities1644905pas___sivities
perfectivities2483875perfectivities
positivities1755455__positivities
proclivities1964675_pro_clivities
productivities2282595productivities
reflectivities2263625reflectivities
relativities1555765_rela_tivities
resistivities1694485res_istivities
retractilities1674075retractilities
sectilities1348685__s_ectilities
selectivities1854865_selectivities
spasticities1654615__spasticities
subjectivities2863405subjectivities
superactivities2283765superactivities
susceptivities2162615susceptivities
tactilities1347665___tactilities
underactivities2162745underactivities
variabilities1848635varia_bilities
vastities1248935vas___t__ities
versatilities1656075versa_tilities
viscidities1744465vis__c_idities
volatilities1546515v__olatilities
vorticities1647085v__o_rticities
washabilities2145985washa_bilities

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 Filter178691950240.1101624463.6
2DLD Change Limit95024609.31010206.7
3Display Results60600.0331818.2
 (SQL Overall)178691609.45318903.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.