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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
retrospectively2572171retrospectively_
introspectively2572213introspectively_
retrospective2083513retrospective___
retrospectives2192783retrospective__s
perspectively2553274pe_r_spectively_
prospectively2553154__prospectively_
respectively2285184re___spectively_
retroactively2153384retro__actively_
introspective2073575introspective___
reproductively2562505repro_ductively_
retrogressively2271755retrogressively_
retrospected1752665retrospect__e__d
retrospecting1863455retrospecti___ng
retrospection1784315retrospecti___on
retrospections1894175retrospecti__ons
detractively2154906detr___actively_
perfectively2554836pe_r__fectively_
perspectival2162136pe_r_spectival__
perspective2054866pe_r_spective___
perspectives2153516pe_r_spective__s
projectively2953986__pro_jectively_
prospective2055406__prospective___
protectively2254726__pro_tectively_
reflectively2354816re___flectively_
refractively2354776refr___actively_
respective1747626re___spective___
restrictively2153826restr___ictively_
retentively1746086ret____entively_
retributively2162326retr__ibutively_
retroactive1645826retro__active___
retroactivity2162786retro__activity_
retrodictive1853876retro_dictive___
retrospect1463836retrospect______
retrospects1562906retrospect_____s
attractively2053587attr___actively_
collectively22114627___collectively_
connectively2255177___connectively_
correctively2254867___correctively_
defectively2345207de____fectively_
destructively2253927destr___uctively_
effectively2554497_e___ffectively_
electively1846387_e____lectively_
eruptively1844857_e_r_up__tively_
extractively2754537extr___actively_
intellectively2262617int_ellectively_
introspected1752847introspect__e__d
introspecting18123577introspecti___ng
introspection1764627introspecti___on
introspectional1972637introspecti_onal
introspections1864067introspecti__ons
introversively2371957intro_versively_
objectively2854587____objectively_
perceptively2454517pe_r__ceptively_
preoperatively2462967pre__o_peratively_
prepositively2352807pre_pos__itively_
productively2353517__pro_ductively_
radioactively22112197radio__actively_
reactively1845887re_____actively_
receptively2165177re____ceptively_
reductively2045167re____ductively_
regressively19124757regr___essively_
remonstratively23172507remonstratively_
repetitively2053527re____petitively_
repressively20155187repr___essively_
reproductive20124337repro_ductive___
reproductives21113297repro_ductive__s
resistively1745037re___s_istively_
respectably2083857re___spect_ably_
respectfully2262487re___spectfully_
respectiveness2155367re___spectiveness
responsively2052747re___sponsively_
restively1548317re___s___tively_
retroflection1854047retroflecti___on
retroflections1953877retroflecti__ons
retrogressive1762647retrogressive___
retroreflective2371307retroreflective___
secretively1954717secr___e_tively_
selectively1945357se____lectively_
serpentinely1752707se_r__pentinely_

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.360496363.9
2DLD Change Limit95024798.97010593.5
3Display Results79790.0631254.0
 (SQL Overall)178691799.39319023.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.