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

82 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
dendrite104878(None) 
dendrites1147931dendrites
dendrimer1343362dendrimer
dendritic1344802dendritic
endite73817592_end_ite
tenorite8311992tenorite
bendwise1443413bendwise
cenobite1246853cenobite
cerite84724873ce__rite
chondrite1545223chondrite
contrite10318543contrite
dandriff1694173dandriff
deadline10139053deadline
deaerate9314173deaerate
dearie73319813de_ari_e
debride1138593de_bride
decorate11315193decorate
definite1239333definite
dehydrate1744863dehydrate
demerit10314993demerit_
demerited1339073demerited
demerits11310763demerits
denari710917353denari__
denarii8389123denari_i
denarius948813denarius
dendrimers1442743dendrimers
dendroid1145923dendroid
dendron947653dendr_on
dendrons1047393dendrons
denervate1346173denervate
denigrate1168693denigrate
denitrate10810533denitrate
denote74118043den__ote
denotive1238673denotive
density1137593den_sity
dentate8315153den_tate
dentine83320243den_tine
denudate1046163denudate
deodorize2045273deodorize
deprive1338303de_prive
depurate1139983depurate
derate74531233de__rate
deride84420033de__ride
derive103817043de__rive
describe1346243describe
despite10410123de_spite
dextrine1688253dextrine
diorite8314913d_iorite
dolerite9611773dolerite
dunite7315013dun__ite
dunnite857333dun_nite
dynamite1444813dynamite
endited93512913_end_ited
endites83717063_end_ites
endive103310473_end_ive
endnote855743_endnote
endrin7312403_endri_n
endrins8312163_endrins
endwise1136463_endwise
eucrite939903_eucrite
ferrite103312753fe_rrite
genderize2065673genderize
generate9312903generate
gentrice1148813gentrice
handwrite1645143handwrite
indite73520323_ind_ite
lenite6719983len__ite
nephrite1346713nephrite
norite63221133__norite
penlite9313243pen_lite
redrive112410563re_drive
rewrite10311143re_write
senorita848283senorita
tenderize1976183tenderize
tendril836783tendri_l
tendriled1143823tendriled
tendrils946443tendrils
tenorites9311093tenorites
tephrite1346593tephrite
venerate11312903venerate
verite94323443ve__rite
wernerite1245173wernerite

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 Filter1786911461620.423422437.4
2DLD Change Limit146162826.42022766.7
3Display Results82820.0332484.8
 (SQL Overall)178691826.87625987.6
 
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.