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

157 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
discord113999(None) 
discard11310211discard
discoed11312481discoed
discoid11311241discoid
discords1238591discords
disaccord1552622disaccord
discards1238912discards
disced104914652disc_ed
discern1038492discern
disco85616072disco__
discoids1239872discoids
discorded1438132discorded
discos94915212disco_s
disport101015952disport
distort81120332distort
misword1338412misword
ripcord1264462ripcord
viscoid1337022viscoid
abscond1244503abscond
accord1178843_accord
bicorn103610103bi_corn
bistort91216523bistort
cisco95112133cisco__
ciscoes113610733ciscoes
ciscos104711133cisco_s
cissoid1037343cissoid
concord12510343concord
cord76740923___cord
dastard9279703dastard
decor84717573d_ecor_
decors94017773d_ecors
descend11248153descend
descry1256183desc_ry
desmoid1137103desmoid
desorb95210203des_orb
despond1137513despond
diacid10310633diac_id
diamond1186113diamond
diaspora1154403diaspora
diaspore1166063diaspore
diced95824683di_c_ed
dicer85426423di_cer_
dicers94720743di_cers
dicked144920863di_cked
dicot85429093di_co_t
dicots94915793di_cots
diehard1237053diehard
diploid11310293diploid
disaccords1652113disaccords
disarm9310473dis_arm
disband1138243disband
disbar938513disbar_
disbars10310323disbars
disbound1245853disbound
disbud10165713dis_bud
disc76123233disc___
discant103017263discant
discarded1437083discarded
discarder1346753discarder
discase102912863discase
discased122510853discased
discept12310623discept
discerned1347863discerned
discerns1138163discerns
disci85815023disc__i
disciform1744123disciform
discing113914593discing
disclose1148743disclose
disclosed1347363disclosed
discoidal1355413discoidal
discoing12511453discoing
discolor1146423discolor
discolored1445623discolored
discolors1246593discolors
discordant1445423discordant
discording1547663discording
discount11811313discount
discourse1246863discourse
discoursed1445793discoursed
discover1439563discover
discovered1765883discovered
discovers1538153discovers
discovert1548793discovert
discovery1845273discovery
discrown1445283discrown
discs85316263disc__s
discus94512113disc_us
discuss10357953discuss
diseur738843diseur_
diseurs839403diseurs
disgorge1145733disgorge
disgorged1345263disgorged
dished114318713dis_hed
disjoin1547643disjoin
disked125015763dis_ked
disorder1038133dis_order
disown1036953dis_own
dispart101115283dispart
dispend11289413dispend
disported13310303disported
disports111111113disports
dispose10312763dispose
disposed12310943disposed
disrobe1038993disrobe
disrobed1238093disrobed
disroot8413563disroot
dissed85220183dis_sed
dissert83720693dissert
distend93312073distend
distome10313233distome
distorted1139373distorted
distorts91112353distorts
disturb1046233disturb
disused93211033disused
disyoke1546233disyoke
disyoked1745463disyoked
ditched143711903ditched
dittoed936733dittoed
escort84616483_escort
fiord94313343fi__ord
histoid1139823histoid
history1339423history
milord999573mi_lord
miscode12310413miscode
miscoded1437983miscoded
miscoin11311433miscoin
miscook1546473miscook
miscopy1636663miscopy
miscued1239293miscued
misform1437513misform
misrecord1443913misrecord
missort9314653missort
miswords1446603miswords
piscary1437423piscary
pisco96314983pisco__
piscos105112593pisco_s
record96117433_record
rescore95616203rescore
rescored114513103rescored
ripcords1344073ripcords
scold85414863__scold
score75526743__score
scored94621133__scored
scorn75817453__scorn
scrod85115073__scrod
sord56237203__s_ord
sword95214123__sword
visard103910123vis_ard
viscera1235083viscera
viscid1237473visc_id
viscose1237863viscose
viscous1238833viscous
visor82512833vis_or_
visored1138143vis_ored
visors92912223vis_ors
whipcord1942353whipcord
zincoid1946663zincoid

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.403443402.0
2DLD Change Limit1340271576.76619808.9
3Display Results1571570.0463413.0
 (SQL Overall)1786911577.21524766.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.