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

275 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
cordial1031294(None) 
cordials1139621cordials
cardia9916372cardia_
cardiac1278812cardiac
cardiae10713702cardiae
cardias10715112cardias
cardinal1139562cardinal
chordal13449882chord_al
chorial124214142chor_ial
coaxial16157002coaxial
conidial1159502conidial
coral76033452cor__al
cordially1547472cordially
cording113620822cording
cordite10315262cordite
coria75828322cor_ia_
corneal94414502corneal
cornual94210172cornual
coronal94115762coronal
corral83616252cor_ral
corrival1346152corrival
cortical12412212cortical
coryzal2154822coryzal
cotidal1038462cotidal
curial84019152cur_ial
exordial1645312exordial
ordeal779252_ordeal
ordinal838632_ordinal
acromial1248463acromial
aerial64625713aer_ial
alodial899953alodial
aortal65217513aor_tal
atrial65418943atr_ial
audial7312993_audial
biradial1167713biradial
boral75831703bor__al
bordel94514573bord_el
boreal84817213bor_eal
borstal939043borstal
bridal9511453_bridal
burial84117623bur_ial
cambial134010763cambial
candidal12367733candidal
caracal11312513caracal
cardiacs1376913cardiacs
cardigan1245613cardigan
cardinals1247993cardinals
carding113922433carding
cardio9915673cardi_o
carinal94318233carinal
carnal83919203car_nal
carnival1345613carnival
carpal103716253car_pal
caudal91611483caud_al
ceramal1138843ceramal
cercal10314123cer_cal
cereal8315833cer_eal
ceria75125353cer_ia_
cerias83321983cer_ias
cervical1546853cervical
choral115118493chor__al
chording15410153chording
choreal124412223chor_eal
choroidal1544673choroidal
coaeval1245183coaeval
coal66939253co___al
coastal9411043coastal
coaxal15387303co_axal
cobia94117513co_bia_
cobias104014993co_bias
coccal9310223co_ccal
coda77029343co_d_a_
codas84724243co_d_as
codding124014693codding
codeia94112193codeia_
codeias103911223codeias
codicil1246813co_dicil
codify1537163co_dify
coding104024793co_ding
codrive1337653codrive
coedit9316243coedi_t
coedits10310243coedits
coeliac1138233coeliac
coequal1844933coequal
coeval1138893co_eval
coil66439653co__i_l
coital84117053co_ital
coldish1399303coldish
colonial10411343colonial
comal95125133co__mal
comedian1347453comedian
comical13312223comical
comitial1248693comitial
conceal113313013conceal
conchal144211583conchal
condign1147733condign
congeal104011683congeal
conical11316203conical
conidia1069303conidia_
conidian1168383conidian
conoidal1149013conoidal
copal95621783co__pal
corals85325143cor__als
corban10314693cor_ban
corbeil11859213corbeil
corbel103715973cor_bel
corbie103618203corbi_e
corbies113520123corbies
corbina111911453corbina
corbinas12229393corbinas
cord76740923cord___
cordage11310063cordage
cordate10315223cordate
corded105923353cord_ed
cordelle1148433cordelle
corder94322883cord_er
corders104520883corders
cordiality1645613cordiality
cordings123011353cordings
cordites11314623cordites
cordlike1537233cordlike
cordoba1255743cordoba
cordobas1345803cordobas
cordon95017293cord_on
cordons104415763cordons
cordovan1444293cordovan
cords86030623cord__s
cordwain1444413cordwain
coreign1037343coreign
coremia11310363coremia_
corgi8316083corgi__
corgis9314413corgi_s
coring94433963cor_ing
corium10315723cor_ium
corkier133114303corkier
corking143018823corking
cormel103815603cor_mel
cornball1247053cornball
cornea84018923cornea_
corneas94717003corneas
cornel84020053cor_nel
cornice11612933cornice
cornicle1258783cornicle
cornier93017093cornier
cornify1536253cornify
cornily12410853cornily
corning103720123corning
cornmeal1245853cornmeal
cornua85411903cornua_
corodies11313693corodies
corolla938623corolla
corona83817403corona_
coronae94214893coronae
coronals103312893coronals
coronas93916913coronas
coronel94515223coronel
corporal1248513corporal
corrals93713853cor_rals
corrida1078503corrida
corridas1177313corridas
corrie83621223corri_e
corries94026793corries
corrivals1444613corrivals
corsac10410173cor_sac
corsair937633corsair
cortin82423153corti_n
cortina91915973cortina
cortinas102212443cortinas
cortins92421333cortins
cortisol1045403cortisol
corvid12310473corvi_d
corvids1337683corvids
corvina12229503corvina
corvinas13238013corvinas
corvine122113643corvine
coryza2074583coryza_
coryzas2134803coryzas
cosmical1448013cosmical
costal85419513co_stal
cowgirl1353273cowgirl
coxal146116673co__xal
craal74117753c_r_aal
cranial92114683cranial
credal9311673c_redal
crucial1157893crucial
crural8610633c_rural
curdier103312623curdier
curding113515133curding
curia74523773cur_ia_
curiae84518373cur_iae
curtail9299663curtail
curtal83914543cur_tal
dial55935063___dial
dorsal74613943dor_sal
ecocidal1354963ecocidal
exordia1544983exordia_
ferial94621253fer_ial
forbidal1444833forbidal
fordid113512053fordi_d
fording123717043fording
formal113215203for_mal
fornical1347793fornical
gonadial1066823gonadial
gonidial1065943gonidial
goral65125753gor__al
gordita945093gordita
gorditas1043923gorditas
hernial10310433hernial
horal86328683hor__al
hording123517053hording
jordan1468063jord_an
jovial1636543jo_vial
lochial1257083lochial
loral55927823lor__al
lording93115233lording
loreal63814313lor_eal
martial92415413martial
medial93819863_medial
misdial1039643misdial
modal85919243mo_d_al
morainal1047203morainal
moral75533433mor__al
mortal84616853mor_tal
narial6317953nar_ial
nodal64717793no_d_al
nodical1049863no_dical
nordic939473nordi_c
noria55722183nor_ia_
norias65518203nor_ias
normal83213533nor_mal
oedipal1045173_oedipal
oidia6314953_oidia_
oral47638123_or__al
orbital936923_orbital
ordain7810403_ordain
ordeals877993_ordeals
ordinals946753_ordinals
orgiac934993_orgiac
oriel54920423_or_iel
partial92616263partial
peridial11411923peridial
podia8415283po_dia_
portal84218463por_tal
predial103815413predial
prodigal1246003prodigal
radial74020393_radial
redial74923113_redial
rial45938093__r_ial
rorqual1663573rorqual
scoria8513503scor_ia_
scoriae9310903scor_iae
serial64625863ser_ial
social8813333so_cial
sordid83411163sordi_d
sordidly1344663sordidly
sordine82515233sordine
sordini8228963sordini
sordino8219443sordino
sororal7310653sororal
sundial859863sundial
tertial7313863tertial
toroidal966393toroidal
trial54926353_tr_ial
uredial82910483uredial
urial54823023_ur_ial
uxorial1446323uxor_ial
vortical1348863vortical
wordier112511213wordier
wordily1437853wordily
wording123014563wording
wormil1138043wormi_l
zoarial1646923zoarial
zodiac1835303zo_diac
zooidal1745093zooidal
zoril143916693zor_i_l

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.406440125.6
2DLD Change Limit1340272756.98319193.3
3Display Results2752750.0932957.0
 (SQL Overall)1786912757.48223882.8
 
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.