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

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
derive10381704(None) 
deprive1338301deprive
deride84420031deride
derived123912761derived
deriver114213911deriver
derives114017811derives
drive95318001d_rive
aerie54634602aeri_e
arrive91311792arrive
belive115415302belive
berime105317332berime
cerise84822042cerise
cerite84724872cerite
coderive1447692coderive
dative10311812dative
dearie73319812deari_e
deave95022332de_ave
debride1138592debride
deceive1337812deceive
decide104116872decide
decile94619212decile
defile105216662defile
define104718142define
deice84320032de_ice
delime9314042delime
deliver113312242deliver
delve96018262de_lve
demise94618322demise
deprave1337072deprave
deprived1546462deprived
depriver1446292depriver
deprives1438392deprives
derate74531232derate
dere56845902der__e
derided102914252derided
derider93214972derider
derides93420852derides
derisive1247502derisive
derivate12311202derivate
derivers123811362derivers
desire7415302desire
device124512162device
devise104215752devise
dexie134716892dexi_e
dive85634772d__ive
drave95219272d_rave
drivel105110382d_rivel
driven105210142d_riven
driver104714492d_river
drives105117112d_rives
drove95518062d_rove
eerie55228532eeri_e
feriae95618602feriae
ferine96422582ferine
nerve86617372ner_ve
redrive112410562redrive
regive104814322regive
reive85522942re_ive
relive95120782relive
rerise64325632rerise
revive124914822revive
rive75537722__rive
scrive115414942scrive
serine65432672serine
serve85425962ser_ve
shrive125216952shrive
strive95020962strive
thrive125313222thrive
verite94323442verite
verve115417722ver_ve

Search took 3 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 Filter178691825510.373479064.3
2DLD Change Limit82551702.20337472.1
3Display Results70700.0164375.0
 (SQL Overall)178691702.59268939.4
 
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.