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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
provocativeness25132191provocativeness_
evocativeness2154164__evocativeness_
productiveness2283284produc_tiveness_
promotiveness2053904promo__tiveness_
protectiveness2154584protec_tiveness_
provocatives2253374provocativ__e_s_
evocativenesses2364295__evocativenesses
preventiveness2294885prev_entiveness_
prohibitiveness2572265prohibitiveness_
promotivenesses22113885promo__tivenesses
provocations1956845provocati_on__s_
provocative2154645provocativ__e___
provocatively2662335provocativ__e_ly
combativeness2254146_co_mbativeness_
cooperativeness2273366cooperativeness_
creativeness1747736cr___eativeness_
decorativeness2054166_decorativeness_
derivativeness2163786deriv__ativeness_
implicativeness2462506implicativeness_
innovativeness2063156_innovativeness_
inoperativeness2073886inoperativeness_
invectiveness2156736_invec_tiveness_
normativeness1854976_no_rmativeness_
operativeness1876646__operativeness_
perfectiveness2455346perfec_tiveness_
pervasiveness2155126perv__asiveness_
positiveness1756476p___ositiveness_
primitiveness2054546pr__imitiveness_
privateness1655706priv__at__eness_
progressiveness2172856progressiveness_
protrusiveness1962946pro_trusiveness_
provableness1955506prov__a_bleness_
provocateurs1961166provocat__e_urs_
provocation1847346provocati_on____
proximateness2462456proximat__eness_
reactiveness1756906_r_eac_tiveness_
reductiveness1955546_reduc_tiveness_
refractiveness2254846_refractiveness_
volatileness1553936___volatileness_
votiveness1646346___vo__tiveness_
abortiveness1755307__abo_rtiveness_
activeness1547697____ac_tiveness_
alternativeness1862607alternativeness_
amativeness1646187____amativeness_
attractiveness1983547attrac_tiveness_
coerciveness1955407_coerc__iveness_
combativenesses2464147_co_mbativenesses
comparativeness2482927comparativeness_
consecutiveness2262807consecutiveness_
corrosiveness1854357corro__siveness_
costiveness1648197___co_stiveness_
creativenesses1967017cr___eativenesses
cumulativeness2162697_cumulativeness_
defectiveness2256547_defec_tiveness_
effectiveness2455677_effec_tiveness_
electiveness1757547__elec_tiveness_
erosiveness1447577er__o__siveness_
evasiveness1755747__ev__asiveness_
fictiveness1946317___fic_tiveness_
figurativeness2162617_figurativeness_
imaginativeness21152527imaginativeness_
imitativeness1864707__imitativeness_
imperativeness2155467_imperativeness_
informativeness2363147informativeness_
invasiveness1855717_inv__asiveness_
invectivenesses23105997_invec_tivenesses
inventiveness1956967_inv_entiveness_
irrevocableness2262407irrevoca_bleness_
lucrativeness1854547__lucrativeness_
meditativeness2062867_meditativeness_
nativeness1357817_____nativeness_
negativeness1656067___negativeness_
normativenesses2084517_no_rmativenesses
novocaines1552587_novoca_i__ne_s_
objectiveness2755157__objectiveness_
operativenesses2055757__operativenesses
perceptiveness2354787p_erceptiveness_
persuasiveness1963457p_ersuasiveness_
pervasivenesses2355157perv__asivenesses
plaintiveness1854077p__laintiveness_
positivenesses1965947p___ositivenesses
possessiveness1763237p_ossessiveness_
preciseness1545787pr__ec__iseness_
prematureness17102557pr__ematureness_
prerogatives1853437prerogativ__e_s_
prevocational2054017prevocati_on__al
primitivenesses2263927pr__imitivenesses
privatenesses1855287priv__at__enesses
privatives18186477priv__ativ__e_s_
probationers1662567pr__obati_oners_
procaines13311517pr__oca_i__ne_s_
profaneness1653587pr__ofa__neness_
profitableness2173807profita_bleness_
prorogations1556707prorogati_on__s_
protonations1449047protonati_on__s_
provablenesses2154857prov__a_blenesses
provocateur1851617provocat____e_ur
proximatenesses2662127proximat__enesses
punitiveness1755357p___unitiveness_
purposiveness2053597purpo__siveness_
reactivenesses1956917_r_eac_tivenesses
receptiveness2056127_r_eceptiveness_
reductivenesses21145697_reduc_tivenesses
reflectiveness2255107_reflectiveness_
repetitiveness1963837_repetitiveness_
resistiveness1656017_r_esistiveness_
respectiveness2155357_respectiveness_
restiveness1449647_r___estiveness_
retentiveness1657137_r_etentiveness_
revocations16410307_revocati_on__s_
rootiness979067_ro_o__ti__ness_
seductiveness1955237_seduc_tiveness_
selectiveness1856507_selec_tiveness_
sportiveness1766967__spo_rtiveness_
subjectiveness2863947subjec_tiveness_
superlativeness20283927superlativeness_
supportiveness2162657suppo_rtiveness_
talkativeness2052977__talkativeness_
tentativeness1654997__tentativeness_
transitiveness1763257tr_ansitiveness_
vegetativeness2173237_vegetativeness_
vindictiveness2363037vindic_tiveness_
vocatives1745887___vocativ__e_s_
volatilenesses1754457___volatilenesses
votivenesses1847557___vo__tivenesses

Search took 9 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.1231452772.4
2DLD Change Limit950241258.48311201.7
3Display Results1251250.0961302.1
 (SQL Overall)1786911258.70220534.5
 
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.