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

207 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
accord117884(None) 
accords1247241accords
accorded14155352accorded
accorder1395242accorder
accost101112262accost
acold86214932a_cold
acorn75616622a_corn
actor71116072actor_
actors81016762actors
afford1346492afford
chord115917262_chord
cord76740922__cord
record96117432record
abhor10411063abhor_
abhors11410623abhors
aboard9312613aboard
abort76133583a_bort
abroad9310943abroad
abscond1244503abscond
absorb1038013absorb
absurd935903absurd
acari75020283a_cari
acarid95017073acarid
acaroid103512313acaroid
accede1138303accede
acceded1336103acceded
accent105116263accent
accept123210623accept
access1037683access
accolade1346053accolade
accordant1445353accordant
accorders14144123accorders
according1545273according
accordion1443123accordion
accosted1345513accosted
accosts11107993accosts
account11109043account
accoutre1244203accoutre
accoutred1443363accoutred
accrue1035823accrue
accrued1233823accrued
accursed1354633accursed
accurst1146243accurst
accuse103411033accuse
accused12368423accused
aced79540883a_c_ed
acerb9312763a_cerb
ached119227833a_ched
achoo10315083acho_o
acid77533393a_c_id
aciform1446013aciform
acned87520673a_cned
acnode938203acnode
acock132110213a_cock
acorned10238273a_corned
acorns85013013a_corns
acre67330773a_c_re
acred87126353a_cred
acrid86920103a_crid
across8312643across
acted88521733a_cted
actorly1246413actorly
adore65723673a_dore
adored84714243a_dored
adorn64917093a_dorn
adsorb946953adsorb
afeard1058263afeard
affords1435023affords
afore85818603a_fore
agora6914333a_gora
ahold94714253a_hold
alcid85817973alc_id
alcove1178083alcove
alcoved1375613alcoved
algoid83011473algoid
algor6513053algor_
algors7312553algors
allod64418383allo_d
almond91410433almond
aloud65018073a_loud
amort75832203a_mort
anchor113911973anchor_
anchored1438593anchored
anchors123912953anchors
ancon75718233anco_n
ancone83916953ancone
angora71111573angora
apod78123183a_po_d
aport75432173a_port
arbor74818113arbor_
arbored103811603arbored
arbors84717883arbors
arced88224163arc_ed
arched125717323arched
arcked136211943arcked
arco68331543arco__
ardor64617863ardor_
ardors74416873ardors
armor75118053armor_
armored102610473armored
armors85017813armors
armory114211473armory
aroid65428343a_roid
ascared10399523ascared
ascarid103910723ascarid
ascend9429733ascend
ascot76522513asco_t
ascots85312513ascots
ashore9414613ashore
assort64916383assort
attorn6310793attorn
aurora6411763aurora
autoed7712823autoed
avoid95516683a_void
award97118043a_ward
baccara1347143baccara
bicorn103610103bicorn
byword1535053byword
cached145419203cached
cactoid12311033cactoid
caird85717233_caird
calory11312843calory
canard9314763canard
canoed94618963canoed
card710245873__card
cavort11316173cavort
ceorl7410923_ceorl
chard116124743_chard
chords125214633_chords
chore105126763_chore
chored125321883_chored
clod76124613_clo_d
cloud86716423_cloud
coccoid11299283coccoid
cod69660123__co_d
coed77140543__coed
cold77338773__cold
concord12510343concord
cooed84534343_cooed
cor59960943__cor_
cords86030623__cords
core67263113__core
cored85044223__cored
corf95941483__corf
cork106635693__cork
corm85735383__corm
corn69945813__corn
cors66656443__cors
cory96941513__cory
crore74922873_crore
crowd115815623_crowd
curd77634983__curd
decor84717573decor_
decors94017773decors
disaccord1552623disaccord
discord1139993discord
echard1249223echard
echoed125211153echoed
encore8314773encore
encored10412103encored
escort84616483escort
factoid1338693factoid
factor11911453factor_
factored1436223factored
factors12912123factors
factory15108343factory
fiord94313343_fiord
fjord16477023_fjord
ford86835493__ford
fucoid1237893fucoid
ichor1039483ichor_
ichors11310423ichors
locoed94312193locoed
lord55032083__lord
milord999573milord
mucoid1139783mucoid
mucor94011943mucor_
mucors104410853mucors
occur9137323occur_
occurs10136553occurs
oxford1763663oxford
raccoon1176163raccoon
rancor8810373rancor_
rancored1137223rancored
rancors9811373rancors
records105213923records
recork126315493recork
reword106321413reword
ripcord1264463ripcord
sarcoid10310453sarcoid
schorl1179813schorl
schrod1247883schrod
scold85414863_scold
score75526743_score
scored94621133_scored
scorn75817453_scorn
scrod85115073scro_d
second9411153second
sord56237203__sord
succor1036623succor_
succored13135173succored
succors1137413succors
succory1444643succory
sword95214123_sword
uncork1239043uncork
warlord1136293warlord
word89832003__word

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162075.17321789.3
3Display Results2072070.0633285.7
 (SQL Overall)1786912075.60931857.9
 
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.