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

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

115 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
prospectively255315(None) 
perspectively2553272perspectively
projectively2953982pro_jectively
prospective2055402prospective__
protectively2254722pro_tectively
respectively2285182_respectively
introspectively2572213introspectively
productively2353513pro_ductively
retrospectively2572173retrospectively
collectively22114624_collectively
connectively2255184_connectively
correctively2254864_correctively
objectively2854584__objectively
perfectively2554834p_erfectively
perspectival2162134perspectival_
perspective2054864perspective__
perspectives2153514perspective_s
positively1845454p_os__itively
possessively2052974p_ossessively
predictively2384164pr_edictively
preoperatively2462964preoperatively
presumptively2592224presumptively
preventively2354704pr_eventively
progressively2263684progressively
prohibitively2662004prohibitively
projective2446814pro_jective__
proscriptively26121654proscriptively
prospected1744874prospect__e_d
prospecting1845854prospecti__ng
prospectuses1852484prospectuse_s
protective1748424pro_tective__
protensively2053484pro_tensively
provocatively2662334provocatively
reflectively2354814_reflectively
respective1747624_respective__
adjectively2753635__adjectively
adoptively1953325ado_p__tively
affectively2553975__affectively
appositively2252765appos__itively
assertively1774085__assertively
competitively2562815_competitively
consecutively2383255_consecutively
cooperatively2354195_cooperatively
costively1746355_cos___tively
creatively1846675cr___eatively
crescively2053795cres__c_ively
defectively2345205__defectively
dispersively2153515_dispersively
effectively2554495__effectively
electively1846385___electively
eruptively1844855er_up__tively
ineffectively2753135ineffectively
inspective1746405_inspective__
introspective2073575introspective__
invectively2255185__invectively
irruptively1953445irrup__tively
operatively1946275__o_peratively
optatively1864645__o_ptatively
ostensively1753715__ostensively
perceptively2454515p_erceptively
postoperatively2591265p_ostoperatively
postpositively2471395p_ostpositively
precisely1645355pr___ec_isely
predicatively2453525predicatively
preemptively2452955pr_eemptively
preparatively2353645preparatively
prepositively2352805prepositively
prescriptively26122055prescriptively
prespecify2252445prespec_i__fy
primitively2154245pr__imitively
pristinely1544795pris___tinely
privatively2245085pr__ivatively
proactive1648365pro__active__
procreative1846315procreative__
productive1845515pro_ductive__
productivity2362685pro_ductivity
projectile2144555pro_jecti__le
projectiles2243805pro_jectile_s
propertied15137255pro_perti_e_d
properties141411885pro_perti_e_s
prosected14158635pros_ect__e_d
prosecting15189815pros_ecti__ng
prospect1447895prospect_____
prospector1644365prospect___or
prospectors1754585prospect__ors
prospects1545105prospect____s
prospectus1643415prospect___us
prosperities1655485prosperitie_s
prosperity1754515prospe_ri__ty
prosperously1953035prospe_rously
protractive1855635protractive__
protrusively2052525pro_trusively
reactively1845885_r__eactively
receptively2165175_r_eceptively
reductively2045165_r_eductively
refractively2354775_refractively
repetitively2053525_r_epetitively
reproductively2562505repro_ductively
resistively1745035_res_istively
respectably2083855_respect_ably
respectfully2262485_respectfully
responsively2052745_responsively
restively1548315_r___estively
restrictively2153825_restrictively
retentively1746085_r_etentively
retrospective2083515retrospective__
retrospectives2192785retrospective_s
roseately1244315_ros_eat__ely
rotatively1645405_ro__tatively
selectively1945355__selectively
sportively1845025___sportively
subjectively2953565_subjectively
suspensively2052665_suspensively
unassertively1961555unassertively
unselectively2162435unselectively

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901158.48614705.4
3Display Results1151150.0601916.7
 (SQL Overall)1786911158.93619996.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.