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

78 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
deverbative205362(None) 
deverbatives2152171deverbatives
adversative1853243adversative
decorative1648923decor_ative
deformative2044973deformative
devastative1853433devastative
deviative1647723dev__iative
federative1746163feder_ative
generative1458563gener_ative
rebarbative1852893rebarbative
reverberative2162133reverberative
revertive1548853rever__tive
adversatives1952474adversatives
alternative1454684alternative
asseverative1852324assever_ative
deaerate9314174deaer_at__e
deaerating12311564deaer_ating
deaeration11313014deaer_ation
deceptive1746854dece__ptive
declarative1754314declarative
decretive1547494de_cr_etive
defective1848004defe__ctive
degenerative1754964degenerative
degradative1763084degradative
deliberative1854054deliber_ative
delineative1554664delineative
denervate1346174denervat__e
denervating1645924denervating
denervation1567944denervation
denigrative1655484denigrative
denotative1456724de_notative
depreciative2084084depreciative
derivative1746684de_rivative
derogative1546984de_rogative
descriptive1953684descriptive
desiccative1953944desiccative
desiderative1753684desider_ative
designative1654334designative
destructive1755694destructive
detective1548104dete__ctive
deteriorative1762584deteriorative
determinative1954074determinative
detersive1346344deter__sive
detonative1447134de_tonative
detractive1647374de_tractive
deverbal1444484deverba___l
deverbals1544104deverba__ls
durative1239074d__ur_ative
ergative1238974___ergative
evacuative1843734_evacuative
evaluative1644234_evaluative
evocative1746294_ev_ocative
execrative2246044_execrative
exertive1839084_exer__tive
imperative1748564imper_ative
iterative12410714_iter_ative
lacerative1556284lacer_ative
operative141110554_oper_ative
overactive1847264_overactive
pejorative2245694pejor_ative
penetrative1646114penetrative
preservative2053954preservative
preventative2054314preventative
recreative1549024re_creative
reformative1945674reformative
reiterative1447534reiter_ative
reparative1548174repar_ative
reprobative1855644reprobative
segregative1654064segregative
separative1546974separ_ative
superlative1648254superlative
tolerative1346254toler_ative
ulcerative1545174ulcer_ative
vegetative1744574vege_tative
verbalize2348834__verbalize
verbatim1545034__verbati_m
versatile1245164__versatile
vibrative1745584__vibrative

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 Limit148819788.76316982.7
3Display Results78780.0461695.7
 (SQL Overall)178691789.24919320.0
 
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.