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

138 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
decanal103811(None) 
decadal1137241decadal
canal75428042__canal
decagonal1343722decagonal
decal85523232dec__al
decane93818872decan_e
decanes103118912decanes
decant93524222decan_t
decants103514442decants
decimal1238082decimal
decrial10310322decrial
seconal9310072seconal
tetanal738022tetanal
aecial84817313aec_ial
anal48037523___anal
anconal939423anconal
arcana8912583arcana_
banal75925993__banal
cabal95222153__cabal
canals84421663__canals
cantal84122033__cantal
carnal83919203__carnal
cecal94619113cec__al
ceramal1138843ceramal
deal56347413de___al
dean56039483de_an__
deaned84620453de_aned
deans66131393de_an_s
deasil71110983de_asil
decade104216163deca_de
decades113615513decades
decaf114919443dec__af
decafs124010883deca_fs
decagon1135863decagon
decagram1444653decagram
decalog1136003decalog
decals93717713deca_ls
decamp1338453deca_mp
decamps1435643decamps
decanted122310493decanted
decanter112510793decanter
decapod1335433decapod
decapodal1552633decapodal
decare93919153deca_re
decares102818533decares
decay114718483dec__ay
decayable1745623decayable
decayed14309333decayed
decayer13339353decayer
decays124612913deca_ys
decenary1446273decenary
decency1537453decency
decennial1244823decennial
decent94023703decen_t
decently1448013decently
decibel1235993decibel
decidual1244203decidual
decimals1345863decimals
deckel134911043dec_kel
declaw1266703dec_law
decretal1146353decretal
decrials1137133decrials
decuman1236573decuman
dedal75719023de__dal
dedans85915073dedan_s
defang1137753defan_g
defangs1235363defangs
defrayal1542613defrayal
deicidal1245713deicidal
demand104314253deman_d
demands114311413demands
denar65223293de__nar
denial74720513de_nial
dental74319173de_ntal
dentinal939503dentinal
deposal1037153deposal
derail74218813dera_il
derange939813derange
dermal93614343de_rmal
desand84812633desan_d
desands94810163desands
descant104315583descan_t
descants112910143descants
detail74516433deta_il
devisal1136913devisal
dewan95718043dewan__
dewans105215143dewan_s
dextral1577003dextral
diaconal1196133diaconal
diurnal844883diurnal
ducal84816423duc__al
ductal938993duc_tal
encinal949243encinal
fecal105119213fec__al
fecial114714623fec_ial
geminal10109903geminal
geranial949283geranial
hematal1238953hematal
jacana1537933jacana_
jacanas1638263jacanas
jejunal1342833jejunal
lacunal9136553lacunal
meatal84114733me_atal
olecranal1152203olecranal
pecan91919033pecan__
pecans101515833pecan_s
penal75228373pe__nal
preanal9310713preanal
precaval1544723precaval
recall83815723reca_ll
recane83022873recan_e
recaned102817203recaned
recanes93222263recanes
recant83228683recan_t
recants93217093recants
recital9412163recital
recoal84117973rec_oal
rectal84418133rec_tal
recusal968673recusal
reginal84814293reginal
regnal74812933re_gnal
renal55929503re__nal
repanel939963repanel
retinal75318353retinal
scandal1038673_scandal
secant84023293secan_t
secantly1345983secantly
secants93413893secants
seconals1047053seconals
seminal91213403seminal
tectal83713253tec_tal
uncinal959963uncinal
veinal93812963ve_inal
venal85523213ve__nal
vernal93514213ve_rnal
vicinal12268543vicinal
zenana15297983zenana_
zenanas16286233zenanas

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.423422437.4
2DLD Change Limit1340271386.68620045.9
3Display Results1381380.0463000.0
 (SQL Overall)1786911387.15524974.3
 
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.