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

58 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
discriminative227298(None) 
discriminate17164802discriminat__e
discriminating2063952discriminating
discrimination1955352discrimination
discriminable2063013discrimina_ble
discriminated19154163discriminat_ed
discriminates18174443discriminat_es
discriminations2074603discriminations
discriminator1863283discriminat_or
discriminators1962823discriminators
discriminatory2262503discriminatory
recriminative2053453_recriminative
decriminalize2783464d_ecriminalize
determinative1954074deter_minative
discriminably2362804discrimina_bly
discriminant17113184discrimina__nt
discriminants1872574discrimina_nts
incriminate1554594_incriminat__e
incriminating1854174_incriminating
incrimination17145654_incrimination
indiscriminate1971554indiscriminat__e
assimilative1763175_as_similative
carminative1844885___carminative
criminalize2455285___criminalize
criminate1348985___criminat__e
criminating1646855___criminating
crimination1549415___crimination
decriminalized2982795d_ecriminalized
decriminalizes2893145d_ecriminalizes
denominative1854405d__enominative
descriptive1953685descr__i_ptive
designative1654335des__i_gnative
determinatives2052935deter_minatives
diminutive1653395d____iminutive
disseminate1485545dis_seminat__e
disseminating1754055dis_seminating
dissemination1655795dis_semination
dissimilate14115535dis_similat__e
dissimilating1754415dis_similating
dissimilation1656525dis_similation
dissipative1753815dis___sipative
dissociative18133735dis_soci_ative
distinctive1754935dis___tinctive
distributive1853725distr__ibutive
dominative1677395d____ominative
eliminative1654365___eliminative
germinative1755045__ger_minative
illuminative1763245_i_lluminative
incriminated1754065_incriminat_ed
incriminates1654325_incriminat_es
incriminations18105135_incriminations
incriminatory2062885_incriminatory
originative1553935___originative
recriminate1555235_recriminat__e
recriminating1864935_recriminating
recrimination1757405_recrimination
ruminative1546435____ruminative
terminative1656135__ter_minative

Search took 7 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.373479064.3
2DLD Change Limit95024585.81316346.8
3Display Results58580.0301933.3
 (SQL Overall)178691586.21628746.9
 
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.