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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 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
denitrate1081053(None) 
denigrate1168691denigrate
denitrated1298031denitrated
denitrates1169511denitrates
denigrated1366972denigrated
denigrates1298112denigrates
dentate8315152den_t_ate
nitrate72017012__nitrate
penetrate1149232penetrate
arbitrate11137373arbitrate
citrate92216803__citrate
deaerate9314173de_aerate
deciduate1345063deciduate
decimate13411123deci_mate
decorate11315193de_corate
dedicate12312803dedi_cate
dehydrate1744863dehydrate
deliberate1347123deliberate
delicate11315493deli_cate
delineate1047793delineate
demonstrate14145913demonstrate
dendrite1048783den_drite
denervate1346173denervate
denigrative1655483denigrative
denigrator1245223denigrator
denitrating13128333denitrating
denitrify1643073denitrify
dentated10411703den_t_ated
denudate1046163den_udate
depilate11311703depi_late
depurate1139983de_purate
derate74531233de___rate
derivate12311203deri_vate
desecrate1249083desecrate
desiccate1445923desiccate
desiderate1246273desiderate
designate1147113designate
desperate12410843desperate
deuterate1049513deuterate
deviate11312713devi__ate
digitate1098683digit_ate
disrate81418523d__israte
edentate947703eden_t_ate
emigrate1149603_emigrate
emirate91015833_emi_rate
fenestrate1345293fenestrate
generate9312903gen_erate
hesitate1169973hesit_ate
initiate8412693_initiate
juniorate1644013juniorate
levirate1147623levi_rate
levitate1137933levit_ate
meditate11310623medit_ate
meliorate1179483meliorate
meniscate1346213meniscate
menstruate1244413menstruate
nitrated92213153__nitrated
nitrates82516223__nitrates
nitrite72314463__nitrite
penetrated1347303penetrated
penetrates1248723penetrates
reinitiate1046043reinitiate
reiterate9412933re_iterate
remigrate1249223remigrate
resituate948613resituate
revibrate1446383revibrate
sanitate8612043sanit_ate
titrate72215573__titrate
venerate11312903ven_erate
ventilate1248383ventilate

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641707.46619909.1
3Display Results70700.0332121.2
 (SQL Overall)178691707.67223291.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.