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

97 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
discriminates1817444(None) 
discriminate17164801discriminate_
discriminated19154161discriminated
discriminants1872572discriminants
discriminator1863282discriminator
discriminators1962822discriminators
incriminates1654322_incriminates
criminates1448003___criminates
discriminable2063013discriminable
discriminably2362803discriminably
discriminant17113183discrimina_nt
discriminating2063953discriminating
discrimination1955353discrimination
discriminations2074603discriminations
discriminative2272983discriminative
discriminatory2262503discriminatory
disseminates1585083dis_seminates
dissimilates15125193dis_similates
incriminate1554593_incriminate_
incriminated1754063_incriminated
indiscriminate1971553indiscriminate_
recriminates1654883_recriminates
criminate1348984___criminate_
criminated1546824___criminated
disclimaxes2352244disclim__axes
disorientates1462854disorientates
disseminate1485544dis_seminate_
disseminated1684484dis_seminated
dissimilate14115534dis_similate_
dissimilated16114734dis_similated
dissimulates15124724dis_simulates
recriminate1555234_recriminate_
recriminated1754494_recriminated
acuminates1446885__ac_uminates
assimilates1354415_as_similates
brominates1448015___brominates
criminals1346295___crimina_ls
culminates1447055___culminates
deaminates1349385d___eaminates
decimates14410695d_ec_im__ates
decrepitates1793075d_ecrepitates
decriminalizes2893145d_ecriminalizes
delaminates1456905d__elaminates
denominates14167205d__enominates
deracinates1445865d__eracinates
desalinates1246215des__alinates
designates1246365des__i_gnates
determinate1446625deter_minate_
diaconates1346705diac___onates
dichromates1956075dichrom__ates
dimidiates1444605di__midi_ates
disaffiliates2062525disaffili_ates
disarticulates1773695disarticulates
discarnate1346045disc__arnate_
discernments1785195discernmen_t_s
disciplines1654635disciplin__es
discontinues1564395discontin_ues
discredited1653605discredi__ted
discredits1453775discredi__t_s
discrepancies2061775discrepancies
disorientate1363385disorientate_
disorientated1562365disorientated
disoriented1355265disori_en_ted
disorients1177795disori_en_t_s
disrates91118155dis_r____ates
disseminator1553515dis_seminator
disseminators1653085dis_seminators
disseminules1552295dis_seminules
dissimilars1462965dis_simila_rs
dissimulate14114975dis_simulate_
dissimulated16104385dis_simulated
dissipates1346555dis___sipates
dissociates1455785dis_soci_ates
distillates1246155dis_ti_llates
distraints1166875distr_ain_t_s
distributes14135285distr__ibutes
divaricates1743875divar__icates
dominates12311745d____ominates
eliminates1246975___eliminates
exterminates2154295exter_minates
fascinates1547155fasc___inates
germinates1347765__ger_minates
histaminases1752115his_taminases
illuminates1345085_i_lluminates
incriminating1854175_incriminating
incrimination17145655_incrimination
incriminations18105135_incriminations
incriminatory2062885_incriminatory
inseminates1345895_i_nseminates
intimidates14125745_i_ntimidates
micromanages1984105mi_cromanages
miscreates1448105miscr___eates
noncriminals1693035noncrimina_ls
originates1145965___originates
ruminates11410195____ruminates
scrimmages1742355__scrim_mages
terminates12410005__ter_minates

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.1401276364.3
2DLD Change Limit124790978.87314064.0
3Display Results97970.0631539.7
 (SQL Overall)178691979.07619688.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.