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

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

64 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
retrospective208351(None) 
retrospectives2192781retrospectives
introspective2073572introspective
retrospecting1863452retrospecting
retrospection1784312retrospection
retrospectively2572172retrospectively
perspective2054863pe_r_spective
prospective2055403__prospective
respective1747623re___spective
retroactive1645823retro__active
retrodictive1853873retro_dictive
retrospect1463833retrospect___
retrospected1752663retrospect_ed
retrospections1894173retrospections
retrospects1562903retrospect__s
introspecting18123574introspecting
introspection1764624introspection
introspectively2572214introspectively
perspectives2153514pe_r_spectives
reproductive20124334repro_ductive
retroflection1854044retroflection
retrogressive1762644retrogressive
retroreflective2371304retroreflective
detective1548105det____ective
detractive1647375detr___active
erective13311835_e_r___ective
inspective1746405___inspective
introspect1474385introspect___
introspected1752845introspect_ed
introspections1864065introspections
introspects15103035introspect__s
neuroactive1653885neuro__active
neuropeptide1762795neuro_peptide
perfective2047195pe_r__fective
persecutive1853935pe_r_s_ecutive
perspectival2162135pe_r_spectival
perspectively2553275pe_r_spectively
projective2446815__pro_jective
prospecting1845855__prospecting
prospectively2553155__prospectively
protective1748425__pro_tective
recreative1549025recr___eative
refective1749115re____fective
reflective1857125re___flective
refractive1846695refr___active
reinspecting1763205re_inspecting
reinspection1653265re_inspection
rejective2148255re____jective
reprobative1855645repro__bative
reproductives21113295repro_ductives
resentive12410725re___s_entive
resorptive1544765re_sorp__tive
respecting1549885re___specting
respectively2285185re___spectively
restrictive1646365restr___ictive
retentive1249855ret____entive
retractile1246255retr___actile
retributive1653515retr__ibutive
retroacting1447285retro__acting
retroaction1347365retro__action
retroactively2153385retro__actively
retrodicting1654465retro_dicting
retrodiction1555655retro_diction
retroflections1953875retroflections

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.406440125.6
2DLD Change Limit124790649.07613749.4
3Display Results64640.0461391.3
 (SQL Overall)178691649.52818754.3
 
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.