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

116 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
perspectively255327(None) 
perfectively2554832per_fectively
perspectival2162132perspectival_
perspective2054862perspective__
perspectives2153522perspective_s
prospectively2553152prospectively
respectively2285182re_spectively
perceptively2454513per_ceptively
projectively2953983p_rojectively
protectively2254723p_rotectively
retrospectively2572173retrospectively
correctively2254864cor_rectively
defectively2345214de__fectively
effectively2554494_e_ffectively
electively1846384_e__lectively
eruptively1844854_erup__tively
introspectively2572214introspectively
perfective2047194per_fective__
perfectives2145474per_fective_s
perfectivity2563854per_fectivity
persecutive1853934pers_ecutive__
persuasively2092734pers_uasively
predictively2384164p_redictively
preoperatively2462964preoperatively
presumptively2592224presumptively
preventively2354704p_reventively
productively2353514p_roductively
prospective2055404prospective__
reflectively2354814re_flectively
respective1747624re_spective__
selectively1945354se__lectively
serpentinely1752714ser_pentinely
adjectively2753635__adjectively
affectively2553975__affectively
assertively1774085__assertively
collectively22114625_collectively
connectively2255185_connectively
consecutively2383255cons_ecutively
creatively1846675_cr__eatively
crescively2053795cres__c_ively
deceptively22104535de__ceptively
deductively2154285de__ductively
derivatively2264315der_ivatively
destructively2253925destructively
detractively2154905de_tractively
dispersively2153525_dispersively
erective13311835_er__ective__
especially1744995_e_spec_ially
expensively2654105_e_xpensively
extractively2754535_extractively
festively1845775fe_s___tively
ineffectively2753135ineffectively
inspective1746415_inspective__
invectively2255185__invectively
irruptively1953445irrup__tively
objectively2854585__objectively
operatively1946275oper___atively
partitively1954145par__titively
pejoratively2753675pe_joratively
pensively1745915pens____ively
perceptibly2253155per_cepti_bly
perceptive1946805per_ceptive__
perceptivity2453425per_ceptivity
percussively2252775per_cussively
perfectible2053435per_fecti_ble
perfectly1944115per_fect___ly
peripeties1448405peripe_ti_e_s
permeative1748525per_meative__
permissively2252555per_missively
perpetually1853865per_pe_tually
personative1647075personative__
perspicuity2052175perspicui__ty
perspicuously2262365perspicuously
pervasively2253325per__vasively
positively1845455p_os__itively
possessively2052975p_ossessively
precisely1645355p_r__ec_isely
predicatively2453525predicatively
preemptively2452955p_reemptively
preparatively2353645preparatively
prepositively2352805prepositively
prescriptively26122055prescriptively
prespecify2252445prespec_i__fy
primitively2154245p_r_imitively
privatively2245085p_r_ivatively
projective2446815p_rojective__
protective1748425p_rotective__
protensively2053485p_rotensively
provocatively2662335p_rovocatively
purposively2152355pur_p_osively
reactively1845885__r_eactively
receptively2165175__receptively
reductively2045165__reductively
refractively2354775re_fractively
repetitively2053525__repetitively
reproductively2562505reproductively
resistively1745035re_s_istively
respectably2083855re_spect_ably
respectfully2262485re_spectfully
responsively2052745re_sponsively
restively1548315__r__estively
restrictively2153825restrictively
retentively1746085__retentively
retroactively2153385retroactively
retrospective2083515retrospective__
retrospectives2192795retrospective_s
secretively1954715se_cre_tively
seductively2054295se__ductively
sensitively1754995sens__itively
sportively1845025___sportively
subjectively2953565_subjectively
suspensively2052665_suspensively
terminatively2153175terminatively
unassertively1961555unassertively
unselectively2162435unselectively
versatilely1751945vers__atilely

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 Filter1786911247900.403443402.0
2DLD Change Limit1247901169.25313486.4
3Display Results1161160.0761526.3
 (SQL Overall)1786911169.73218361.2
 
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.