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

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

109 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
retroactive164582(None) 
detractive1647372detr_active
neuroactive1653882neuroactive
refractive1846692refr_active
retractile1246252retr_actile
retroacting1447282retroacting
retroaction1347362retroaction
retroactively2153382retroactively
retrodictive1853872retrodictive
attractive1545553attr_active
extractive2246603extr_active
nonretroactive1962033nonretroactive
proactive1648363__proactive
protractive1855633protr_active
radioactive1753313radioactive
reactive13310473re___active
recreative1549023recrea_tive
refractile1544143refr_actile
reprobative1855643reprobative
reproductive20124333reproductive
restorative1446943restora_tive
restrictive1646363restr_ictive
retracting13311933retr_acting
retraction121310533retr_action
retributive1653513retributive
retroact10410003retroact___
retroacted1366133retroact_ed
retroactions1447073retroactions
retroactivity2162783retroactivity
retroacts1146283retroact__s
retrospective2083513retrospective
tractive13310043__tr_active
abstractive1854894abstr_active
bioactive1644134__bioactive
coactive1598624___coactive
contractive1849524contr_active
decoctive1745864de_co_ctive
decorative1648924decora_tive
derogative1546984de_rogative
destructive1755694destr_uctive
detective1548104det__ective
detonative1447134det_onative
detracting1438714detr_acting
detraction13138584detr_action
detractively2154904detr_actively
distractive1746774distr_active
enactive1338514_e__nactive
erective13311834_e_r_ective
ergative1238974_e_rga_tive
evocative1746294_e_vocative
extractives2354554extr_actives
interactive1659634interactive
iterative12410714iter_a_tive
nonreactive1645954nonreactive
overactive1847264over_active
pejorative2245694pejora_tive
perfective2047194pe_rfective
prerogative1755354pre_rogative
protractile1554104protr_actile
putrefactive2251484putrefactive
rebarbative1852894rebarba_tive
reciprocative2262044reciprocative
recitative1548184recita_tive
reconceive1745294re_conceive
reductive1547794re__ductive
reeducative1753514reeducative
refective1749114re__fective
reflective1857124re_flective
reformative1945674reformative
refracting1638734refr_acting
refraction15137904refr_action
refractively2354774refr_actively
regulative1446984regula_tive
reiterative1447534reitera_tive
rejective2148254re__jective
relative11313144re__la_tive
renovative1645434re_novative
reparative1548174repara_tive
replicative1846084replicative
reproaching1944304reproaching
reproductives21113294reproductives
resorptive1544764re_sorptive
respective1747624re_spective
restoratives1554154restora_tives
restrictives1755084restr_ictives
retaliative1454984retaliative
retentive1249854ret__entive
retrace91417344retr_ac___e
retracing12313294retr_ac_ing
retracking1738164retr_acking
retract91318114retr_act___
retractable1545124retr_actable
retracted12410954retr_act_ed
retractions13910354retr_actions
retractor11218514retr_act_or
retractors12158584retr_actors
retracts101111314retr_act__s
retreating111414774retrea_ting
retroactivities2062554retroactivities
retrocede1245404retro_c_ede
retrodicting1654464retrodicting
retrodiction1555654retrodiction
retrofire1244544retro__fire
retrospectives2192784retrospectives
rotative11310344rot__a_tive
subtractive1854664subtr_active
tetracaine1245194tetr_acaine
tractile10311074__tr_actile
vasoactive1852474_vasoactive

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.440406115.9
2DLD Change Limit1488191098.90616710.0
3Display Results1091090.0601816.7
 (SQL Overall)1786911099.40618997.6
 
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.