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

87 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
prospective205540(None) 
perspective2054862perspective
projective2446812pro_jective
prospecting1845852prospecting
prospectively2553152prospectively
protective1748422pro_tective
respective1747622_respective
inspective1746413_inspective
introspective2073573introspective
perspectives2153523perspectives
proactive1648363pro__active
procreative1846313procreative
productive1845513pro_ductive
projectile2144553pro_jectile
prosecting15189813pros_ecting
prospect1447893prospect___
prospected1744873prospect_ed
prospector1644363prospect_or
prospectors1754583prospectors
prospects1545103prospect__s
prospectus1643413prospect_us
prospectuses1852483prospectuses
protractive1855633protractive
retrospective2083513retrospective
collective1747124_collective
connective1749254_connective
convective2049114_convective
corrective1747444_corrective
erective13311834er___ective
objective2345374__objective
orective1339354__o_rective
perfective2047194p_erfective
persecutive1853934pers_ecutive
perspectival2162134perspectival
perspectively2553274perspectively
phosphatide2264474phosphatide
phosphatize3054494phosphatize
positive1349994p_os__itive
possessive15134314p_ossessive
precative16312574pr___ecative
preceptive1947764pr_eceptive
predictive1847424pr_edictive
preoperative1955754preoperative
prespecify2252444prespec_ify
presumptive2063064presumptive
preventive1847544pr_eventive
probative1649174pro__bative
progressive1755184progressive
prohibitive2152824prohibitive
projectiles2243814pro_jectiles
projecting22177244pro_jecting
projection2158764pro_jection
projectively2953984pro_jectively
promotive1648034pro__motive
propagative1954504propagative
propertied15137264pro_pertied
properties141411894pro_perties
propulsive1753334pro_pulsive
proscribe1585624pros__cribe
proscriptive2152874proscriptive
prosect11313394pros_ect___
prosected14158634pros_ect_ed
prosector13208534pros_ect_or
prosectors14199124pros_ectors
prosects1239474pros_ect__s
prosecute1345954pros_ec_ute
prosecuting1645024pros_ecuting
prosecution1546074pros_ecution
proselytise1652754proselytise
proselytize2552624proselytize
prospering1547174prospe_ring
prosperities1655494prosperities
prosperity1754514prospe_rity
prostie91617744pros___ti_e
protecting151910214pro_tecting
protection14511474pro_tection
protectively2254724pro_tectively
protensive1546204pro_tensive
protractile1554104protractile
provocative2154644provocative
refective1749114_r_efective
reflective1857124_reflective
rejective2148254_r_ejective
resentive12410724_res_entive
respecting1549884_respecting
respectively2285184_respectively
retrospectives2192794retrospectives

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 Filter1786911488190.436409841.7
2DLD Change Limit148819878.87616766.4
3Display Results87870.0461891.3
 (SQL Overall)178691879.35819095.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.