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

121 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
decadal113724(None) 
decanal1038111decanal
decade104216162decad_e
decades113615512decades
decal85523232dec__al
decapodal1552632decapodal
decidual1244202decidual
decimal1238082decimal
decrial10310322decrial
dedal75719022de__dal
deicidal1245712deicidal
acaudal1045783_acaudal
aecial84817313aec_ial
aecidial1147253aecidial
beheadal1442813beheadal
bemadam1445773bemadam
bicaudal1343423bicaudal
cabal95222153__cabal
canal75428043__canal
caudal91611483__caudal
cecal94619113cec__al
ceramal1138843ceramal
cicada1136413cicada_
cicadae1244853cicadae
cicadas1235993cicadas
dada66422443d__ada_
dadas75819863d__adas
daedal849083d_aedal
dead65434243de_ad__
deaden83714323de_aden
deader84220473de_ader
deadfall1343313de_adfall
deadly113811473de_adly
deadman11238423de_adman
deadpan11225233de_adpan
deads75726913de_ad_s
deal56347413de___al
deasil71110983de_asil
decadent1249003decadent
decaf114919443dec__af
decafs124010883deca_fs
decagon1135863decagon
decagonal1343723decagonal
decagram1444653decagram
decalog1136003decalog
decals93717713deca_ls
decamp1338453deca_mp
decamps1435643decamps
decane93818873deca_ne
decanes103118913decanes
decant93524223deca_nt
decants103514443decants
decapod1335433decapod
decapodan1552223decapodan
decare93919153deca_re
decares102818533decares
decay114718483dec__ay
decayable1745623decayable
decayed14309333decayed
decayer13339353decayer
decays124612913deca_ys
decibel1235993decibel
decidable1547223decidable
decide104116873decid_e
decided124312423decided
decider114213183decider
decides114217653decides
decidua1144493decidua
deciduae1243743deciduae
deciduas1243463deciduas
decimals1345863decimals
deckel134911043dec_kel
declaw1266703dec_law
decode104414743decod_e
decoded123212383decoded
decoder113712293decoder
decodes113914983decodes
decretal1146353decretal
decrials1137133decrials
decuman1236573decuman
defrayal1542613defrayal
denial74720513de_nial
dental74319173de_ntal
deodar837713de_odar
deposal1037153deposal
derail74218813dera_il
dermal93614343de_rmal
detail74516433deta_il
devisal1136913devisal
dextral1577003dextral
ducal84816423duc__al
ductal938993duc_tal
fecal105119213fec__al
fecial114714623fec_ial
feudal1037683fe_udal
gelada837623gelada_
geladas936313geladas
geoidal936713geoidal
gonadal956523gonadal
hadal95518123__hadal
hematal1238953hematal
incudal1045863incudal
jemadar1743373jemadar
macadam1446853macadam
meatal84114733me_atal
medal86221333me__dal
megadeal1243473megadeal
monadal1047893monadal
pedal86022503pe__dal
precaudal1443413precaudal
precaval1544723precaval
recall83815723reca_ll
recital9412163recital
recoal84117973rec_oal
rectal84418133rec_tal
recusal968673recusal
scandal1038673_scandal
seconal9310073seconal
sendal73314993se_ndal
tectal83713253tec_tal
tetanal738023tetanal

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.406440125.6
2DLD Change Limit1340271215.82623005.0
3Display Results1211210.0333666.7
 (SQL Overall)1786911216.26528522.1
 
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.