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

101 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
determinatives205293(None) 
determinative1954071determinative_
determinacies1853192determinaci_es
determinations1766892determinations
denominatives1952653de_nominatives
determinate1446623determinat__e_
determinateness1861843determinateness
determination1657643determinati_on
determinators1653893determinat_ors
terminative1656133__terminative_
alternatives1553254alter__natives
carminatives1953364__carminatives
denominative1854404de_nominative_
derivatives1844644d__er_ivatives
deteriorative1762584deteriorative_
determinable1754024determina_ble_
determinants1553474determina__nts
determinately1953194determinat_ely
determinator1554574determinat__or
determines1358434determin____es
determinisms1753354determin__isms
determinists1553704determin__ists
deverbatives2152174dever__batives
exterminates2154294exterminat__es
exterminations2365124exterminations
germinative1755044__germinative_
indeterminacies2061814indeterminaci_es
preterminations1954304preterminations
terminates12410004__terminat__es
terminations14149764__terminations
terminatively2153174__terminatively
veterinaries1553194veter_inari_es
alternative1454685alter__native_
carminative1844895__carminative_
codetermination2062125codeterminati_on
deaminates1349385d__eaminat__es
deaminations151010135d__eaminations
decriminalizes2893145decriminalizes
defeminizes2653745defe_min__izes
definitives1844215d__e_finitives
deformative2044975deform__ative_
deformities1744285deformi__ti_es
delaminates1456905de_laminat__es
delaminations1647945de_laminations
denominates14167205de_nominat__es
denominations16117855de_nominations
depersonalizes26113285depersonalizes
depreciative2084085depreci_ative_
derivative1746685d__er_ivative_
derivatizes2445155d__er_ivatizes
detectives1645785dete____ctives
detergencies1654355detergen_ci_es
deteriorates1354445deteriorat__es
deteriorations15164695deteriorations
determents131010315determen_t___s
determinably2053545determina__bly
determinacy1953085determina___cy
determinant1454735determina___nt
determinantal1661905determina_ntal
determine1249035determin____e_
determined1455825determin____ed
determinedness1861705determinedness
determiner1345485determin____er
determiners1444645determin___ers
determining1545295determin__i_ng
determinism1654065determin__i_sm
determinist1455205determin__i_st
deterministic1862415deterministi__c
detersives1444955deter____sives
detonative1447135det___onative_
detribalizes2454555det_r_ibalizes
deverbative2053625dever__bative_
dexterities1945815dexter_i__ti_es
diminutives1752585d___iminutives
discriminative2272985discriminative_
dominative1677395d___ominative_
eliminative1654365_e_liminative_
eternalizes20118175_eter__nalizes
eternities1048065_eter__niti_es
eternizations2258075_eternizations
exterminate2054545exterminat__e_
exterminated2253605exterminat__ed
exterminating2373865exterminati_ng
extermination2275745exterminati_on
exterminators2252965exterminat_ors
germinates1347765__germinat__es
germinations15137945__germinations
indeterminate1652985indeterminat__e_
indetermination1863135indeterminati_on
interrogatives18133475interrogatives
nominatives1694775___nominatives
pretermination1854775preterminati_on
recriminative2053455recriminative_
redetermination18102295redeterminati_on
terminate11411205__terminat__e_
terminated1348165__terminat__ed
terminating1447355__terminati_ng
termination131311165__terminati_on
terminators1346035__terminat_ors
termitaries1345695__termitari_es
veterinarians1662805veter_inarians

Search took 8 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.376475242.0
2DLD Change Limit950241016.70314176.3
3Display Results1011010.0761328.9
 (SQL Overall)1786911017.15524974.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.