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

95 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
dendron94765(None) 
dendrons1047391dendrons
dendroid1145922dendroid
dewdrop1442812dewdrop
endrin7312402_endrin
fenuron1075152fenuron
tendon7312032tend_on
andiron848283_andiron
andro6314163_andro_
andros7313303_andros
benison937123benison
benthon1237693benthon
caldron1038153caldron
dacron94310693d_acron
deacon9510423de_acon
deaden83714323dead_en
deadman11238423deadman
deadmen11248573deadmen
deadpan11225233deadpan
decagon1135863decagon
decern91310953decer_n
decrown13206053de_crown
decurion1146623decurion
dehorn10439653dehor_n
demeton1037683demeton
demon86520313de__mon
denar65223293denar__
denari710917353denar_i
denarii8389123denarii
denars74621433denar_s
denary105316863denar_y
dendrite1048783dendrite
denizen1737663denizen
dentin73919573den_tin
destroy1138153destroy
dethrone1247563dethrone
deuteron945993deuteron
devon95113683de__von
dewdrops1542963dewdrops
dextran1586163dextran
dextrin1587543dextrin
dextro1436123dextro_
diatron839283diatron
dieldrin1093983dieldrin
dihedron13104113dihedron
dinero75612643dinero_
dineros83812333dineros
diuron738573d_iuron
donjon1436463don_jon
dungeon9134553dungeon
dynatron1243623dynatron
endlong934823_endlong
endow94510983_end_ow
endrins8312163_endrins
enduro7338623_enduro_
enduros8298153_enduros
enrol51014283_en_rol
enteron7313333_enteron
environ1044763_environ
fenurons1174963fenurons
genro64914033gen_ro_
genros74211333gen_ros
hadron102913753_hadron
heron85025503he__ron
intron64215023_intron
kendo105113223kend_o_
kendos114510663kend_os
kenotron1244463kenotron
ladron73413323_ladron
linuron746513linuron
megaron10248303megaron
menazon1846053menazon
mention9314373mention
monuron937463monuron
nephron1246653nephron
neuron6310373ne_uron
neutron737763neutron
noniron738373noniron
pedro8313153pe_dro_
pedros9312183pe_dros
pendragon1352283pendragon
pennon8310643pen_non
pension9412203pension
perron83216623pe_rron
readorn8310473readorn
redon65424883re_d_on
tendons8311473tend_ons
tendril836783tendril
tenon53320513ten__on
tension7311803tension
vendor10359803vend_or
vendors113510223vendors
venison1036443venison
windrow1445853windrow
xenon122612453xen__on

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027956.40620922.1
3Display Results95950.0462065.2
 (SQL Overall)178691956.60827041.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.