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

108 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
decalog113600(None) 
decalogs1245631decalogs
beclog1136862bec_log
decagon1135862decagon
decal85523232decal__
decalogue1343252decalogue
decals93717712decal_s
decapod1335432decapod
decolor1087032decolor
demagog1243852demagog
dialog837972d_ialog
analog7159973_analog
backlog1635773backlog
becalm1239203becal_m
becalms1335743becalms
beclogs1237073bec_logs
calo64936443__calo_
calos74431903__calos
catalog1038003catalog
cecal94619113cecal__
cecally1459393cecally
clog76123243__c_log
colog86619933__colog
deacon9510423de_acon
deal56347413de_al__
dealer74122143de_aler
dealing94323233de_aling
deals65435343de_al_s
dealt65234283de_al_t
debag94212303deba__g
decadal1137243decadal
decade104216163deca_de
decades113615513decades
decaf114919443deca__f
decafs124010883deca_fs
decagons1235893decagons
decalogues1443253decalogues
decamp1338453deca_mp
decamps1435643decamps
decanal1038113decanal
decane93818873deca_ne
decanes103118913decanes
decant93524223deca_nt
decants103514443decants
decapods1444623decapods
decare93919153deca_re
decares102818533decares
decathlon1542573decathlon
decay114718483deca__y
decayed14309333decayed
decayer13339353decayer
decaying15239453decaying
decays124612913deca_ys
decile94619213decil_e
deciles104417723deciles
decking153915593decking
deckle1312012453deckl_e
deckles143312803deckles
declaim1247363declaim
declare10411223declare
declass1038733declass
declaw1266703dec_law
declaws1336253declaws
deco76125973dec__o_
decolors1187713decolors
decolour1185013decolour
decor84717573dec__or
decos85522123dec__os
decoy115716313dec__oy
dedal75719023dedal__
defang1137753defa_ng
defog1048523de__fog
delator83015023delator
demagogs1343883demagogs
demagogy1642953demagogy
deploy1237583de_ploy
desalt7518313desal_t
desalts839573desalts
devalue1136013devalue
develop13145033develop
dialogs938103d_ialogs
ducal84816423ducal__
ducally13257413ducally
duolog835803d_uolog
ecology13218823_ecology
epilog976463_epilog
escalop1144783escalop
etalon648973_etalon
fecal105119213fecal__
hemagog1444073hemagog
idealogy1342943ide_alogy
magalog1144913magalog
oecology14227273oecology
pedagog12113763pedagog
pedalo93811153pedalo_
pedalos10329703pedalos
recall83815723recal_l
recalls92613623recalls
recatalog1241983recatalog
recolor978693recolor
seadog838743se_adog
secalose1046963secalose
semilog1046003semilog
unclog956603unc_log
weblog1234223we_blog
zealot15313473ze_alot
zocalo1735803zocalo_
zocalos1835393zocalos

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.390458182.1
2DLD Change Limit1340271085.94022563.5
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.36028096.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.