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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
decibel123599(None) 
decibels1344521decibels
decide104116872decide_
decided124312422decided
decider114213182decider
decides114217652decides
decile94619212decile_
deciles104417722deciles
decimal1238082decimal
deckel134911042dec_kel
aecial84817313aeci_al
cibol9512023__cibol
dacite91115883dacite_
dacites101114593dacites
deaired9411533deaired
debited113311623debited
decadal1137243decadal
decade104216163decade_
decades113615513decades
decal85523233dec__al
decanal1038113decanal
decane93818873decane_
decanes103118913decanes
decare93919153decare_
decares102818533decares
decayed14309333decayed
decayer13339353decayer
deceive1337813deceive_
deceived1535893deceived
deceiver1436233deceiver
deceives1437903deceives
deciare10710663deciare
deciares11510633deciares
decidable1547223decidable
decidedly1743523decidedly
deciders123510753deciders
decidua1144493decidua
decidual1244203decidual
decimals1345863decimals
decipher1644423decipher
decked145217623dec_ked
deckels14367363dec_kels
decker135215993dec_ker
deckle1312012453deckle_
deckles143312803deckles
decline103716613decline_
declined123910883declined
decliner113710843decliner
declines113315803declines
decode104414743decode_
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
decoyed14358333decoyed
decoyer13348683decoyer
decree93117783dec_ree
decreed112710253decreed
decreer10269123decreer
decrees102513123decrees
decrial10310323decrial
decried112612853decried
decrier102713553decrier
decries103319803decries
decuple1285363decuple
deducible1543393deducible
defied115016383defi_ed
defier105118653defi_er
defies104624053defi_es
defile105216663defile_
defiled124013103defiled
defiler113911883defiler
defiles114016843defiles
define104718143define_
defined123813823defined
definer114413773definer
defines114118683defines
defuel10348933de_fuel
deice84320033de_ice_
deiced104214483de_iced
deicer94114413de_icer
deices94119373de_ices
deicidal1245713deicidal
deicide1149403deicide_
deicides1249303deicides
deil56231623de_i__l
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
deliver113312243deliver
demies94825803demi_es
demirep1236213demirep
demise94618323demise_
demised113613683demised
demises103719563demises
deniable11312083deniable
denial74720513deni_al
denied84318633deni_ed
denier74420693deni_er
denies74729643deni_es
denimed1159233denimed
denizen1737663denizen
derbies103016053derbies
deride84420033deride_
derided102914253derided
derider93214973derider
derides93420853derides
derive103817043derive_
derived123912763derived
deriver114213913deriver
derives114017813derives
describe1346243describe_
described1544953described
describer1444613describer
describes1446003describes
desire7415303desire_
desired9311983desired
desirer8310783desirer
desires81316133desires
devel94217123de__vel
device124512163device_
devices133212583devices
devil94714733devi__l
deviled124112183deviled
devisal1136913devisal
devise104215753devise_
devised123712563devised
devisee113812713devisee
deviser114212393deviser
devises114116763devises
dewier104013463dewi_er
dexie134716893dexi_e_
dexies145018343dexi_es
dicier94416233dici_er
diel59034603d__i_el
djebel1643453d_jebel
docile94213123docile_
docilely1443993docilely
dreidel934473dreidel
drivel105110383d_rivel
edible969353_edible
educible1344433educible
fecial114714623feci_al
fencible1545603fencible
jebel145612143je__bel
jezebel2541923jezebel
legible1035833legible
libel74116103__libel
pedicel1237813pedicel
rebel73421293re__bel
recipe103414893recipe_
recipes113314463recipes
recital9412163recital
recite83625113recite_
recited104319103recited
reciter94117263reciter
recites93524583recites
relabel938163relabel
seidel7311083se_idel

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271587.04619021.7
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.49923828.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.